Allocation

[Former Member]

Hi, I am looking for help to get my allocation logic to work please.

Basically I have to allocate a cost, e.g. Promotion Cost to the base level of Distributor and Product by volume.

Below is the example of hierarchy:

Distributor:

      PU_233

               DI_140100

               DI_140140

               DI_140160

               DI_140170

               DI_140180

               DI_148400

               DI_149700

               DI_149800

               DI_149900

               PU_233_I

Product

     BP_02454

               OS_700427

               OS_700428

               BP_02454_I

Promotion Cost is in DOLLARS, and STW_VOLUME is in BARRELS

The data source is in TEST_DATASRC1, and the destination of allocation is TEST_DATASRC2

Any help is very much appreciated.

Thank you

Yani

[former_member186338 · Accepted solution]

Try at least:

...

*DIM UOM WHAT=USD; WHERE=<<<; USING=BARRELS; TOTAL=<<<;

Vadim

[Former Member]

Hi Yani,

In my opinion there is a problem with your allocation approach. You use 2 dim parenth for allocation. In this case the data on the only one member, it could be work but when you also have the data on the member OS_700427, the allocation will dublicate the allocated data.

You should use the base members of Product Dim.

Also, 3rd line should be;

*DIM DATASRC USING=TEST_DATASRC1; TOTAL=<<<;

and Vadim's post.

Regards.

Burak