I would like to add one of my dimension in more than one hierarchy.
Now I have my "Product Name" dimension in present in the "Order Hierarchy" under the "Order ID".
I also want to create One more different Hierarchy, and want my "Product Name" to be a member of that.
It looks like I cannot add my dimension in more than one hierarchy.
The Only way around I can think of is to duplicate my "Product Name" dimension and save it with different name, and then use the newly created dimension in the new hierarchy.
Is there a better way to handle this kind of situation.
That would be the option. Another way to 'duplicate' a dimension would be based on an 'union'.
Product Name 'Orders':if [Table Name]='Orders$' then [Product Name] end
Product Name 'Orders$':if [Table Name]='Orders$' then [Product Name] end
Hope it helps.