I have some questions regarding allocations. Hope I can get some advice from you. Thank you so much in advance!
Here is the background information:
- Source Module:
Flat file without time dimension.
- Calculation Module:
Dimension: by WSLRPDCN, by Month
The target can be adjusted at 5 data level – 1) State, 2)WSLR, 3)Brand, 4)Line Code, 5)PDCN by month.
The main module is dimensioned by WSLRPDCN by time. WSLRPDCN is concatenation of 3 lists(dimensions) 1) WSLR, 2)PD, 3)CN
1)State is Parent of WSLR
2) Brand is Parent of PD
3) Line Code is Parent of CN
- For example, like Line 1 – if the target in certain state (MO), certain brand (BUD) and Line code (3) is $1K, the all WSLR (child) under this state (parent) are going be allocated equally, all PD (child) under this brand (parent) are going to be allocated equally, and all CN (child) under this Line Code (parent) are going to be allocated equally. Then combine with related WSLR, PD, CN to have target by WSLRPDCN
- For example, like Line 6 - if the target in certain State is $6K, then all WSLR under this state is going to be allocated equally with total $6K, then combine with all PD and all CN to have target by WSLRPDCN
Issues: How to manage this type of allocation? Thanks!