The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Shivangi's avatar
Shivangi
New Contributor III
2 years ago

Pop Up Notification

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.

 
 
 
Extenders
Parsing

8 Replies

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

    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.

    • JackLacava's avatar
      JackLacava
      Icon for OneStream Employee rankOneStream Employee
      2 years ago

      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.

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    2 years ago

    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 

    • Shivangi's avatar
      Shivangi
      New Contributor III
      2 years ago

      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.

      • NicolasArgente's avatar
        NicolasArgente
        Valued Contributor
        2 years ago

        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 ?