Level 1 Model Building Certification Exam Issues With Updating EMP02 Formulas

Hello,

I am currently in the process of completing the Level 1 Model Building Certification Exam. I've gotten to a point where I've been asked to update the EMP02 formulas for Bonus %, Car costs, Phone costs, and Medical costs to reflect the new EMP03 module. I attempted #4 and failed both times, so now I'm on #5, which asks about Sales department phone costs in December 2020. The current formula I have in EMP02 is:

IF Employed? THEN 'EMP01 Employee Drivers'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0

I've attempted the following formula:

IF Employed? THEN 'EMP03 Employee Drivers by Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

However, when I tried to submit this formula into the module, I got the following error:

Invalid formula for 'EMP02 Employee Expenses'.Phone costs: Automatic sum of 'EMP03 Employee Drivers by Role'.Phone Allowance over Roles hierarchy is not possible as Roles does not have a built-in top level

What exactly am I doing wrong here? Any help would be greatly appreciated.

-ws696201

Accepted answers

All comments

Akhtar.shahbaz

Hi @ws696201

Can you check you Role list on configuration tab whether you have entered Top level item or not?

Please read below best practices article on "Top Level Item and Parent Hierarchy"

https://community.anaplan.com/t5/Best-Practices/Top-Level-Item-and-Parent-Hierarchy/ta-p/56249

Hope this helps!

Thanks

Akhtar

ws696201

Hi @Akhtar.shahbaz

I looked at the info you gave and tried inputting "All Roles" as the top level. However, there is already a parent item in the list called All Roles. Is there a better top level, such as Total Company to use for this roles list?

-ws696201

jtootle

Hey @ws696201 ,

I am in the middle of the exam and am having this exact issue. Did you ever sort this out?

Formula updates won't work (same error message you got), and I cannot add the top level item "All Roles" for the same reason you couldn't - "'All Roles' is not valid for the name of the top level item of Roles. 'All Roles' clashes with the name of an existing List Member."

einas.ibrahim

Hey guys @jtootle @ws696201

I wish you the best in learning and obtaining the certificates.

I just want to direct your attention that you should not be sharing exam questions or seek help in that area on the forums.

Please try to identify the area/concept where you feel you need assistance and we will be happy to help you.

Mention me in these general questions and I’ll be more than happy to help you.

good luck

TriciaL

I am having the same issue....just wondering how you were able to resolve this. This is the error that I keep getting:

Invalid formula for 'EMP02 Employee Expenses'.Bonus: Automatic sum of 'EMP03 Employee Drivers by Role'.Bonus % over E3 Role hierarchy is not possible as E3 Role does not have a built-in top level

Thanks!

ifeldman

I am having the same issue, any ability to understand how this was resolved?

fuvasm

Hi @ws696201,

When you tried inputting "All Roles" as top level, you are getting error "name already exists". Any guess where it exist? Did you check your data imported into Role list?

Point to note - check source data and understand data before import, and if necessary set up Top Level or Parent Hierarchy in your model before data load. Trust this clarifies.

Cheers!

shruti.mahato

Step 1: Delete the Parent All Roles from Grid view.

The hierarchy will become flat hierarchy.

Step 2: Now mention/update "All Roles" in Configure tab as Top hierarchy.

Hope it helps.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…