Join / sign up Review IBM Planning Analytics
Incremental updates are possible, but they're fiddly to get working.
Step 1. Make the history dataset. This is the first load that generates the base table. Step 2. Make the current dataset. This is what will source the incremental update.Step 3. Make a data module, importing the two datasets previously made. Make sure to give them meaningful identifiers.Step 4. Make a union custom table between the two datasets. Step 5. Make a dataset based on that union.Step 6. Import the new union dataset into the data module and give that a unique identifier. This is where it gets tricky. The DM interface doesn't let you replace items in a union. Step 7. Copy the unique identifier from the history dataset feeding the union. Step 8. Remove the history dataset - this should cause a validation error.Step 9. Replace the identifier of the union dataset with the identifier you copied from the history set. This will replace the missing table in the union and cause the validation error to go away. Now when you refresh the union dataset, it will union itself to the current dataset, effectively an incremental update.