Report Portal

MDX query for Subtree Members and Leaf Members

Suppose we have a GEO dimension. In the dimension we have some of the attributes which are in fact geography at different levels. We also have a hierarchy with these attributes.

The lowest level or the leaf level of this Hierarchy is “Level1 Key” which is in fact brick level geography codes. The top level is Level5 Name, which corresponds to the “National”.

Now we will see some useful mdx queries to retrieve specific type of members from this Hierarchy.

Read more...

 

Tags: design, mdx

 

2007-2015 VidasSoft Systems Inc.