Allocation

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