CODEWITHSUNDEEP
ssasmdx
Venkatesh Karamala
Venkatesh Karamala

Reputation: 93

Displaying column names at the top in MDX like in SQL

Is it possible to display the column name on top in MDX query.

Below is the Result of my MDX query. I want to display the Year column name at the top (Marked in Red)

blank     amount(Measure)
ALL       1000  
2010      500    
2011      500

In above blank section, I want to display the attribute name of the dimension i.e. YEAR.

Thanks in advance

Upvotes: 2

Views: 858

Answers (1)

FrankPl
FrankPl

Reputation: 13315

This information is available in the result that is coming back as answer to the MDX query, no matter if you get it back in multidimensional or in tabular form.

But what is displayed is totally dependent on the tool displaying the data.

Upvotes: 2

Related Questions