Report Portal

Querying dimension members in MDX

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

 

2007-2015 VidasSoft Systems Inc.