Post reply

Different Types of Rollups for the same Measure

  • May 3, 2007 at 3:22 am

    #153564

    Hi All,

    I wonder if someone can help me:

    Is it possible to rollup the same measure differently in different Hierarchies.

    e.g. measure1 rollup by using Distinct Count for 3 Hierarchies and in the same cube it must rollup by using SUM for 2 different Hierarchys.

    Is this possible in SSAS or as an alternative is this possible by writing MDX?

    Thanx

    Pieter Nelson

     

     

  • May 4, 2007 at 9:55 am

    #704398

    Are you using AS2005? If so, you can create a measure group for each distinct count you want and a measure group for sum.

    The measures must be different for the distinct count and for the sum.

  • May 7, 2007 at 7:55 am

    #704641

    I am using AS2005.

    Unfortuanately this is not going to help, I need the same measure in the same measure group to do both(Sum and Distinct Count)

    Is there not another way of doing this?

     

  • May 7, 2007 at 11:36 pm

    #704828

    You could try using one (or more) Scope() statements in an MDX script and then try to set the aggregation of the measure in that way.  I would recommend getting a book to help with the MDX - Spofford's (et al) MDX Solutions 2nd Edition is meant to be good.  You could always ping Chris Webb (co-author on that book) for some hints on how (or if) this is possible to do.

     

    Steve.

Viewing 4 posts - 1 through 4 (of 4 total)

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