on 2021 Feb 28 9:33 AM
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.
Request clarification before answering.
User | Count |
---|---|
52 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.