Hi folks,

I was wondering if MDX is capable to retrieve metadata about dimensions which are defined in a cube.

Let's say I have dimensions defined as shown below than the MDX query should give me the following results - is that possible?


DIM Hierarchy Levelnr Levelname
Time Time 1 Year
Time Time 2 Quarter
Time Time 3 Month
Region Region 1 Country
Region Region 2 State



Excerpt of cube definition
Code:
 <Dimension name="Time" visible="true" foreignKey="DATE_TECHKEY" highCardinality="false" >
      <Hierarchy visible="true" hasAll="false" primaryKey="DATE_TECHKEY">
        <Table name="DIM_DATE"></Table>
        <Level name="Year" visible="true" column="YEAR" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never"> </Level>
        <Level name="Quarter" visible="true" column="QUARTER" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level>
        <Level name="Month" visible="true" column="MONTH" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level>
    </Hierarchy>
 </Dimension>
 <Dimension name="Region" visible="true" foreignKey="REGION_TECHKEY" highCardinality="false" >
      <Hierarchy visible="true" hasAll="false" primaryKey="REGION__TECHKEY">
        <Table name="DIM_REGION"></Table>
        <Level name="Country" visible="true" column="Country"  type="Integer" uniqueMembers="true" levelType="Regular"  hideMemberIf="Never"> </Level>
        <Level name="State" visible="true" column="State"  type="String" uniqueMembers="false" levelType="Regular"  hideMemberIf="Never"> </Level>
   </Hierarchy>
 </Dimension>
Regards,
Andreas