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.

ChrisLoran's avatar
ChrisLoran
Icon for OneStream Employee rankOneStream Employee
3 years ago

Example dashboard you can build on top of this table, so admins can configure what Finance BR/Functions should be run when saving each Cube View.  This is much better than hard-coding stuff into Data Mgmt jobs.

The special entry "_Excel" is for when you do XFSetCell or QuickViews from Excel or Embedded Spreadsheet, where you haven't opened any particular cube view. There you can also specify a Custom Calculate BR to run, as a special "cube view"  name of "_Excel"  (underscore is important)

 

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.