Translate

Friday, 2 December 2011

Session Variable set for Report only that is running

THESE ARE SET AT QUERY LEVEL FOR A REPORT OR PROMPT RESULTS ONLY

If you want to set session variables for a report that is running  in OBIEE then create an answers report and goto the Advanced tab of the Answers report or Dashboard Prompt

Under "prefix" paste the code below with your session variable name and either a variable from a prompt or a value

SET VARIABLE sessionv1= '@{prompt1}',sessionv2= '@{prompt2}{2011-01-01}',sessionv3= '@{prompt3}';

sessionv1 is the session variable name in RPD
prompt1 etc are the variable in names in my dashboard prompts
2011-01-01 is just a static value im passing this could have also been a prompt presentation variable

Remeber you will not see the session variable change in the sessions window in RPD but it will take effect. 

No comments:

Post a Comment

Google Big Query Clone / Copy DataSets / Tables - PROD --> TEST --> DEV Projects

Google Big Query Cloning of Datasets & Tables across GCS Projects. We searched the internet and could not find a simple cloning / ...