Issue with multiple data load steps at year end

Hi everyone,

My client loads data through a classing import step throughout all the months of the year. In addition to that, they asked to set up 3 additional import steps (P13, P14, P15) to be used in December that will serve as adjustments to the previous data loaded on the cube.

At each import step the data will be loaded in full and should overwrite the data loaded through previous import steps (and this is why we don't use forms but we use multiple import steps).

For example, when P13 is loaded, it should overwrite the data loaded through the Import step, and when P14 is loaded it should overwrite the data loaded through P13, and so on.

I already set the "Load overlapped siblings" setting of the parent profile to false:

The loading seemed to work fine, as each load process overwrote the previous one.

But there is an exception that we don't understand how to fix.

We set up a mapping rule for a specific source account is such a way that it can be mapped into one or another target account depending on the presence or absence of specific parameters provided in the source load file. If the parameters are present, the amount of that source account is mapped into a specific Asset account in Onestream, and if the parameters are not present, the amount is mapped into a Liability account. During each load, the account can be mapped either into one or the other target account (therefore if we map into the Asset account, the liability account should be = 0, and the other way around).

Now, what we noticed that if in P13 the source parameters are present, the system maps the source account into the Asset account in Onestream (which is correct). But then, if in P14 we remove the parameters, the system correctly maps the source account into the Liability target account in onestream, but the amount loaded during P13 on the Asset account is still present in the cube and visible in the reports.
We would expect that amount not to be present, since each load step should completely override the previous step.

Does anyone has any idea why this might happen?

I know it's quite a specific question, if you need further info please ask.

Thanks in advance for any hint!