LOOKUP's for the DAT02 PY Revenue to CY Module Level 3 Model Build

neg177
Regular Contributor

LOOKUP's for the DAT02 PY Revenue to CY Module Level 3 Model Build

Hi,

 

I have tried almost everything and have been stuck on this part of the model build or a day now. I have changed my dimensioned and tried to get them to match and still not working. I'm trying to pull in Actuals from the DAT 01 into the DAT02 and Looking up LT Account A1 inthe SYS03 Module. Please advise. 

 

Thank you 

neg177_0-1638903483450.png

Formula: 'DAT01 Historical Data'.'2019 Actual Sales'[LOOKUP:'SYS03 Account>Product Details'.'A1 Account']

 

Dimensions of DAT02 

neg177_1-1638903550695.png

Dimensions of SYS03

neg177_2-1638903580528.png

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
vinayvm
Certified Master Anaplanner

Re: LOOKUP's for the DAT02 PY Revenue to CY Module Level 3 Model Build

@neg177 

 

The error is because you are using lookup when the dimensionality of your source module and target module is same.

You need to change the dimensionality of your DAT02 module (use the list which has valid combinations of accounts and products)

HINT: As DAT01 is dimensioned by two lists (Acc & Prod), you will need to use lookup two times in your DAT02 formula

 

Hope it helps!

vinayvm

View solution in original post

ChrisAHeathcote
Community Boss

Re: LOOKUP's for the DAT02 PY Revenue to CY Module Level 3 Model Build

@neg177 

The formatting of the line item in the SYS module is P2 Product while the dimension of the DAT module is Product Flat. 

These must match for the LOOKUP to work. 

Chris
HeathcoteAndHerran.com

View solution in original post

3 REPLIES 3
vinayvm
Certified Master Anaplanner

Re: LOOKUP's for the DAT02 PY Revenue to CY Module Level 3 Model Build

@neg177 

 

The error is because you are using lookup when the dimensionality of your source module and target module is same.

You need to change the dimensionality of your DAT02 module (use the list which has valid combinations of accounts and products)

HINT: As DAT01 is dimensioned by two lists (Acc & Prod), you will need to use lookup two times in your DAT02 formula

 

Hope it helps!

vinayvm

neg177
Regular Contributor

Re: LOOKUP's for the DAT02 PY Revenue to CY Module Level 3 Model Build

That worked, 

 

Thank you 

ChrisAHeathcote
Community Boss

Re: LOOKUP's for the DAT02 PY Revenue to CY Module Level 3 Model Build

@neg177 

The formatting of the line item in the SYS module is P2 Product while the dimension of the DAT module is Product Flat. 

These must match for the LOOKUP to work. 

Chris
HeathcoteAndHerran.com