locked
Changing the aggregation function while browsing SSAS cube RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello there,

    I need to change the aggregate function while browsing cube. For example if I am browsing the cube in excel I should be able to change the SUM to COUNT etc. This is because I would not love to create each and every aggregation in cube level. Please let me know how can I achieve this.

    Thanks,

    Palash

    Monday, March 7, 2011 9:57 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Palash,

    It seems you are working with a simple cube - you usually wouldn't want to support this as measures could have all kind of calculations and aggregations applied in different context using the cube mdx script.

    But what you are looking for is supported in PowerPivot for Excel - every column in the data model can be aggregated and user gets to pick the appropriate aggregation function.

    HTH,

    Hrvoje Piasevoli

    • Marked as answer by Challen Fu Tuesday, March 15, 2011 10:51 AM
    Tuesday, March 8, 2011 1:19 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    this is acutally not possible as you need to define the aggregate-function for each measure at design-time

    what you could do is to create several measures based on the same column and assign different aggregate-functions to them
    so you would have [Measures].[Value SUM], [Measures].[Value MIN], [Measures].[Value COUNT] etc.

    the enduser then can use the measures they want to see

    hth,
    gerhard

    - www.pmOne.com -
    Monday, March 7, 2011 5:31 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Gerhard,

    Thanks for the reply. Do we have any third party browsers by which we can achieve this?

    Thanks,

    Palash

    Tuesday, March 8, 2011 9:27 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Palash,

    It seems you are working with a simple cube - you usually wouldn't want to support this as measures could have all kind of calculations and aggregations applied in different context using the cube mdx script.

    But what you are looking for is supported in PowerPivot for Excel - every column in the data model can be aggregated and user gets to pick the appropriate aggregation function.

    HTH,

    Hrvoje Piasevoli

    • Marked as answer by Challen Fu Tuesday, March 15, 2011 10:51 AM
    Tuesday, March 8, 2011 1:19 PM