You can use variables in a repository to streamline administrative tasks and modify metadata content dynamically to adjust to a changing data environment.
A variable has a single value at any point in time. Oracle BI Server substitutes the value of a variable for the variable itself in the metadata.
You use the Variable Manager to define variables and initialization blocks.
There are three classes of variables
1.) Repository variables
2.) Session variables
3.) Presentation Variable
Repository variables
A repository variable has a single value at any point in time.
There are two types of repository variables
· Static and
· Dynamic
Static repository variables
A static variable have values that are constant and does not change while Oracle BI Server is running.
Dynamic repository variables
It has values that are refreshed by data returned from queries in initialization blocks.
Session variables
Session Variables are created and assigned a value when each user logs on.
There are two types of session variables
· System
· Non system
System variables
They have reserved names and are used for specific purposes by Oracle BI Server, such USERS, GROUP, PORTALPATH etc.
Non-system variables
They are application-specific variables created by an Administrator.
Presentation Variable
Presentation variables are created in the dashboard prompts and can be used in reports and dashboards.
Initialization blocks
These are used to initialize dynamic repository variables, system session variables, and non system session variables
Posts
