Loading Data at Parent and Child Level but avoiding double counting

RijkersB

Hi Community,
I am stumped on how best to handle this situation.
I have to ingest data at multiple levels of a list hierarchy. i.e. Parent Level (fruit) and child level (eg. apples) but I need to avoid double counting when reporting? I am struggling with how best to handle the situation without double counting or excessive commplications to the model to filter out the data. The Anaplan model I have parses out the data using the underscores "_" per the Level 2/3 Attributes lesson.

When building the lists in the model using the saved views I filtered out the F03 list codes codes ending "_0" then I realised I couldn't report Dimension A data
When I leave them in there, Dimension B reports a double count….

Any guidance on how best to handle this situation would be appreciated.
Help!

Parent Child Double count.xlsx

KUMARNR

Hi @RijkersB

You are loading the data in two different levels, since we have F03 as More granular, while importing the data just consider only F03 and just filter out all the other levels and only keep F03 level and load the data for any level using parent relation. and also, for any reporting, later if you switch on the summary it will sum for all the levels.

Hope this helps!