|Querying dimension members in MDX|
|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...