Initialisation Blocks

Variables - Variable Manager - Variable Types - Repository Variables - Static Repository Variables - Dynamic Repository Variables - Session Variables - System Session Variables -Non-System Session Variables - Initialization Blocks - Data Source Query - Testing– Initialisation blocks querying Excel- Relational Database

Standard

What are the different types of Variables that can be associated to an Initialisation Block?

Repository Variables and Session Variables

What are Repository Variables?

Repository Variables are populated when the OBIEE Server is started and are refreshed at their refresh interval. These variables are either Static or Dynamic

Static Repository variables holds constant values. The main purpose of these variables are its value is defined at one place and these variables can be used at various places in rpd.
Eg Datasource Name defined in Variables OLAP_DSN,OLTP_DSN.

Dynamic Repository Variables are those variables which are populated by a Initialisation block's SQL. These Initialisation blocks are fired when the OBIEE Server is started and are refreshed at their refresh interval.
eg DATE stored in variable CUR_DT
SQL : SELECT SYSDATE FROM DUAL

What is the difference between a Repository Variable and Session Variable?

Repository variables are those variables whose values are independant of user login.

Session variables are those variables whose values are dependant on user login. These variables are populated for a user when he Logs in.

What is the difference between System Session Variable and Non System Session Variable?

System Session Variables are predefined session variables used by OBIEE Server for specific purposes. eg USER, GROUP.

Non System Session Variables are Customised Session Variables. Eg User's Primary Position