Dimensions attributes displays full name path

Prema Prabhu 1 Reputation point
2021-02-16T09:21:17.873+00:00

Hi All,

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
[MemberUniqueName]..

Appreciate your help in advance..
Regards..

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,209 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,811 Reputation points
    2021-02-17T03:24:10.217+00:00

    Hi,

    Please avoid duplicate issues, and we could continue our discussion at your previous thread :
    https://learn.microsoft.com/en-us/answers/questions/274179/display-full-name-for-dimension-attributes-and-pro.html?childToView=276032#answer-276032