How do Dynamic Repository Variables differ from Static Repository Variables?

Question

Options

• ADynamic Repository Variables are not initialized by the Initialization Block.
• BDynamic Repository Variables cannot be used in the Expression Builder.
• CDynamic Repository Variables can be changed by data that is returned from queries.
• DDynamic Repository Variables cannot be used in a CASE statement.

• A
  3% (1)
• B
  8% (3)
• C
  76% (28)
• D
  14% (5)

Explanation

Dynamic Repository Variables: You initialize dynamic repository variables in the same way as static variables, but the values are refreshed by data returned from queries. When defining a dynamic repository variable, you will create an initialization block or use a pre-existing one that contains a SQL query. You will also set up a schedule that the Oracle BI Server will follow to execute the query and periodically refresh the value of the variable. Note: The value of a static repository value is initialized in the Variable dialog box. This value persists, and does not change until an Oracle BI Administrator decides to change it.

No community discussion yet for this question.