none
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].&[2]

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

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

    Suppose

     

     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.

     

     

    m1(measure)

     

    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