Forum Discussion

GParreiras's avatar
GParreiras
New Contributor III
24 days ago
Solved

Replace not working

Hi all, I'm experiencing an issue with the connector in one of the cubes. Although everything is set to "replace," the stage is not being cleared, and old data is being loaded together with the new ...
Application Properties
  • GParreiras's avatar
    GParreiras
    12 days ago

    It seems the 'Replace' option doesn't replace all time periods every time, but 'Replace (All Time)' does. I'll update all workflows to use the 'Replace (All Time)' method. However, for batch file loading the documentation only shows only "R" and "A", i found some others. 

     

    Even if the workflow is set to "Replace (All Time)," you still need to specify the proper load method in the batch file name. I’m currently using "RT." Here is what we have for the replace load methods.

    R = Replace
    RB = BackgroundAllTimeAllSourceId
    RT = ReplaceAllTime

     

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
17 days ago
  1. which version are you on?
  2. Are you changing the SourceID value between loads? IIRC, as long as the Source ID stays the same, the system should automatically clear everything related to it when you reload.

 

GParreiras's avatar
GParreiras
New Contributor III
15 days ago

Just found another workflow with the same issue. This time, it has a SourceID. In this case, it's a flat file load. The log shows the time and periods that were loaded—today, by the way. But the workflow didn't refresh the loading time or delete the old data in there.