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.