General functions#

at

Return a measure equal to the passed measure at some other coordinates of the cube.

date_diff

Return a measure equal to the difference between two dates.

date_shift

Return a measure equal to the passed measure shifted to another date.

filter

Return a filtered measure.

first

Return a measure equal to the first value of the passed measure on the given level.

last

Return a measure equal to the last value of the passed measure on the given level.

lookup

Return a measure equal to a get-by-key query on the given table column.

parent_value

Return a measure which values are equal to the values of the given measure, at a member that is located at a higher level on each of the specified hierarchy.

rank

Return a measure equal to the rank of a hierarchy's members according to a reference measure.

shift

Return a measure equal to the passed measure shifted to another member of the hierarchy.

switch

Return a measure equal to the value of the first case for which subject is equal to the case's key.

total

Return a measure equal to the passed measure at the top level member on each given hierarchy.

where

Return a conditional measure.