Thursday, February 28, 2013

[OBIEE 10g] Using Repository Session And Presentation Variable In Title - Subtitle - Narratives

 


Using Repository Session and Presentation Variable in Title/Subtitle/Narratives

 

Sometime Business demands to show the Repository Session and Presentation variable in Title , Subtitle , Narrative etc . Now let see the way to achive this :


Using Presentation Variable in Title , Subtitle , Narratives


Defined a variable called ‘var_ename’ as Presentation Variable.





Define the title with ‘var_ename’ and use it as below : @{var_ename} .Also same can be defined in Subtitle and Narrative .





The default looks of the report will be below where Ename has been “Is prompted”  in report criteria.





After choosing the prompt Title, Subtitle and Narrative would be changing automatically :


 



Using Repository Session Variable in Title,Subtitle,Narratives


Customer requirement was to show dynamically the Currency type of the country in report title to show the Sales currency of the individual country in multi national deployment in the same report .


To achieve this I have written a Session variable initialisation block called “Country_Int” and return the currency value for the user from LOV type and make a Non-System session variable target called “CURRENCY” .


Now in my Sales Report it has been picked up by Presentation services after defining the below syntax under Subtitle :


The currency displayed is @{biServer.variables['NQ_SESSION.CURRENCY']}.






Similarly variable could be used in Narratives as RPD dynamic variable  ‘var_country’ added under Prefix section of the BI Narrative view . 










No comments:

Post a Comment