Dear Community,
I have a requirement to generate a pop-up or warning message during the Data import process based on a specific condition. If the condition is met, the pop-up should inform the user, but the import process should continue without causing a hard fail. Is this achievable ?
Can anyone please suggest a method to achieve this.
Thank you.
Don't sweat it. One often-overlooked aspect of OneStream, is that the Workflow is not fixed to "Import, Validate, Load":
If you leverage "Import, Workspace, Validate, Load", you can drop a dashboard ("Workspace" - not to be confused with 8.1 workspaces, sigh) in the middle of your process - when the data is in Stage but not yet in the Cube. That dashboard (specified in Workspace Dashboard Name) can run any arbitrary check you can imagine, producing the necessary warnings or errors.
Thank You!! Will try this way.
JackLacava We could also leverage the Event Handlers, right? it is more transparent than adding a workspace...
Event handlers work in background, they're not meant to interact with the user interface. They could definitely perform checks and write the output somewhere, but to review that output you'll still need a Dashboard.
Hi Shivangi!
Did you have a look at the derivative rules. They might help you for that. Do you need to check the special condition BEFORE or AFTER it is transformed - One would be a source derivative rule and the other one the target derivative rules.
Cheers
Hi NicolasArgente ,
Hi Thank You for your input. Actually I need to check the value for a particular dimension from the source, so if it is missing, a notification should be generated stating - this value is not expected. I am stuck with the notification part, where I'm not able to just warn the user without stopping the import process. Is there any way to achieve this please.
Shivangi You would need to use a Source Derivative to check the value. Now, I am not sure you can have an information pop up like this that has no effect on the import itself when using the default import. Maybe a workspace before the import could be a solution... but not sure you want to do that.
As anyone done a msgbox during an import without interfering with the import ?
