1) Repository - a) Static
b) Dynamic
2) Session - a) System
b) Nonsystem
3) Presentation
Repository and Session variables are created and configured in rpd and can be called in reports. Presentation variable can only be created and called in reports/dashboards.
1) Repository:
Changes made to repository variables reflect only after restarting BI server.
a) Static- As the name suggests these variables represent the static values that are default and do not change unless the user changes.
Examples : Currency Code –‘USD’, DSN=’DSN_0314’, ‘US_English’
In order to create a static variable goto> Manage à Variables
Action>new>Repository>Variable> give name, select static and give default intializer.
b) Dynamic- These variables are dynamic and do change with time. They are scheduled variables which run according to the scheduled time/whenever BI server is on. Initialization block is used to populate these variables.
Ex: Current_Date, Current_month, last refresh date (predefined).
2) Session:
Session variables are initialized at log in and are cleared at logout.
a) System- These variables are system defined reserved variables that cannot be changed by the user. User and Group variables are used for Authentication and Authorization purposes. I would be posting on EBS-OBIEE integration step by step procedure very soon.
Ex: User, Group, log level, password, web language.
b) Nonsystem- These variables are populated by Init blocks and are valid for that respective session only.
Ex: Primary position Id, Primary owner Id, Primary Organization Id.
