BI Experts -
I have a custom report using the Supporting Reference Balances OTBI Subject Area in Fusion.
I created a presentation variable dashboard prompt that has two values: Debit and Credit. I want to use this to allow the user to select which measure columns appear in the report.
For example, if the user selects Debit, then the report should display all the debit measures, i.e. Beginning Balance DR, Period Balance DR etc. If the user selects Credit then the report should display Beginning Balance CR, Period Balance CR etc.
Can you offer any suggestions and/or syntax to control which measure columns appear based on the value of the presentation variable?
thanks in advance...
If you can divide up the measures into 2 different analysis, you can do something like this: http://obiee101.blogspot.com/2010/07/obiee-using-prompt-as-report-selector.html