Oracle BI EE 10.1.3.3/2 – Presentation Variables in TOP filter
Posted by Venkatakrishnan J on February 21, 2008
I got an email in one of our help lists today stating that Answers does not seem to accept presentation variables in TOP filter. If you are not sure what i mean, look at the screenshot below.
So, basically the user wanted to have a filter like “Sales is in TOP N” where the N would be populated by a presentation variable from a dashboard prompt. Lets look at a workaround today to achieve the same. Lets start with creating a simple report containing 3 columns Country, City and its corresponding Sales.
Now, lets create another column with the below formula
What this does is it creates a TOPN aggregation on the column. test is our presentation variable and 5 is the default value of the presentation variable.
Now, create a filter on the newly created column as shown below
So, basically your final filter will look like the one shown below
This filter is equivalent to the one that we tried first (where we got the error). Now create a dashboard prompt with a column formula as shown below
CASE WHEN 1=0 THEN GEOGRAPHY.COUNTRY_NAME ELSE ‘Test’ END
Make this prompt to set the presentation variable test
Now, you should be able to pass the presentation variables to the report.