Oracle BI EE 10.1.3.3/2 – Presentation Variables in TOP filter - OBIEE GURU

govtjobonline-Latest Government Jobs 2023 Recruitment Notifications

Latest Govt Jobs Whatsapp Group Links-Telegram

For Latest Govt Jobs 2023 or for Freejobalerts or Join

Latest Government Jobs 2023

Wednesday 25 January 2012

Oracle BI EE 10.1.3.3/2 – Presentation Variables in TOP filter


    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.
          
          

    Whatsapp group

    Govt Jobs Whatsapp Group Links 2023

    Telegram group

    Govt Jobs Telegram Group

    Facebook group

    Govt Job Online Facebook Group

    Follow on Facebook group

    Govt Jobs Online Facebook Page

    Subscribe to Youtube Channel

    Govtjobsonline Youtube

    Join Latest Govt Jobs Telegram Group here

    Join Government Jobs Whatsapp Group here (State Wise)

    Join State Wise Sarkari Results Telegram here

    1. ITI Jobs Notifications
    2. ITI Apprenticeship Program
    3. Diploma Jobs Notifications
    4. Engineering Jobs Notifications
    5. UPSC Jobs Notifications
    6. Court Jobs Notifications
    7. Staff Nurse Jobs Notifications
    8. NHM Jobs Notifications
    9. Exam Syllabus and Pattern
    10. SSC Recruitment

    No comments:

    Post a Comment

    Latest Govt Jobs Vacancy 2023