DeepSee MDX—Joining Functions

DeepSee MDX joining functions join two sets of dimensions and will optionally include duplicates. These include CROSSJOIN, EXCEPT, INTERSECT and UNION.

DeepSee MDX—Time Functions

DeepSee MDX time functions work on time and date dimensions. These include CLOSING/OPENINGPERIOD and PERDIOSTODATE. The special time member NOW is included.

DeepSee MDX—Measure Functions

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.