Allocation Logic

[former_member1289965]

Hello Gurus, I am trying to test the allocation in BPC.

I have this scenario:

1. I have a dimention called SKU that has all SKUs that the company sells. Also I have a Hierarchy that represent Product Family.

2. User will imput data at Product Family level, so that I will have a dimension with all the Product Family.

3. I need to allocate the data inputted into all the corresponding SKUs that corresponign to that hierarchy level?

Any idea on how to deal with this?

Thanks

Sergio

[Former Member]

Hi Sergio,

Could you please be more specific re the data to be allocated. I'd assume that you enter data to NO_SKU/ PRDOLINE1, PRODLINE2 &c intersections and may need to allocate using last year's actual figures.

In this case something along the following lines:

FACTOR=USING/TOTAL

DIM SKU WHAT=NO_SKU; WHERE<>NO_SKU; USING=<<<; TOTAL=<<<

DIM PRODLINE WHAT=BAS(TOTAL); WHERE=<<<; USING=<<<; TOTAL=<<<

DIM CATEGORY WHAT=PLAN; WHERE=<<<; USING=ACTUAL; TOTAL=<<<

DIM TIME WHAT=BAS(%YEAR%.TOTAL); WHERE=<<<; USING=BAS(%YEAR%(-1).TOTAL); TOTAL=<<<

Hope this helps

Madis