DTS

The MDX DTS function calculates period-to-date values using built-in Dynamic Time Series functionality on Essbase block storage databases.

Syntax

DTS (dts-operation-specification, member)

Parameters

dts-operation-specification

The Dynamic Time Series member for which to return values. Specify one of the following operations:

• HTD—History-to-date

• YTD—Year-to-date

• STD—Season-to-date

• PTD—Period-to-date

• QTD—Quarter-to-date

• MTD—Month-to-date

• WTD—Week-to-date

• DTD—Day-to-date

Note:

The operation you use for this parameter must have a corresponding Dynamic Time Series member enabled in the outline.

member

Member specification. Must be a level-0 member from the time dimension.

Notes

This function is applicable only to block storage databases.

Example

The following query returns year to date information for Sample Basic.

WITH MEMBER [Year].[QuarterToDate_April] AS 'DTS(QTD,Apr)'
SELECT
 {[Profit], [Opening Inventory],[Ratios]}
ON COLUMNS,
 {[Jan],[Feb],[Mar],[Apr],[QuarterToDate_April]}
ON ROWS
FROM Sample.Basic;

This query returns the grid:

Table 4-60 Output Grid from MDX Example

(axis)	Profit	Opening Inventory	Ratios
Jan	8024	117405	55.1017819772972
Feb	8346	116434	55.3868221647073
Mar	8333	115558	55.2665073107131
Apr	8644	119143	55.4181729805268
QuarterToDate_April	8644	119143	55.4181729805268