Level 1: Lesson 7: 'P2 Product' is not recognized as a hierarchy in the model

Options
calvert
calvert Member, ALL USERS, GroupMember Posts: 3 Occasional Contributor

I am trying to insert the formula for SYS06 Product Details' Code line item but this error below is showing and it is happening to the Product Family line item too. How to find out what I did wrong? 

 

 
The formula for 'SYS06 Product Details' Code is invalid:

Code = CODE(ITEM('P2 Products'))

'P2 Products' is not recognized as a hierarchy in the model.

The ITEM function should take a hierarchy as argument

 

Capture.PNG

Comments

  • calvert
    calvert Member, ALL USERS, GroupMember Posts: 3 Occasional Contributor

    I believe I have it configured correctly but I was able to complete the activity by recreating the P2 Products model and SYS06 System module.  There must be something wrong somewhere but re-creating them did the trick. 

  • calvert
    calvert Member, ALL USERS, GroupMember Posts: 3 Occasional Contributor

    Code = CODE(ITEM('P2 Products'))

    This is the formula, Noelle. Just FYI, I have already resolved the issue and completed the activity by recreating the required modules.