Post reply

Aggregates sums in dimension level

  • May 12, 2003 at 12:22 am

    #105752

    Hello,

    I have a situation like this. In the foodmart 2000 sample database, we have the sales cube and there is a dimension called "TIME".

    In the Quarter level of this time dimension, I need the sums in aggregated level. For example, Q1 has the sum of months 1,2 and 3. Q2 has the Q1 value+4+5+6 and Q3 has Q2+7+8+9 and Q4 has Q3+10+11+12.

    Please ask me if you need any further clarifications. Kindly let me know if you have any clue how to do it. I am sure it is possible with custom rollup formula but I don't have enough exposture to that area yet.

    Thanks in advance,

    Anbu

  • May 12, 2003 at 3:34 am

    #456795

    The simpler solution would be to add a column to the fact table as " YTD Sales"

  • May 12, 2003 at 3:34 am

    #456794

    The simpler solution would be to add a column to the fact table as " YTD Sales"

  • May 12, 2003 at 4:02 am

    #456800

    Create a calculated Member with

    the formula

    Sum( YTD(), [Measure].[unit sales])

  • May 12, 2003 at 4:03 am

    #456801

    Create a calculated Member with

    the formula

    Sum( YTD(), [Measure].[unit sales])

  • May 12, 2003 at 4:22 am

    #456802

    Thanks for your reply. But how can I use the same when I have the same situation like this for a customer dimension?

  • May 14, 2003 at 8:29 am

    #457104

    Anbu, I am not to sure what you want to do with the dimension. Please explain

Viewing 7 posts - 1 through 6 (of 6 total)

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