icad01
asked on
How to get in MDX the lowest level source of a dimension?
Dear experts,
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for your fast answer.
I realize that I have a lot to learn before using MDX.
I didn't know where to put the code to get any result (in ADO?)!
Thanks anyway.