Date Time Series members (DTS) are predefined database members used in dynamic, to-date reporting, such as year-to-date or month-to-date values. DTS results are displayed as individual members, summing Level 0 Time dimension members in Essbase based on the current selection.
Use the Date Time Series dialog box to select the latest time period in to-date calculation. The calculated value of the Date Time Series is derived when you define the latest time period to be reported. For example, suppose you need sales data for the quarter up to the current month when the level 0 members of the Year dimension are the months of the year, and the current month is August. In this case, you select a quarter-to-date calculation, which shows sales data for the months of July and August.
Note: | Because MDX is used to query Essbase, and MDX does not have an exact equivalent of the Date Time Series (DTS) functions, a combination of xTD (refers to Year-, Quarter-, Month— and Week-to-date periods) and Sum functions are used. As a result, there may be different data output than a traditional DTS for some members; for example, those that use “Time Balance” functionality and “Two Pass Calc” members. |
To make a Date Time Series selection:
In the data layout, double-click a Time dimension in the data layout.
The Member Selection dialog box opens.
In the Selected pane, right-click a Time dimension member, and select Date Time Series.
The Date Time Series dialog box opens.
Select the definition to use for the to-date calculation and click OK.