Level 3 4.6.5 Sale Planning Model: DAT02 module
I have tried to formulate the PY actual sales revenue as
'DAT01 PY Revenue'.Revenue[Lookup: 'SYS00 Time Settings'.PY Qtr,Lookup: 'SYS03 Account>Product Details'.'A1 Account']
Below is my screenshot for DAT01 whereby I imported the numbers from DAT05 in Datahub.
Below is my screenshot for DAT02 module:
However, I received a message that states "Format of mapping used for lookup doesn't match any dimension of the source".
I am not sure if it is because of my SYS03 format for A1 account is not correct or DAT02 dimension is incorrect.
Please advice. Thank you!