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




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


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

  • 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!