Using MDX with DeepSee
[Home]  [Next]
InterSystems: The power behind what matters   
Class Reference   

Preface : 
Chapter 1: 
  1.1 Purpose of DeepSee
1.2 Introduction to Pivot Tables
1.3 Introduction to MDX
1.3.1 MDX in DeepSee Models
Chapter 2: 
  2.1 Contents of the DemoMDX Cube
2.2 The Simplest Query
2.3 Members
2.4 Measures
2.5 Referring to Members and Measures
2.6 Simple MDX Queries with %COUNT
2.6.1 Axis Skipping
2.7 Sets
2.7.1 Examples
2.8 Displaying Measures
2.9 Including a Simple Filter in the Query
2.10 Understanding the Contents of the MDX Results
2.10.1 Notes on Independence of Query Axes
2.11 DeepSee Name Resolution
2.11.1 Nonexistent Members
2.11.2 Typographical Errors
2.12 Conventions Used in Remainder of the Book
Chapter 3: 
  3.1 Overview of Levels
3.1.1 Possible Member Overlap
3.1.2 Null Values and Null Members
3.1.3 Hierarchies
3.2 Accessing Single Members of a Level
3.2.1 Member Names
3.2.2 Member Keys
3.3 Accessing Multiple Members of a Level
3.4 Order of Members in a Level
3.5 Selecting a Level Member by Relative Position
3.6 Introduction to Time Levels
3.7 Special Features for Use with Time Levels
3.7.1 Selecting a Member Relative to Today (Time Levels)
3.7.2 Selecting Ranges of Members of a Time Level
3.8 Accessing Properties
3.8.1 Properties As String Expressions
3.8.2 Properties and Attributes
Chapter 4: 
  4.1 Introduction to Dimensions and Hierarchies
4.1.1 The Measures Dimension
4.1.2 The All Level
4.1.3 Example
4.2 Accessing the Members of a Hierarchy
4.3 Using Parent-Child Relationships
4.4 Accessing Siblings
4.5 Accessing Cousins
4.6 Accessing Descendant Members
4.7 Accessing the Current Member within an Iteration
Chapter 5: 
  5.1 Introduction to Sets
5.2 Creating Set Expressions
5.3 Creating Named Sets
5.4 Order of Members in a Set
5.5 Selecting Subsets
5.6 Sorting Sets
5.6.1 Sorting a Set by a Measure Value
5.6.2 Selecting a Top or Bottom Subset
5.6.3 Applying Hierarchical Order
5.7 Combining Sets
5.8 Filtering a Set by a Measure or Property Value
5.9 Removing Null Elements from a Set
5.10 Removing Duplicates
5.11 Counting the Elements of a Set
Chapter 6: 
  6.1 Introduction to Tuples
6.1.1 Creating Tuples
6.1.2 Fully and Partially Qualified Tuples
6.1.3 Sets of Tuples
6.2 Tuple Values
6.3 Example Tuple Expressions
6.4 Using Sets of Tuples as Axes of a Query
6.5 Introduction to Cubes
6.6 Higher Levels and a Cube Dimension
6.7 Multiple Hierarchies in a Cube Dimension
Chapter 7: 
  7.1 Introduction to the WHERE Clause
7.1.1 Using a Set in the WHERE Clause
7.1.2 Using Tuples in the WHERE Clause
7.2 The %NOT Optimization
7.3 The %OR Optimization
Chapter 8: 
  8.1 Introduction to Summary Functions
8.2 Adding a Summary Line
Chapter 9: 
  9.1 Overview of Calculated Measures and Members
9.2 Creating a Calculated Member
9.3 MDX Recipes for Calculated Measures
9.3.1 Combinations of Other Measures
9.3.2 Percentages of Aggregate Values
9.3.3 Distinct Member Count
9.3.4 Semi-Additive Measures
9.3.5 Filtered Measures (Tuple Measures)
9.3.6 Measures for Another Time Period
9.3.7 Measures That Refer to Other Cells
9.4 MDX Recipes for Non-Measure Calculated Members
9.4.1 Defining Age Members
9.4.2 Defining a Hardcoded Combination of Members
9.4.3 Defining a Combination of Members Defined by a Term List
9.4.4 Aggregating Ranges of Dates
9.4.5 Defining a Member as an Intersection of Other Members