I am trying to load 3 data files via 3 import step within same WF.
What I see is the last imported data replace the data in the cube for the same intersection.
I want the data files to sum up instead of replacing with the last loaded file.
What is the way to do this?
I cannot use the same import step - as one of the import has a parser rule running which I dont want to run for the other load file.
Please advise.
OS_Love - Coupe of ways
1. Using WF Channel - Define WF channel for each WF Import because when you try to load to the cube it will clear and load. using WF channel (level 4 DU) it will clear only that particular intersection.
2. Set the below settings in WF. Import one should be replace and other 2 Import should be append.
Is data being loaded using different Source Ids?
Yes- diff source id
Are you doing a Import - validate- load? Can you confirm the 3 SI# that you are using?
