My query is .
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