One of the most common uses of Dynamic Repository Variables is to setup filters for use in
reporting. Which variable below is a valid example of a Dynamic Repository Variable?
A.
Year
B.
Month
C.
Quarter
D.
CurrentMonth
Explanation:
CurrentMonth can be calculated by a sql statement.
Note:
REPOSITORY VARIABLE(DYNAMIC)
Initialized when BI server is started
Assigned value dynamically based on the result of a query
Value is dependent of the sql provided in Initialization Block
Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization
block by clicking on the New button in the above screen.Provide Intialization Block variable Name
Click on Edit Data Sourcebutton and provide the sql to be used for the variable, e.g.
select lower(sys_context(‘USERENV’,’SESSION_USER’))||
‘@’||
lower(sys_context(‘USERENV’,’DB_NAME’))
from dual;
D
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”