Unable to display data from a dimension. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Unable to display data from a dimension.

Hi all, I am novice in Analysis services. I have a problem in displaying data from a dimension.
I have a dimension called Vehicle as follows
Vehicle
.Make
..Model
…Series Now I want to display data from Vehicle and Measures dimensions using a mdx query as follows. Make Model Series DaysInStock
Chrysler Sebring 222
Chrysler Sebring 35
Chrysler PTCruiser 890
….
….
….
Here DaysInStock is from Measures dimension.
How can I display the format shown above. Can some help me?? Thanks in advance.
Madhu. Madhu
As far as MDX is concerned the query you are trying to disply is invalid , you cannot display a Column Axis with out a row axis and vice versa.
]]>