Share via

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,296 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,821 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.