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.
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.
Note: only a member of this blog may post a comment.