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

Preface : 
 
 
Chapter 1: 
 
1.1 Purpose of DeepSee
1.2 Introduction to Pivot Tables
1.3 Introduction to MDX
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.11 DeepSee Name Resolution
2.12 Conventions Used in Remainder of the Book
Chapter 3: 
 
3.1 Overview of Levels
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.8 Accessing Properties
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.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.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.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.4 MDX Recipes for Non-Measure Calculated Members