I still am not convinced that the formula didn't work - it has to work given the dimensions are correct.
To answer you question -You can do that but I wouldn't recommend you do that because it goes against DISCO (simply put best practices) Also you already have a connection between Employee, Department and Country, there is no need to have these line items in the module
Can you please post screenshots of your target module & formatting of your mappings. I place my bet on the mappings.
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.