Hi Anaplan Experts:
I am looking for advice on optimizing a process to delete obsolete product data by comparing our model data with the Datahub. My current workflow involves the following steps:
1. Clear all data from a temporary list (List A).
2. Import the latest product data from the Datahub into List A.
3. Compare List A with the master list (List B) to identify and delete products in List B that are missing from List A.
4. Import the latest product data from the Datahub into List B to add any new products.
In step 3, I am using the following formula to generate a Boolean for the deletion process:
ISBLANK(FINDITEM('P1 Compare', CODE(ITEM('P1 - CategoryGroup Master'))))
I noticed that the Calculation Complexity is "All cells" and the Calculation Effort is 100%. Given that I have five levels of product data and approximately 2,000 SKUs at the fifth level, I am concerned about performance.
Are there more efficient ways to handle this logic, or is this the recommended approach for this scenario?
Thank you
