About OLAP functions

OLAP functions take multiple elements from a list and return a new list of elements. Example are rank, running sum, moving average, and so on.

The following items apply to all OLAP functions:

• SortByis applied before the engine performs the calculation of an OLAP function.

• In OLAP functions, the SortByparameter can be either a metric or an attribute.

For details on a specific OLAP function, view one of the following topics:

• Exponential weight moving average

• Exponential weight running average

• First in range

• Lag

• Last in range

• Lead

• Moving average

• Moving count

• Moving difference

• Moving maximum

• Moving minimum

• Moving standard deviation (of a population)

• Moving standard deviation (of a sample)

• Moving sum

• OLAPAvg

• OLAPCount

• OLAPMax

• OLAPMin

• OLAPRank

• OLAPSum

• Running average

• Running count

• Running maximum

• Running minimum

• Running standard deviation (of a population)

• Running standard of deviation (of a sample)

• Running sum

For additional information on OLAP functions, refer to the MicroStrategy Functions Reference.