In Essbase 11.1.1, what are two possible ways to calculate Period to Date values in ASO?

The correct answer is B. Analytic dimension with member formulas to calculate period to date values C. Alternate hierarchy in Time dimension to rollup period to date values. B: More recent releases of Essbase will do time balancing natively, but period-to-date is something you still have to work out. A preferred method of doing this is to add an analytic dimension to the database and set the formula in one of the calculated members. For those of…

Calculations and Formulas

Question

Options

AEnable Dynamic Time Series
BAnalytic dimension with member formulas to calculate period to date values
CAlternate hierarchy in Time dimension to rollup period to date values
DCreate a Date Time dimension

How the community answered

(21 responses)

A
10% (2)
B
76% (16)
D
14% (3)

Explanation

B: More recent releases of Essbase will do time balancing natively, but period-to-date is something you still have to work out. A preferred method of doing this is to add an analytic dimension to the database and set the formula in one of the calculated members. For those of you who aren't familiar with the term, an analytic dimension is one that you add to your database that has a single default load member, all other members are calculated. B, C: Period to date functionality has to be managed via MDX formulas and/or alternate roll ups in your time dimension.

Topics

#ASO#period to date#dynamic time series#alternate hierarchy

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice