Accessing duplicate members in dimensions
In the last post we had an issue with multiple members sharing the same name but with different key attributes. Every approach of addressing such members with MDX like
[Dimension].[Hierarchy].[Name] or [Dimension].[Hierarchy].&[Key]
fails because this fetches only one particular member while the measure data may be associated with one of the other members sharing the same key.
Ok, usually you shouldn't be in this situation. If for example you're using the business key (instead of the surrogate key) as the attribute key, you only get one member and all the fact data is associated to that member. Therefor the above member expressions work fine.
Read more...Tags: mdx, parent-child