Report Portal

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.


 

Read more...

Tags: mdx, tip

 

2007-2015 VidasSoft Systems Inc.