Skip to Content
0
Former Member
Sep 08, 2016 at 06:59 AM

Values Overwriting in Allocation

20 Views

Hi Vadim,

Please see the below profit center dimension members.

Here i want allocate all source cost centers to only single cost center in different profit center which is highlighted. While allocating the value should add.

Source Target Target Target Target Target Target 610601 610101 610201 610202 610301 610302 610401 6106010104 6101010001 6102010003 6102020003 6103010003 6103020103 6104010004 6106010109 6101010002 6102010004 6102020004 6103010004 6103020104 6104010005 6106010113 6101010003 6102010005 6102020005 6103010005 6103020105 6104010007 6106010119 6101010004 6102010007 6102020007 6103010007 6103020107 6104010008 6106010204 6101010005 6102010008 6102020008 6103010008 6103020108 6104010013 6106010209 6101010006 6102010009 6102020010 6103010010 6103020110 6104010016 6106010213 6101010007 6102010010 6102020011 6103010011 6103020111 6104010018 6106010219 6101010008 6102010011 6102020013 6103010013 6103020113 6104010020 6106010304 6101010033 6102010033 6102020033 6103010033 6103020233 6104010033 610501 6105010002 6105010003 6105010004 6105010005 6101010033 Target Cost center 6105010006 6105010007 6105010008 6105010009 6105010011 610102 6101020001 6101020002 6101020003 6101020004 6101020005 6101020006 6101020007 6101020008 6101020009

I want like this

610601 610501 6E+05 Cost Center ACCOUNT ABP ALLOC1 ALLOC2 ALLOC3 610601 6106010104 x 500 6106010109 x 1000 6106010113 x 1500 Allocshare 6106010133 610501 6105010002 x 100 6105010003 x 200 6105010004 x 300 Allocshare 6105010033 610102 6101020001 x 600 6101020002 x 700 6101020003 x 800 Allocshare 6101020033 610101 6101010001 x 6101010002 x 6101010003 x Allocshare 10 10 10 6101010033 300 60 210 610201 6102010003 x 6102010004 x 6102010005 x Allocshare 10 10 10 6102010033 300 60 210 610202 6102020003 x 6102020004 x 6102020005 x Allocshare 20 20 20 6102020033 600 120 420 610301 6103010003 x 6103010004 x 6103010005 x Allocshare 20 20 20 6103010033 600 120 420 610302 6103020103 x 6103020104 x 6103020105 x Allocshare 20 20 20 6103020233 600 120 420 610401 6104010004 x 6104010005 x 6104010007 x Allocshare 20 20 20 6104010033 600 120 420

Thanks

Gowtham