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

Jorge_Haces's avatar
Jorge_Haces
New Contributor II
3 years ago
Solved

Can I execute a BR after saving data?

I'm trying to execute a calc after an input data in a CV, when the user click in the OS default save button (giving the flexibility to use a DB, CV or Excel addin with the same CV) Is possible?
Finance
  • ckattookaran's avatar
    ckattookaran
    3 years ago

    If you are going to do this in EXCEL, your option will be to use WcfEventHandler. I wouldn't recommend using SaveDataEventHandler as that will run on every save operation.

  • T_Kress's avatar
    T_Kress
    1 year ago

    Is your DQEH using a "StartDataMgmtSequenc" vs a "ExecuteDataMgmtSequence"?  I think start just starts and moves on but execute will wait for completion, so an execute may update task activity box better.

jesvam's avatar
jesvam
New Contributor III
2 years ago

Hi Chris! Thanks a lot for this, and thanks for your help last November if you may remember hehe!

I tried to write a SaveDataEventHandler to run in a dashboard available under a workflow Forms Workspace step, but realized it doesn't actually trigger when it's a DataAttachment being saved.

Do you know if your suggested approach here would work for DataAttachments? I'm assuming it's the same issue with a data attachment technically not being a datacell even though having a reference to one?

I have a main dashboard with embedded dashboards within tabs. On the first tab there is a cube view where dataattachments / comments can be saved. Then there is another tab with a Bi Viewer with a DataAdapter that pulls data from the DataAttachment table.

I guess from a technical perspective, the user navigates like this

1. Load main dashboard (which is not the one with the Bi Viewer)

2. Component Selection Change with the cube view on the first tab  

3. Save operation / event with the cube view, saving a dataattachment

4. Tab navigation to the tab with BI Viewer

Somehow during or after 3 I need to refresh the DataAdapter for the BI Viewer. 

Do you have any idea how to go about this? I could just add a button but it's not very elegant. I can raise a ticket if that's more suitable.

Br, Jesper

creddick's avatar
creddick
New Contributor
1 year ago

If I have a DQEH that kicks off a force consol but when I start it I have to go to Task Activity to see the progress because the box that comes up just jumps to100 and goes away.

Thanks CR

  • T_Kress's avatar
    T_Kress
    Icon for OneStream Employee rankOneStream Employee
    1 year ago

    Is your DQEH using a "StartDataMgmtSequenc" vs a "ExecuteDataMgmtSequence"?  I think start just starts and moves on but execute will wait for completion, so an execute may update task activity box better.

    • WernerN's avatar
      WernerN
      Contributor II
      1 year ago

      Thanks Teresa, I never thought about using Start and then trying to update the window that blocks the user. This seems to be the way to go for one of my requests. 

    • creddick's avatar
      creddick
      New Contributor
      1 year ago

      Thank you for you response.  I made that change and it works a bit better than just having the box go away, but now it just stays there and doesn't show the status as if they just had a regular consol going.  i will have to see how the users feel, but thank you.

      CR