Calculates period-to-date values using built-in Dynamic Time Series functionality on block storage databases.
Syntax
DTS (dts-operation-specification, member)
Parameter | Description | ||
---|---|---|---|
dts-operation-specification | The Dynamic Time Series member for which to return values. Specify one of the following operations:
| ||
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) | 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 |