Using MDX with DeepSee
Contents
 
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

 
Contents

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