A customer would like to create a change and a % Change for Revenue at the same time. How would they accomplish this?

The correct answer is B. Using the Calculation Wizard. After creating your base metrics, try using the Calculation Wizard to automate the process of creating time-series metrics or comparison metrics such as: Change, Percent Change, Index, and Percent. The Wizard may save you many hours of time and frustration, especially if you…

Building Reports and Charts

Question

Options

AUsing the Expression Builder
BUsing the Calculation Wizard
CDefining them in the physical data model
DDefining them in the Presentation Layer

How the community answered

(24 responses)

A
4% (1)
B
79% (19)
C
13% (3)
D
4% (1)

Explanation

After creating your base metrics, try using the Calculation Wizard to automate the process of creating time-series metrics or comparison metrics such as: Change, Percent Change, Index, and Percent. The Wizard may save you many hours of time and frustration, especially if you have to create more than a handful of these metrics. In addition, the Wizard allows you to include customized logic to handle nulls in the base metrics. You may refer to the Oracle documentation for further detail.

Topics

#calculation wizard#percent change#revenue metrics#derived measures

Community Discussion

No community discussion yet for this question.

Full 1Z0-591 Practice