4.6.5 Sale Planning Model: DAT02 module question

edited August 2023 in Academy Discussions

hi . i hope you all are doing well. i have a problem in level 3 activity 4.6.5 Sale Planning Model: DAT02 module . i tried all possible solution but could not find the answer.in this example i had to build module DAT01 first with two dimension product flat @& A1 account and FY19 ( PICTURE 1) .

then i imported values from data hub . after these i created DAT02 module with combinations list A2 Account>Product# and FY20 . when i want to use lookup functions i get

an error ( picture 2 ) . i have done all the hints in other discussions but i still receive an error. could you help me please ?

the formula : 'DAT01 PY Revenue'.REVENUE[LOOKUP: 'SYS00 Time Settings'.PY Qtr, LOOKUP: 'SYS03 Account>Product Details'.'A1 Account']

Best Answer

  • pyrypeura
    Answer ✓

    Your Lookup seems to be missing lookup to the product dimension. Even tough items in product flat and 'A2 Account>Product#' has same names Anaplan doesn't recognize connection between these without a lookup done.