Variables:
We can reference variables in several areas of OBIEE,Including in analyses,dashboards,KPIs,actions,agents and conditions.
They are four types of variables:
1.Session.
2.Repository.
3.Presentation.
4.Request.
Session Variables:
A session variable is a variable that is initialized at login time for each user.When a user begins a session,the Oracle BI Server creates a new instance of session variable and initializes it.
A system variable that the administrator creates and names.For example- Admin creates a salesregion non-system variable that initializes the name of a user's sales region.
There are many instances of a session variables as there are active sessions on the oracle Bi server.
Each instance of a session variable could be initialized to a different value.
There are two types of session variables:
1.System-- A session variable that the Oracle BI server and Oracle BI Presentation services use for specific purposes.
System session variables have resrved names that can not be used for other kinds of variables such as static or dynamic repository variables and non-system session variables.
Non-system-A system variable that the administrator creates and names.For example,the administrator might create a salesregion non-system variable that initializes the name of a user's sales region.
Repository variable: A repository variable is a variable that has a single value at any point in time.
There are two types of repository variables:
1.Static-- Repository variable whose value persist and do not change until the administrator decides to change them.
2.Dynamic- Repository variable whose values are refreshed by data returned from queries.
Presentation Variables:A presentation variable is a variable that you can create as part of the process of creating one of the following types of dashboard prompts.
1.Column Prompt--A presentation variable created as part of a column prompt is associated with a column,and the values that it can take from the column values
We can reference variables in several areas of OBIEE,Including in analyses,dashboards,KPIs,actions,agents and conditions.
They are four types of variables:
1.Session.
2.Repository.
3.Presentation.
4.Request.
Session Variables:
A session variable is a variable that is initialized at login time for each user.When a user begins a session,the Oracle BI Server creates a new instance of session variable and initializes it.
A system variable that the administrator creates and names.For example- Admin creates a salesregion non-system variable that initializes the name of a user's sales region.
There are many instances of a session variables as there are active sessions on the oracle Bi server.
Each instance of a session variable could be initialized to a different value.
There are two types of session variables:
1.System-- A session variable that the Oracle BI server and Oracle BI Presentation services use for specific purposes.
System session variables have resrved names that can not be used for other kinds of variables such as static or dynamic repository variables and non-system session variables.
Non-system-A system variable that the administrator creates and names.For example,the administrator might create a salesregion non-system variable that initializes the name of a user's sales region.
Repository variable: A repository variable is a variable that has a single value at any point in time.
There are two types of repository variables:
1.Static-- Repository variable whose value persist and do not change until the administrator decides to change them.
2.Dynamic- Repository variable whose values are refreshed by data returned from queries.
Presentation Variables:A presentation variable is a variable that you can create as part of the process of creating one of the following types of dashboard prompts.
1.Column Prompt--A presentation variable created as part of a column prompt is associated with a column,and the values that it can take from the column values
No comments:
Post a Comment