Highlighted
New Contributor

Re: Is Something Wrong With my Role List? Level 1

@aashca9 

 

Tried that too, I got this error message: 

 

'All Roles' is not valid for the name of the top level item of Role. 'All Roles' clashes with the name of an existing List Member. 

 

However, no other list goes by the name "All Roles", so I'm confused as to where the 'clashing' is happening. 

Highlighted
Master Anaplanner/Community Boss

Re: Is Something Wrong With my Role List? Level 1

@sosunkwo 

Because the file you loaded included a "Parent" column. Since there's no parent (top level, in this case) you will get the error.

Your choices are to add a top level that matches the parent value in your input file or don't load the parent column.

Either of those will clear up your error!

 

Let me know what you end up doing. Just curious.


Jared Dolich
Highlighted
New Contributor

Re: Is Something Wrong With my Role List? Level 1

@Jared Dolich 

 

Ok, so I'm trying to run the import for the role list again. My question now is how would I "not load the parent column."?  Pls see attachment. Thanks

Highlighted
Occasional Contributor

Re: Is Something Wrong With my Role List? Level 1

@sosunkwo 

 

Figured it out with some help from @ChrisMullen - the issue is that you have to go into the SYS08 module and change the time scale manually from Month to Not Applicable (since you build the EMP03 module without time as a dimension). See attached screen shot - all you have to do is copy the "Not Applicable" in the first row to all of the other rows in the module. The little pivot table icon in the first column next to the row title is an indicator that something is off dimensionality-wise. Once you've fixed this you should be able to re-import your employee data and then proceed with updating your formulas for the new drivers / roles. Hope this helps!

Highlighted
Contributor

Re: Is Something Wrong With my Role List? Level 1

Wont it be non applicable anyway? Since its a system module and there is no need for time dimension. Even during module creation activity for SYS08 they mentioned to just take one employee dimension.

 

Unless I'm missing something here..

Highlighted
Occasional Contributor

Re: Is Something Wrong With my Role List? Level 1

This seems like a real tricky rabbit hole to send users down, and prone to frustrating them in completion of their certification. To wind up at this error you have to have (successfully, as far as you can tell) upload the source CSV for Roles, then Build EMP03 Module, then import data into SYS08 list, then when you go to change the formula you find this error. So you have to go back and undo the last two things you built, then go into the source file CSV, delete the Parent column entirely, re-upload that, go into the configuration of the list (not covered in any training video that I could find), add in the new top level, re-build EMP03 module, re-import data into SYS08 list, then you go to change the formula yet again, you now get the attached error. 

Highlighted
Occasional Contributor

Re: Is Something Wrong With my Role List? Level 1

What do you see in your "Role" list? Does it contain "Parent" and "Code"?

 

 

 

Highlighted
New Contributor

Re: Is Something Wrong With my Role List? Level 1

Hey members, so I've been carefully following this thread as had a couple of already mentioned issues, tried to fix everything and was able to make the model accept the new formula on EMP02 with reference from the Roles drivers in EMP03 using IF Employed? THEN 'EMP03 Employee Drivers'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0, however the result that I get from Medical Cost does not seem to be right as per the Module Certification question number 4. 

 

Wondering what else can I do? 

 

Does it look as the issue comes from the list? (meaning first step)

 

Note: Not looking for answer, just some extra guidance.