Using InterSystems MDX Business Intelligence and MDX Purpose of Business Intelligence Introduction to Pivot Tables Introduction to 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 Introduction to the WHERE Clause The %NOT Optimization The %OR Optimization Adding Summaries Introduction to Summary Functions Adding a Summary Line Creating Calculated Measures and Members Overview of Calculated Measures and Members Creating a Calculated Member MDX Recipes for Calculated Measures MDX Recipes for Non-Measure Calculated Members