Level 1 Lesson 7, activity 7.2.4

Hi,

I followed the course instruction to build the module SYS08 Employee Details and import data for Employee.csv.

'Code' and 'Name' and 'Dept' not loaded, then I tried to insert formula as suggested for 'CODE' and 'DEPARTMENT' but there was error message 'E2 EMPLOYEE#' is not recognized as a hierarchy in the model. The ITEM function should take a hierarchy as argument.

=> Then I mapped 'Name' and 'Dept' and so now 'Dept' and 'Name' are filled but 'Code' not filled.

Is there anyone knows was there error when I created the system module or what steps was wrong?

Comments

wskagegard

Hi!

Are you sure you have imported the code into the 'E2 Employees' list? Should look like below.

ShirleyV

Hi,

Thanks for reply. Yes, I did but strangely it did not map the code.

activity_7_145088.PNG

wskagegard

CAn you show me your function in the code line item?

ShirleyV

I can't find the 'function'. Here are the screenshot for 'SYS 08 EMPLOYEE DETAILS' and module showed 'functional area'. Or please let me know where I shall look for it.

activity_7_145090.PNG

wskagegard

For the code line item in SYS08 there you need to have the function. CODE(ITEM('E2 Employee'))

wskagegard

ShirleyV

Thanks a lot! Now it is working. Before when I copy the formula from the training material it always prompt with error message said not recognized as a hierarchy but now I input manually and now it is working. 👍

activity_7_145098.PNG

Quick Links

Recent release news

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
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…