Import data using multiple workflow profles
Hi everyone,
I have an issue in understanding how to implement multiple import steps within a workflow.
My client will load 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, however, the data will be loaded in full (with eventual adjustments) and should overwrite the data loaded through previous import steps (and this is the reason 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.
The problem now is that since we are using a different workflow profile at each step, the system does not automatically overwrite the data loaded through the previous workflow profile, and therefore the data is just added on top of the data that was loaded in previous steps.
Does anyone knows whether there is a way to overwrite data from previous loads when a new import step is used?
An idea I thought about was to delete the data on the cube through sql while executing the BR Connector rule but I don't know what tables in the db hold the data that I want to overwrite.
Thanks in advance for any help, and if something is not clear please ask, I'll be happy to clarify!
Did you try setting the overlapping siblings to False and then processing the workflows all the way through again? The behavior you describe is what I thought happens when that setting is True, in that it joins the sibling import profiles together when loading to the cube, regardless of from which load you are executing.
I thought setting that to False would then mean that each load would be treated individually and not as a join, so the second import would replace the first import to cube.
