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.
B
one usage of session variable is
OBIEE apply row-level security VIA session variable + user/group data filter, analogous to oracle 11g FAGC(Fine Grained Access) application context + policy function to retrieve filtering predicate.
http://bisimplified.blogspot.ca/2014/06/obiee-11g-datarow-level-security.html
one usage of repository variable is
set one repository variable, the obiee analysis can apply one column filter with that repository variable
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1221/rpd/rpd.html
“using initialization block and variables”
one usage of presentation variable is
set one presentation variable value with “Dashboard Prompt -> variable prompt
” to filter one analysis which would be displayed on one dashboard
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1221/cad/cad12c.html
“adding prompts to filter an analysis” -> “creating a named dashboard variable prompt”
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.