What is an example of a Session Variable?

What is an example of a Session Variable?

What is an example of a Session Variable?

A.
ETL Load Date

B.
User Organization

C.
OLAP DSN

D.
Top Customers by Revenue

Explanation:
Note 1: There are four types of variables that you can use:
Session
Repository
Presentation
Request
Note 2: 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.
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.



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Leo Yu

Leo Yu

a request variable is override of a session variable: A request variable lets you override the value of a session variable but only for the duration of a database request initiated from a column prompt. You can create a request variable as part of the process of creating a column prompt.