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

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

Dimensions of DAT02

Dimensions of SYS03

Accepted answers

Vinay VaradarajM

@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

ChrisAHeathcote

@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.

All comments

Vinay VaradarajM

@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

ChrisAHeathcote

@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.

neg177

That worked,

Thank you

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385