cancel
Showing results for 
Search instead for 
Did you mean: 

I can not use a dimension variable (with reportfilter) for ranking a field in cross table

0 Kudos
243

Hello,

I have created the following Dimension variable:

[Selected Dimension] 
               =If ReportFilter([Select Evaluated KPI]) = "Band 1" Then [Channel]
               ElseIf  ReportFilter([Select Evaluated KPI]) = "Band 2" Then [Column 1]
               ElseIf ReportFilter([Select Evaluated KPI]) = "Band 2" Then [Column 2]
               ElseIf  ReportFilter([Select Evaluated KPI]) = "Band 3" Then [Column 3]
               ElseIf  ReportFilter([Select Evaluated KPI]) = "Band 4" Then [Column 4]
               ElseIf  ReportFilter([Select Evaluated KPI]) = "Band 5" Then [Column 5]   
               Else 0

When I use this [Selected Dimension] for ranking in a cross table it doesnt work.

On the other hand when I use the actual Column names (e.g. Channel, Column 1) then the ranking works fine.

It seems like WebI (SAP BO) doesnt like dimension variables with ReportFilter on 'Ranked by' section in 'Add Ranking'.

In my case, this dimension variable changes based on user selection from an input control , so I must have this one on 'Ranked By' section.

Is there any way to overcome this issue which seems like a WEBI bug for me.

Accepted Solutions (0)

Answers (0)