How to get in MDX the lowest level source of a dimension?
Posted on 2006-07-09
I need to get the lowest level in a dimension, for example level "Store Name" in dimension STORE:
Level Source Column Source Table Member Count
Store Country store_country store 3
Store State store_state store 10
Store City store_city store 24
Store Name store_id store 24
(this is Sales cube in FoodMart Olap database example)
I need to know his Source Column and Source Table. (store_id and store respectivly).
More generally, how do you get metadata from MDX?
Thanks in advance