4.6.5 Sale Planning Model: DAT02 module

SuhasDesai
Occasional Contributor

4.6.5 Sale Planning Model: DAT02 module

Hello All,

Please note, while working on 4.6.5 Sale Planning Model: DAT02 module, below are the steps i have completed-

1. Created A2 Accounts. Product# list and updated it with concatenated codes

2. Created new Model DAT03 PY Revenue from Data Hub for inputting data from Data Hub

 

SuhasDesai_0-1631615480507.png

 

3. Created DAT02 PY Revenue to CY as per instructions and have entered below formula-  

'DAT03 PY Revenue from Data Hub'.PY Revenue[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account', LOOKUP: 'SYS00 Time Settings'.PY Qtr]

 

The system is showing aggregated results and applying the same to all products-

 

SuhasDesai_1-1631615600710.png

 

 

Could you please check and let me know what i am missing here?

 

Thank you.

Suhas

 

1 REPLY 1
Misbah
Moderator

Re: 4.6.5 Sale Planning Model: DAT02 module

@SuhasDesai 

 

Check the dimensionality of source module and target module and you will be able to figure it out - whether you are missing any LOOKUPS

 

Misbah