Post reply

MDX: Specify which measure to display

  • August 3, 2005 at 12:44 am

    #114834

    Hi all,

          Suppose I have a cube with several numeric measures. When I write an MDX expression to select from the cube, if there are already other dimensions on rows and columns, how can I specify which measure to display? I think by default the first level measure is displayed. How to change that behaviour?

           For example,

       select {[customers].members}on rows,

       {[date_of_purchase].members}on columns from [Sales]

        Suppose there are measures ORIGINAL_PRICE, DISCOUNTED_PRICE, DISCOUNT_PERCENTAGE, etc ... how can I specify which measure to display from the above query?

    Thanks a lot,

    delpiero

     

  • August 3, 2005 at 7:18 am

    #579139

    Hey Delpiero,

    What you need to do is 'nest' the measures either onto your rows or columns(prob the most usual place, but either will work).

    To do this, try out the crossjoin function (and later, the nonemptycrossjoin).  Using your sample emasures above, this should return all of the measures on the columns with your date of purchase members.

    SELECT

      {[Customers].MEMBERS} on 1,

      CROSSJOIN({[date_of_purchase].MEMBERS}, {[Measures].MEMBERS}) on 0

    FROM

      [Sales]

    Steve.

  • August 3, 2005 at 9:14 am

    #579201

    Thanks Steve,that's what you have taught me some time ago. Sorry to have forgotten ...

    Del Piero

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply