What are the two types of Session Variables?
A.
System
B.
Non System
C.
Static
D.
Dynamic
Explanation:
There are two types of session variables:
System A session variable that the Oracle BI Server and Oracle BI Presentation Services use
for specific purposes.
System session variables have reserved names that cannot 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.
The administrator creates non-system session variables using the Oracle BI Administration Tool.
Note: 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 a session variable and initializes it.
There are as many instances of a session variable as there are active sessions on the Oracle BI
Server. Each instance of a session variable could be initialized to a different value.
A, B
static repository variable: keep the initialized value till administrator made change with it.
dynamic repository variable: run a query within initialization block to retrieve the variable value.