DTS

Calculates period-to-date values using built-in Dynamic Time Series functionality on block storage databases.

Syntax

DTS (dts-operation-specification, member)
ParameterDescription

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:

(axis)ProfitOpening InventoryRatios
Jan802411740555.1017819772972
Feb834611643455.3868221647073
Mar833311555855.2665073107131
Apr864411914355.4181729805268
QuarterToDate_April864411914355.4181729805268