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.
I am also having the same issue with the SYS08 Emoloyee Module0
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!0