Re: Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.
Thank you, my lookups are working now, brilliant, my data type was incorrect.
Apologies I am working on the next section REP04 Employee Expense Summary, I have set up the module, no worries, I am struggling with the formula, if I were calculating within excel I would opt for a SUMIF, which within Anaplan is a SUM function. I am trying to complete this using SYS08, is this the correct approach:
Do I need to create a sub model as per EMP03 and EMP02 to complete a SUMIF from SYS08 Data?
A couple of things, you should not have subsidiary views defined (the little icon after the line item in your picture). That happens when the dimensionality of the line item is not the same as the what has been defined for the module. Secondly, I am not sure where E3 Roles list came from, Roles should be a flat list. Lastly, the module should look like the below.
I had created a EMP03 Module "Employee Drivers by Role" as instructed. Please find the attached screenshot for the same.
Now where we will get the Data file to import into this module and we don't have role as a line item.What relationships we need to create in SYS.08 Employee Details Module to resolve this? Before using this below mentioned formula,
Bonus - IF Employed? THEN Salary * 'EMP03 Employee Drivers By Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0
what other steps I need to follow to build the relationship in SYS.08 Employee Details.