Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

How to use Presentation variable value used in Dashboard prompt into sql query of initialization bl

Manish SutharMay 13 2014 — edited May 14 2014

Hi Guys,

   My query is .

IN RPD:

I have created one session variable say VAR_SES which is derived using initialize block query as below in RPD .

         

                     SELECT column1 FROM table1 WHERE column2 = VALUEOF(NQ_SESSION.Range) ;

where in above query "VALUEOF(NQ_SESSION.Range)" using this i m trying to use dashboard prompt value .but it is not working

IN BI ANSWER:

I have created one dashboard prompt  using presentation variable (Let's Say "Range") which contain the values from 1 to 52 and it is choice list .Now when user choose any value from prompt that value i want to use in RPD initialization block to change value of session variable dynamically at  run time .

Thanks in Advance

Comments
Locked Post
New comments cannot be posted to this locked post.