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

Screen_Shot_2020-11-25_at_11_91939.png

Comments

jpascal

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

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!

Quick Links

Recent release news

October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…
Recording now available! October 29 platform release event
If you missed our October 29, 2025 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…