Using InterSystems MDX
- Business Intelligence and MDX
- Basic MDX Queries
- Contents of the DemoMDX Cube
- The Simplest Query
- Members
- Measures
- Referring to Members and Measures
- Simple MDX Queries with %COUNT
- Sets
- Displaying Measures
- Including a Simple Filter in the Query
- Understanding the Contents of the MDX Results
- Business Intelligence Name Resolution
- Conventions Used in the Documentation
- Working with Levels
- Overview of Levels
- Accessing Single Members of a Level
- Accessing Multiple Members of a Level
- Order of Members in a Level
- Selecting a Level Member by Relative Position
- Introduction to Time Levels
- Special Features for Use with Time Levels
- Accessing Properties
- Working with Dimensions and Hierarchies
- Introduction to Dimensions and Hierarchies
- Accessing the Members of a Hierarchy
- Using Parent-Child Relationships
- Accessing Siblings
- Accessing Cousins
- Accessing Descendant Members
- Accessing the Current Member within an Iteration
- Working with Sets
- Introduction to Sets
- Creating Set Expressions
- Creating Named Sets
- Order of Members in a Set
- Selecting Subsets
- Sorting Sets
- Combining Sets
- Filtering a Set by a Measure or Property Value
- Removing Null Elements from a Set
- Removing Duplicates
- Counting the Elements of a Set
- Tuples and Cubes
- Introduction to Tuples
- Tuple Values
- Example Tuple Expressions
- Using Sets of Tuples as Axes of a Query
- Introduction to Cubes
- Higher Levels and a Cube Dimension
- Multiple Hierarchies in a Cube Dimension
- Filtering a Query
- Adding Summaries
- Creating Calculated Measures and Members