dbTalk Databases Forums  

Help with Custom Rollup Formula (stumped newbie)

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Help with Custom Rollup Formula (stumped newbie) in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default Help with Custom Rollup Formula (stumped newbie) - 06-20-2006 , 03:12 AM






Hi!

Okay, I have no idea how to make this happen - or if it's even
possible,
so I really need help on this one.

Mission: Change how the totals for the top level in a parent-child sum
up.

I have a physical four level parent-child structure that looks like
this:

Level A
Level B
Group
Account

And from a member point of view, it looks something like this:
(sorry about the generic layout; NDA)

Member A1
Member A1B1
Group A1B1G1
Account A1B1G1A1
Account A1B1G1A2
Account A1B1G1A3
Group A1B1G2
Account A1B1G2A1
Member A1B2
Group A1B2G1
Account A1B2G1A1
Account A1B2G1A2
Member A2
Member A2B1
Group A2B1G1
Account A2B1G1A1
Account A2B1G1A2
Member A2B2
Group A2B2G1
Account A2B2G2A1
Member A3
Member A3B1
Group A3B1G1
Account A3B1G1A1
Member A3B2
Group A3B2G1
Account A3B2G2A1
Account A3B2G2A2

.... and so forth.

At the top level (Level A) member A1, A2, and A3 now shows the
aggreagate
of whatever is below each member.

But what I'm trying to accomplish is more of a running total of Level A
where;

Member A1 = Member A1
Member A2 = Member A1 + Member A2
Member A3 = Member A1 + Member A2 + Member A3

Quote:
From what I've read in BOL, a custom rollup formula should be able to
solve this
when you want to change how a physical level is aggregated.

But how? lol
And the levels below Level A must remain intact.

Any help appreciated!
Thanks!
Tim



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.