The substitution variable DataLoadConsolMember is not working as expected.
We have two DLRs: one for overrides and one for trial balance (TB) load from ERP.
First, we load the overrides data, which successfully appears in FCCS. However, when we load the TB data in Replace mode, it deletes the overrides.
To resolve this, we created the DataLoadConsolMember substitution variable and set it to TRUE (screenshot below).
Despite this, the override data still gets deleted.
Question: Are there any additional configurations required for the substitution variable to work as expected?
Thanks,
Avani Makwana