Forum Discussion

fc's avatar
fc
New Contributor III
5 months ago

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 ye...
Import
Workflow
  • T_Kress's avatar
    T_Kress
    5 months ago

    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.

fc's avatar
fc
New Contributor III

Hi T_Kress,

thank you for the answer.

There are still things that are not clear to me. 

The DataSource that I use is the same for all the 4 load steps. Its settings are the following:

Since I use the same DataSource for all the load steps, I would expect them to have the same SourceID, or am I wrong?
I struggle to understand where is this SouceID defined and what's its purpose.

Thanks again for the help,

T_Kress's avatar
T_Kress
Contributor III
5 months ago

Yes, the source ID is defined at the data source level so if they are all using the same data source then that is not the issue.

You could try setting the "Can Load Overlapping Siblings" to False.  If these PX imports are the only one under a particular parent, setting this to false may work for you.  Again, test.

Lastly, you could consider using WF channels to control what is or is not cleared with each import load.