Allocation process in SAC - many Cost Center values to one Cost Center

[Marta12]

I would like to allocate values from many Cost Centers to One Cost Center dynamically using parameters.

It's not possible to use parameteres with "Any" cardinality in source in allocation steps, but maybe there is a possibility to do some workaround?

I've tried like above, however the number of Source CC (WB) should be flexible - sometimes two, sometimes four CCs should be allocated to one target.

I've tried to do that also by Advanced formula in Data Action, however the issue is that I can only copy the data there and at the end it's not removed from the source. 

Would you be able to help me with a solution?

Best regards,

Marta

[MoonJun]

Hi @Marta12

Please refer to the Advanced formulas script, which populates the Aggregate value from the selected Source CostCenter and writes it to one Target Cost Center. It also deletes the Source CostCenter value.

• Source Cost Center Parameter

• Target Cost Center Parameter

• Advanced Formulas Script

MEMBERSET [d/Measures] = "Amount"
MEMBERSET [d/CostCenter] = %SourceCC%

//Aggregate Source Cost Center (%SourceCC%) value and write it to Target Cost Center (%TargetCC%).
DATA([d/CostCenter]=%TargetCC%) = RESULTLOOKUP()

//Delete Source Cost Center (%SourceCC%) value.
DELETE()

I hope it helps to solve your issue.

Moonjun 

[William_Yu1]

As you already achieved the logic with advanced formula, why not just add a DELETE() statement to remove the source? 

[Marta12]

Because to copy from many CCs to one CC I need to use "AGGREGATE_DIMENSION" function and after using a dimension of Cost Centers in this statement, I'm not able to use it in any other statement, nor in DELETE()