Querying dimension members in MDX
User Rating: / 0
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.



Tags: mdx

Pyramid Analytics