SQL Server Performance

Unable to display data from a dimension.

Discussion in 'Analysis Services/Data Warehousing' started by Gundapaneni, Sep 15, 2004.

  1. Gundapaneni New Member

    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
  2. Raulie New Member

    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.

Share This Page