Having issues putting in formulas in my "SYS06 Product Details" Module. Level 1 lesson 7.2.2.

jpascal
jpascal
in Anaplan platform discussions

 

 

I am trying to create the code "CODE(ITEM('P2 Products'))" inside my module. I keep getting an error saying, "P2 Products' is not recognized as a hierarchy in the model. The ITEM function should take a hierarchy as argument." I was wondering if anyone could help me with this issue.  I have attached pictures of both the issue and the pivot view. 

 Thank you.

Screen Shot 2020-11-25 at 11.52.35 AM.png

 

Screen Shot 2020-11-25 at 11.56.44 AM.png

Comments

  • jpascal
    jpascal

    I am also having the same issue with the SYS08 Emoloyee Module

  • eypoole
    eypoole

    Hi!

     

    For SYS06 Product Details, you have the correct formula but you have your dimensions wrong. Switch them around so P2 Products is in Rows & Line Items are in Columns.

     

    For SYS08 Employee Details, use the same formula (but with E2 Employees#) and the same dimensions (E2 Employees# in Rows & Line Items in Columns).

     

    Hopefully this works for you!

Categories