1. MDX Step by Step Reading Notes (3)-Understanding Tuples (Understanding Tuples)
- Understand the concept of Member members and Tuple tuples
- Understanding attribute hierarchies and axes
- Understanding Cell Cells
- Understand how Partial tuples Partial Tuple and SSAS process Partial tuples (this part of content is very important)
- Understand the differences between User-Defined Property hierarchies and property hierarchies, and between property hierarchies and metric values.
2. MDX Step by Step Reading Notes (4)-Working with Sets (use set)
- Definition and features of SET
- SELECT statement Decomposition
- Use of Distinct functions
- Use of the Members Function
- Use of the MeasureGroupMeasures Function
- Use of CrossJoin Functions
- How to view dimensions, hierarchies, levels, and members
3. MDX Step by Step Reading Notes-my topic (I) How to understand how the WHERE condition in the MDX query corresponds to the Slicer Axis in the Cube
- How to correctly understand the role of the WHERE condition and the concept of Slicer Slicing
- Changes in the query range WHERE and WHERE conditions are not added
4. MDX Step by Step Reading Notes (4)-Working with Sets (use Set)-Limiting Set and Auto-Exists
- Concepts and functions of Auto-Exists
- Use of CrossJoin and * in the Auto-Exists Concept
- WHERE condition and Auto-Exists
5. MDX Step by Step Reading Notes (4)-Working with Sets (use set)-My Understanding of the Exists Function
- Exists Function Definition and usage
- Differences from Auto-Exists after Crossjoin
- How to deal with the two sets of parameters in Exists when they have direct and indirect associations
- If we break down the Exists code in MDX, we can understand it easily.
- EXISTS function with MeasuresGroup Parameter
- Use of non empty keywords
- Difference between non empty and Exists in processing NULL values
6. MDX Step by Step Reading Notes (5)-Working with Expressions (MDX expression)
- Expression Operator
- VBA function list
- Caculated Members computing Member
- Differences between the AllMembers function and the Members Function
- Dynamic Expression parsing: How does SSAS fill in the partial tuples in the calculated members?
7. MDX Step by Step Reading Notes (5)-Working with Expressions (MDX expression)-Infinite Recursion and SOLVE_ORDER Principle Analysis
- How to Avoid Infinite loop Avoiding Infinite Recursion
- Analysis on the principle of sequential Controlling Solve Order solved by computing member control
- Formatting Calculated Members Formatting the list of Calculated Member attribute values
8. MDX Step by Step Reading Notes (5)-Working with Expressions (MDX expression)-CurrentMember-Properties-Existing usage
- CurrentMember, DefaultMember, UnknownMember, DataMember
- Use of Member. Properties
- Use of IIF Conditions
- Using the SET in the expression and using Existing to force the SET to be associated with the current context again mentions the very important Auto-Exists mechanism in MDX.
9. MDX Step by Step Reading Notes (6)-Building Complex Sets (processing of Complex Sets)-sorting of Sets
- Sorting ing Ordered Sets
- Break-hierarchy sort
- Use of Hierarchize Functions
- Range Operator Range Operators
10. MDX Step by Step Reading Notes (6)-Building Complex Sets (processing of Complex Sets)-Use of the TopCount-BottomCount-Head-Tail-Item Function
- TopCount-BottomCount
- Head-Tail
- Item-Existing
11. MDX Step by Step Reading Notes (6)-Building Complex Sets (processing of Complex Sets)-Filtering Sets
- Filter Function usage
- Differences between NON-EMPTY keywords and NONEMPTY Functions
12. MDX Step by Step Reading Notes (6)-Building Complex Sets (processing of Complex Sets)-Combining Sets
- Use of Combining Sets, Union, Intersection, and Exception Functions
13. MDX Step by Step Reading Notes (6)-Building Complex Sets (processing of Complex Sets)-Use of Generate and Extract Functions
- How to Understand Generate and Extract Functions
