Time series functions are aggregate functions that operate on time dimensions.
The time dimension members must be at or below the level of the function. Because of this, one or more columns that uniquely identify members at or below the given level must be projected in the query.
Function | Example | Description |
---|---|---|
Ago |
|
Calculates the aggregated value of a measure from the current time to a specified time period in the past. For example, |
Periodrolling |
|
Computes the aggregate of a measure over the period starting |
ToDate |
|
Aggregates a measure from the beginning of a specified time period to the currently displayed time. For example, this function can calculate Year to Date sales. |
Forecast |
|
Creates a time-series model of the specified measure over the series using either Exponential Smoothing or ARMIA and outputs a forecast for a set of periods as specified by numPeriods. |