SUM (MDX) RRS feed

  • Question

  • Hi,

    I have two  dimensions, [demand] and Level...member of demand is [DemandCount].Values are 1,2,3,4,5.

      {   [demand].[DemandCount].&[1],


          [demand].[DemandCount].&[3]   }

    I need to get the  sum of demandcount values for particular level.



     l1 and l2 are level dimensio members.


    For level l1, The DemandCount values  are 1 nd 2

    For level l2, The DemandCount values are 3 nd 4


    I need a business rule (m1)to get the sum of DemandCounts like.





    l1       3  (sum of DemandCount 1 nd 2)


    l2       7  (sum of DemandCount 3 nd 4)




    Any Idea?


    Please Help!!!!!


    Tuesday, July 15, 2008 3:37 AM