I am not sure whether this topic has been covered or not for Webi Reports. I checked and did not found any links to it hence mentioning it in here.
I had a requirement of a report showing revenue and margin based on some dimensions. What I wanted was to have those dimensions as input control in the report.
Like we have the values of certain dimensions as input control, instead I succeeded in getting number of dimensions as input control.
Below are the steps to achieve the same.
=If ReportFilter([Select a Dimension]) = "Sales Office" Then [Sales Office]
ElseIf ReportFilter([Select a Dimension]) = "Division" Then [Division]
ElseIf ReportFilter([Select a Dimension]) = "MR Number" Then [MR Number]
ElseIf ReportFilter([Select a Dimension]) = "Material Group" Then [Material Group]
Else 0
Remember to remove all the dimensions from the report body which you have used in the Input variable or else it would get confusing.
Now you have the input variables working for you:
Selected below is “Sales Office”
“Division” is selected:
To ensure the header name also changes along with the selection:
=If ReportFilter([Select a Dimension]) = "Sales Office" Then "Sales Office"
ElseIf ReportFilter([Select a Dimension]) = "Division" Then "Division"
ElseIf ReportFilter([Select a Dimension]) = "MR Number" Then "MR Number"
Once this is done whenever you would select a dimension from the Input Control the header name would change dynamically.
Note: Please ensure that spellings match while writing the formulas or else the values might not come properly.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |