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 | 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 | 10:52
The DeepSee MDX Shell allows execution of MDX statements in a terminal session. The WITH clause, as well as the CREATE and DROP MEMBER and CREATE and DROP SET statements are also demonstrated.
September 30th, 2015 | 10:26
DeepSee MDX supports several statements to generate a pivot or listing. SELECT is the most used statement. DRILLFACTS and DRILLTHROUGH return detail row information from the fact table and source table respectively.
September 30th, 2015 | 11:18
Filtering of your pivot is accomplished by the Slicer Expression with either a Where or %Filter clause. A single measure is part of the Slicer Expression.
September 30th, 2015 | 7:59
The column expression defines what dimensions and measures appear on the columns of your pivot table as well as how they appear. Sets and CROSSJOINs are used.
September 30th, 2015 | 5:54
The row expression defines what dimensions and measures appear on the rows of your pivot table as well as how they appear. Sets and CROSSJOINs are used.
September 30th, 2015 | 10:02
Using the MDX Query window of Analyzer, the syntax of MDX can be viewed. This is a great way to become comfortable with writing your own MDX queries.
September 30th, 2015 | 13:50
MDX provides several functions for use with dimensions and measures. There are also several DeepSee specific functions. Sets and tuples can be included in your MDX query. Filters limit the scope of the dimensions and aggregates in the cube.
September 30th, 2015 | 9:10
MDX queries can have up to 7 axes. An aggregate value in a cell is the aggregate of the intersection of the axes. Specifing dimensions and measures in an MDX query defines the axes and aggregates.