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.