Scenario: I changed the parent of a child then how to do incremental load when there is a change in parent child hierarchy?
@PujithaB
This is a "depends" answer, but I'll run through a number of scenarios
Assuming you have a data hub (which you should have!), you should be used flat lists at the lowest level (not hierarchies - Planual 5.07-03 ). You should also have a module by the child list with the parent attributes.
There are two ways to get the delta load from the hub to the source model(s).
1. This one is dealing with the specific issue of a change in the parent.
1a. Create a new line item in the module as above, to hold the parent attribute again.
1b. Create a boolean line item in this module too to act as a filter for a saved view used for the downstream export
1c. Set the formula to check the parent attribute vs the new line item from 1a
1d. Before you import the data from source, run an internal import from the parent attribute to the line item from1a
1e. When you import the data from source, the line item from 1b will highlight any differences in the parent
You could view these differences in a dashboard for validation purposes, because if you have any logic based on the parent in the downstream model, the calculations on the child level will change
If you need to track month by month changes in the parents in the downstream model, you can also create a module by month and hold the parent values for the flat child list and aggregate the data using that
2. A more general approach to delta loads which works well if the source file only contains new records is:
2a. Add a column to the source data with TRUE for all rows
2b. In the data hub, create 2 boolean line items
2c. Prior to the import, run an internal import from Reset to Exports? to clear out any previous values
2d. Import the source data and bring in the TRUE flag to the Export? line item. This can then be used to export the data downstream and only records in the source will be flagged to export
I hope this helps
David
Hello Everyone, Our team is currently preparing for the requirements gathering phase of our 1st upcoming Anaplan implementation. To ensure that our design aligns perfectly with our business processes and effectively addresses our users' needs, we want to conduct a thorough discovery process. Could you please let us know if…
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
