The Baker's Dozen: 13 Tips for Querying OLAP Databases with MDX
13 tips for querying OLAP database using MDX:
- Some basic MDX queries to learn MDX syntax.
- Sorting result sets with ORDER.
- Using WITH SET and WITH MEMBER to create sets and calculated members.
- Filtering result sets with WHERE and FILTER.
- Assigning a sequential ranking number to result sets with RANK.
- Retrieving TOP N results using TOPCOUNT, TOPSUM, and TOPPERCENT.
- Combining complex SET definitions with Generate.
- Using the HEAD and TAIL functions when you need to retrieve the top or bottom data from a result set.
- Prioritizing calculations using SOLVE_ORDER.
- Retrieve data by time period using a variety of period functions, such as ParallelPeriod and LastPeriod.
- Retrieving data in a hierarchy using DESCENDANTS.
- Using the LOOKUP function to retrieve data from multiple OLAP cubes.