Need help to create mdx query for my report

• markuss21

  Old Hand

  Points: 320

  More actions

  April 11, 2006 at 7:07 am

  #168452

  HI!

  In my cube are 2 dimensions and one measure.

  And now, I want to present this in a report. But I can't state more than 1 dimension, like this:

  SELECT

     { [Measures].[CountValues]} ON COLUMNS,

     { [Art].[KZ].Members} ON ROWS

  FROM Cube1

  How can I make this ?

  Thanks for your help !

  Regards,

  Markus

   

• Amann Ottmar

  Old Hand

  Points: 339

  More actions

  April 12, 2006 at 12:36 am

  #632009

  Hello Markuss21,

  just try it with CROSSJOIN's like

  SELECT

  { [Measures].[CountValues]}

  ON COLUMNS,

  { [Art].[KZ].Members} * { [dimension2].[xy].Members}

  ON ROWS

  FROM Cube1