Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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.
Post Details
Locked on Jun 11 2014
Added on May 13 2014
#bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #from, #of, #query, #server, #session, #to, #value, #variable
1 comment
429 views