cancel
Showing results for 
Search instead for 
Did you mean: 

Allocation issue

0 Kudos

Hello Experts,

I am writing an allocation script for allocating cost but I am facing some issues in my logic script.

Here is the scenario,

I have 2 additional dimensions in my model (Product and Cust_Group) Hierarchy of these dimensions are listed above in the figure. Apart from this Sales volume is already in the database with product and cust_group at base level. Now I have entered a total amount with product -> No_Product and Cust_Group->Input 100000, 200000 300000 for Jan, Feb and March.

Now what I need to do is to allocate this total amount in Cust_Group and Product according to the sales_volumes that are already in the system.

I hope this you guys have understand what I need and guide me what should I write in my logic script to achieve this scenario. My script logic is written below.

*XDIM_MEMBERSET ACCOUNT=FIXED_COST_GROSS

*XDIM_MEMBERSET CATEGORY =Plan

*XDIM_MEMBERSET PRODUCT= NO_PRODUCT

*RUNALLOCATION

  *FACTOR=USING/TOTAL

   *DIM CUST_GROUP   WHAT = INPUT ;   WHERE =BAS(NATIONAL);  USING =<<<; TOTAL=<<<

 

*ENDALLOCATION

Regards

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Initial data (WHAT):

Account: Fixed_Cost

Product: No_Product

Cust_Group: Input

Driver (USING/TOTAL):

Account: Sales_Volume

Product: BAS(All _Products)

Cust_Group: BAS(NATIONAL)

Allocate to (WHERE):

Account: Fixed_Cost

Product: BAS(All _Products)

Cust_Group: BAS(NATIONAL)

Is it clear?

Vadim

0 Kudos

Hi Vadim,

Thanks for your reply and its very helpful. I am still unable to understand how can I write the same in my script. I am writing below what I understand from above. Please correct me if I am wrong

*XDIM_MEMBERSET ACCOUNT=Fixed_Cost

*XDIM_MEMBERSET CATEGORY =Plan

*XDIM_MEMBERSET PRODUCT= No_Product

*XDIM_MEMBERSET CUST_GROUP= Input

*RUNALLOCATION

  *FACTOR=USING/TOTAL

   *DIM ACCOUNT   WHAT = Fixed_Cost ;   WHERE =Sales_Volume;  USING =<<<; TOTAL=<<<

   *DIM Product   WHAT = No_Product ;   WHERE =BAS(All_Products);  USING =<<<; TOTAL=<<<

   *DIM Cust_Group   WHAT = Input ;   WHERE =BAS(NATIONAL);  USING =<<<; TOTAL=<<<

*ENDALLOCATION

Regards,

Sami

former_member186338
Active Contributor
0 Kudos

And what is the result? Test in UJKT - for the single month!

*XDIM_MEMBERSET TIME= yyyy.mm //some month

*XDIM_MEMBERSET CATEGORY =Plan

*RUNALLOCATION

*FACTOR=USING/TOTAL

*DIM ACCOUNT   WHAT = Fixed_Cost ;   WHERE =Fixed_Cost;  USING =Sales_Volume; TOTAL=<<<

*DIM Product   WHAT = No_Product ;   WHERE =BAS(All_Products);  USING =<<<; TOTAL=<<<

*DIM Cust_Group   WHAT = Input ;   WHERE =BAS(NATIONAL);  USING =<<<; TOTAL=<<<

*ENDALLOCATION

Vadim

Answers (0)