We are having some trouble with the MEMBER UNIQUE NAME property. We are using ID's as our Key Columns, and Descriptions as our Name Columns.
So when we query the cube we use something to the effect of : [Products].&[00001].&[87235].&[62511].&[0918981].
But when we ask for the MEMBER UNIQUE NAME for that row we get something completely deifferent:[Products].[00001].[CLASS DESCRIPTION].[SUBCLASS DESCRIPTION].[0918981]
Is MEMBER UNIQUE NAME the same as the 2000 version? It used to return the key for the MEMBER, but now seems to return the NAME path. Is there any properties to change this functionality. We are using the very latest SP (March).
Thanks.
Add this to your connection string: MDX Unique Name Style=3. I think this should return the key path.
Steve
No comments:
Post a Comment