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.