Which variable below is a valid example of a Dynamic Repository Variable?

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?

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;



Leave a Reply 2

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