1Z0-591 · Question #65
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?
The correct answer is D. CurrentMonth. CurrentMonth can be calculated by a sql statement. 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…
Question
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?
Exhibit
Options
- AYear
- BMonth
- CQuarter
- DCurrentMonth
How the community answered
(37 responses)- A5% (2)
- B3% (1)
- C11% (4)
- D81% (30)
Explanation
CurrentMonth can be calculated by a sql statement. 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 Source" button 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'))
Topics
Community Discussion
No community discussion yet for this question.