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!
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.
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.
I ran into a bit of trouble, and while there was some help on this thread, I just wanted to add that you should check the Data Type of the Role (and Region for me) in your modules; make sure they are formatted as a LIST and not as TEXT ; then, you might need to re-import the data after refomattting the data types.
Update the LOOKUP function to reference a line item in the employee property module which is formated as the Role list.
If you have this as Text then you can use FINDITEM to convert this to a list format in a second line item. The line item must be LIST formatted.
The error is presented as Anaplan is attempting to map the data in the source to dimensions in the target. If any differences are not mapped then it will attempt to take data from the top level by default. If there is not a top level and you haven't used a mapping you will get this error.
Chris Heathcote Bedford Consulting
Gold Partner and Regional Partner of the Year 2021, EMEA