My user is connecting ssas cube from Microsoft Excel. When user is selecting Dimension attributes, member properties, the report displays ,the names of attributes by its full name path instead of just name. And this behaviour is appearing by default for them. I am unable to replicate the issue from my side. So I suspect, this is the Excel behaviour and not cube. Anybody can help me, where can I adjust the settings, to display, full name path or Just names!?
For example: if my structure of heirarchy is:
[Dimension].[Heirarchy].[Level Name].[MemberUnique Name]..
Then the report displays this full path, instead Only
Appreciate your help in advance..