CODEWITHSUNDEEP
c#ssasmdxolapmdxclient
gruber
gruber

Reputation: 29759

get userFriendly names of dimmension attributes in mdx

I'm using the MDXClient library in my C# application. I browse cube and generate some reports based on mdx queries.

When I use Management Studio I have nice (user friendly) column names in the query result, but when I use this library the column names are very long and differ from what I have in Management Studio.

Sample query:

SELECT [My Question].[My Question].[My Question].AllMembers ON COLUMNS from [demo]

Sample result in management studio is one column:

[nice]

Sample result in my C# app is one column:

[My Question].[My Question].&curr_nice

How can i retrieve the same answer as what I see in SSMS?

Upvotes: 0

Views: 370

Answers (1)

Magnus Smith
Magnus Smith

Reputation: 5963

You are being presented with the full member name including which dimensions and levels it resides within.

I suspect your C# code has access to several member properties. Are you just asking for the default property? I cannot see the library documentation but I expect there is a .Name string property and a .FormattedName or some such alternative; maybe .MemberName ?

Or perhaps the name information is presented as an object, and you need to break it down into the constituent parts.

Upvotes: 0

Related Questions