Page 1 of 1

Master & Detail Budgeting using Rollup Groups

Posted: Mon Mar 10, 2008 9:23 am
by goutamapps
Hi All

I am upto preparing a a budget based on following segment value set hierarchy:

Corporate

SBU1 SBU2

LOB1 LOB1
LOB2 LOB2
LOB3 LOB3

I have defined Budget Org (Range assignments on LOB Level only. I am confused on how to make a Rollup Group which will Rollup the LOB Level Range Assignments into each SBU Level. Think this is an Inter Segment Parent Child Relationship.

Could anybody show me the right direction to go forward.

Thanks
Goutam

Posted: Wed Mar 12, 2008 3:42 am
by goutamapps
Can anybody please put forward any solution to this?

Posted: Wed Mar 12, 2008 11:34 am
by ksribhas
It looks like a summary level budgeting requirement. Please have a look at Note 265011.1 in Metalink. This has been authored by me when I was in Oracle.

Posted: Thu Mar 13, 2008 9:37 am
by goutamapps
I visited the link earlier, but the difference in our set up we are trying to make Inter- segment Parent child relation ship (between SBU & LOB). This Doc Id dosen't fulfills that.

Posted: Thu Mar 13, 2008 1:20 pm
by ksribhas
Please give more information on your chart of Accounts.

Posted: Fri Mar 14, 2008 9:03 am
by goutamapps
Corporate Segment - SBU
Child Value Set - 100,200,300,400
Parent Value Set - 500


Detail Level Segment - LOB
Child Value Set - 110,120,130...
Parent Value Set - 100

We decided to keep 500 value under SBU as Rollup Group for Corporate Budget. Then another Rollup Group to be on 100 value under LOB for Detail Level Budget.

I said inter - Segment Parent Child Relationship because under each SBU there should be all LOBs( 110,120,130...).

Does it help

Thanks
Goutam

Posted: Mon Mar 17, 2008 6:37 pm
by ksribhas
still some clarity is required. Please specify the info like this :

a) Chart of Accounts structure - Company.Cost Center etc
b) vaues in the above segments.
c) example of what you would like to achieve