Clarification on the Generation Level when Setting up Dynamic Time Series (DTS: YTD, QTD,..) for Hyperion Planning (Doc ID 1334732.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Planning - Version 9.3.3.0.00 to 11.1.2.1.000 [Release 9.3 to 11.1]
Information in this document applies to any platform.

Symptoms


YTD settings when made to Generation 3 for EPMA application or classic Planning application do not calculate properly:

In the Essbase Admin guide under 'Retrieving Period-to-Date Values' the following example is given:

Jan -> 10
Feb -> 100
Mar -> 100
Q1
Apr -> 8644
May -> 8929
Jun -> 9534
Q2

Q-T-D(May) displays the period-to-date value for May that is obtained by adding the values for Apr and May (8644 + 8929 = 17573).

In the Planning Admin guide section on Dynamic Time Series it states:

You can use Dynamic Time Series (DTS) members to create reports that show period-to-date
data, such as quarter-to-date expenses. DTS members are created automatically during
application creation, and can be used with members of the Period dimension. To set up DTS,
you enable a predefined DTS member and associate it with a generation number (and, optionally,
an alias table and alias name). For example, to calculate quarter-to-date values, you can enable
the Q-T-D member and associate it with generation number 2. You can then use the Q-T-D
DTS member to calculate monthly values up to the current month in the quarter.

However if the QTD is setup in Planning to generation 2 to calculate QTD(MAY), Planning adds all the months from Jan to May which seems to be wrong and in contradiction to what is stated in the Essbase admin guide.

So using QTD(MAY) will give in Planning Jan + Feb +...+May = 17783 instead of Apr + May = 17573

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms