September 30th, 2015 | 11:32
Most extension functions begin with the letter %. Additional extension functions include %ALL, %LABEL, %SPACE, %CELL and %MDX.
September 30th, 2015 | 5:42
Most extension functions in DeepSee MDX begin with the letter %. Those extension functions that are used in a slicer expression include %NOT, %OR and %SEARCH
September 30th, 2015 | 7:12
DeepSee MDX joining functions join two sets of dimensions and will optionally include duplicates. These include CROSSJOIN, EXCEPT, INTERSECT and UNION.
September 30th, 2015 | 5:21
DeepSee MDX time functions work on time and date dimensions. These include CLOSING/OPENINGPERIOD and PERDIOSTODATE. The special time member NOW is included.
September 30th, 2015 | 11:58
DeepSee MDX limiting functions restrict the number of elements in the pivot. Functions include, IIF, FILTER, DISTINCT, TOPCOUNT and more.
September 30th, 2015 | 4:20
DeepSee MDX navigation functions allow you to move to another member of a level based on the current member.
September 30th, 2015 | 13:00
Measure functions work with measures defined in a DeepSee cube. In addition to the aggregation functions (SUM, AVG, MIN, MAX and COUNT) there are several others to perform additional calculations.
September 30th, 2015 | 9:12
Relative functions in MDX allow you to move from a member of a level to its relatives. Relatives include, parent, child, cousing, ancestor