| 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... |
Tags: mdx
