cancel
Showing results for 
Search instead for 
Did you mean: 

SAC Planning Data Action & Allocation in a single step

GavinMonteiro3
Participant
0 Kudos

Hi All,

In SAP Analytics Cloud (SAC) Planning, we have a requirement to transfer values (from one cost center to another) booked on the head office, in %'s that would be specified by the users.

In the below example, Head office has Rs 1,000/- expenditure, the user would mention 50% to be allocated to Warehouse & 20% to be allocated to Ecom team 

BEFORE Allocation

GavinMonteiro3_1-1715960266201.png

 

After he mentions the %'s, the expectation is that the values in the columns should look as seen below: -

AFTER Allocation

GavinMonteiro3_0-1715960252563.png

 

How can we achieve this in SAC using a Data action step (since the user is using the microsoft office SAC excel add in & hence we wouldnt want to use the distribute/redistribute feature present in the story).

 

@N1kh1l if you could please provide any inputs in achieving this.

 

 

Regards,

Gavin.

View Entire Topic
N1kh1l
Active Contributor

@GavinMonteiro3 

After he mentions the %'s, the expectation is that the values in the columns should look as seen below: -

AFTER Allocation

N1kh1l_0-1715960391204.png

The Data Action run will be required to see the results. The Data Action currently cannot execute automatically on Data save.

 

The Data Action would be very simple. You can also use standard Allocation step for this.  If you use Advance Formula for this

MEMBERSET [d/Account]="Amount"

MEMBERSET [d/costcenter] = ("WH","ECOM") // list of recievers

DATA()=RESULTLOOKUP([d/Account]="AllocPerc")*RESULTLOOKUP([d/costcenter]="HQ")

DATA.APPEND([d/costcenter]="HQ")=RESULTLOOKUP()*-1 // -ve offset on HQ

 

You can adjust this according to your requirement. For simplicity store the Allocation % on same intersection as Amount but just a different account.

 

Hope this helps !!

Nikhil

Nikhil

 

 

GavinMonteiro3
Participant
0 Kudos
Thanks N1kh1l for your help.