Wednesday, January 2, 2013

presentation Variable across Dashboard page and subject area in Prompt 11g


 1) Log into the Business Intelligence analytics with the link 
    http://Machine_name:port/analytics
    The port will be 7001 if OBIEE install with simple install option with default portconfiguration or it will 9704 if
     OBIEE is install with enterprise option default port
2) Click on New-> Dashboard Prompt


3) Select the column prompt


4) Select the Column Calendar Date from Sample Sale Lite subject area

5) Set the presentation variable Date and save it


6) Then go for another prompt and select variable prompt this time

 
7) Do the setting as shown below, in user input select the choice list, in choice list value select
    All column values and then click on select column(select desired column you want)
 
8) Pass the presentation variable created earlier and save it

    
9) Now pull both the prompt on same Dashboard page or we can pulled it on different page also


10) Select one of the Date and click on apply button the other prompt will also change with
       selected Date in prompt one as default value