"Cannot execute step because the prior workflow step is not completed"
We have Workflow A, and Workflow B. We get an error when the loadCube step in workflow B, when Workflow A is in Validation step. The error we get is "Cannot execute step because the prior workflow step is not completed. . (WP#WorkflowA.Import:S#Actual:T#2022M1)" The name the actual workflow has been changed to protect the innocent. Our question is: what is causing this issue and how do we fix it? It's not clear in the documentation what exactly triggers this error message. The parameters passed back imply that one cannot load to the same scenario and time if another workflow to that scenario and time is still open. WorkflowA and WorkflowB are loading to the same scenario and time, but to different accounts.
Clear data using level 1 data unit (rather than level 2) on data load
Hi all I was wondering if it is possible to override the default 'clear and load' settings on a data load step from 'Level 2: Workflow Data Unit' to 'Level 1: Cube Data Unit' Just to give a bit of context: We perform a data copy from a Budget scenario (using Data Management Sequence) to a Forecast scenario to provide a starting data position for divisions to use when they capture their forecast data. Once the data copy is complete, the process for divisions to update their forecasts is to extract an Excel Fixed File Template on which they will make their changes and additions over the copied Budget data, and then to import that file via their Workflow to the cube. However, when wanting to remove an account for instance, the only way to do so it to load zeros to that account. This is because the load clears by account and not entity. Is it possible to change the load so that it deletes all accounts? Thanks, MarkRange Scenario - Data Import
I'm trying to load plan data into a range scenario that spans across 2 years. While the workflow view year is 2024, the range is set from 2024M1-2028M12, so the expected result would be that the load can occur for the 2024 and 2025 data that is being loaded in this import step. Is that hypothesis true? The primary question is: What is the difference between workflow view year and workflow range? Additionally there is an icon in the workflow that "cannot import data to time periods 'AFTER' the workflow view year [2024] (see below). In the application properties, there is a setting that allows loads after workflow view year. When this is set to true, the icon goes away and data can be loaded to both years. We are trying to avoid flipping this switch to keep users from accessing any time periods not within the range.Duplicate Source Lines From Data Source
Hello there, In an Import WF profile, I would like to duplicate all rows where the UD3 member is different than None. In the duplicated row, I need to change the UD3 POV to 'None' I know this can be done easily through 'Derivative Rules', however I am trying to do so in the Data Source through a 'Complex Expression' or 'Business Rule'. PS: This is bad practice since source data should NOT be altered to keep Audit trails, but in my case I am just exploring possible options
Data load input string format
Hello everyone, We are trying to upload data to OS through a csv but I'm getting the following error I checked the file both with excel and directly with a text editor and it seems the amount is correctly formatted Do you guys have any idea why OS is giving us this error?
