Business Intelligence – Oracle

Archive for February 21st, 2008

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

TOPN(SALES1.Sales,@{test}{5})

      

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.

      

      

Posted in All Posts, OBI EE Plus | 8 Comments »