03-19-2024 02:56 AM
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.
03-19-2024 03:15 AM
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
03-19-2024 04:07 AM
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.
03-19-2024 05:35 AM
@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 ?
03-19-2024 08:50 AM - edited 03-19-2024 10:59 AM
You could send an email to alert this.
03-19-2024 09:07 AM
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.
03-19-2024 10:08 AM
Thank You!! Will try this way.
03-19-2024 10:57 AM
@JackLacava We could also leverage the Event Handlers, right? it is more transparent than adding a workspace...
03-19-2024 11:01 AM
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.