Querying dimension members in MDX
User Rating: / 0
PoorBest 
Written by Alex Whittles   
Friday, 30 November 2012 17:36

Today we're back looking at MDX with a quick how-to. How do you extract a list of dimension members using MDX? This could be used for example to populate a user interface/parameter of a report/dashboard. Let's look at two scenarios; normal dimensions, and then hierarchies. All the queries here use the "Adventure Works DW 2008 R2? "Adventure Works" cube.

Read more...

 

Tags: mdx
 

XL Cubed