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.
September 30th, 2015 | 4:11
MDX is the query language for cubes. DeepSee analyzer generates MDX queries that can be viewed and modified if needed. A DeepSee result set can be returned to your application via the %DeepSee API.
September 30th, 2015 | 7:01
DeepSee Analyzer creates pivots to analyze your cubes and subject areas. Analyzer generates MDX queries and can drill down into levels of a hierarchy. Filters and formating can be applied. Pivots can appear as either tables or charts.
September 30th, 2015 | 13:29
Measures and dimensions can be calculated using other members of the cube with MDX. Several measures and dimensions are added to a cube via Architect and their use demonstrated in Analyzer.
