Oracle Analytics Cloud 2020 Implementation Essentials — Question 16

Which two statements are true of the roll forward calculation in the Movement dimension?

Answer options

• A. Values for base-level Movement members are calculated as the difference between Closing Balance and Opening Balance.
• B. Translated values for Closing Balance are adjusted to the ending rate for the period.
• C. Values for Opening Balance are retrieved from the prior period Closing Balance.
• D. Data for opening balances must be loaded to the Opening Balance member prior to consolidation.

Correct answer: B, C

Explanation

Option B is correct because translated values for the Closing Balance are indeed adjusted to the ending rate for the period. Option C is also correct as the Opening Balance is retrieved from the prior period's Closing Balance. Options A and D are incorrect; A misstates the calculation method and D incorrectly suggests that data loading is a prerequisite for consolidation.