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
Solved
Button to call DM job or run Consolidation in Excel
Hi Experts,
We are working on create a button in Excel for end users to trigger DM job or Consolidation. Idea here is to have more than one consolidation with different POVs and don't want to rely ...
I wouldn't say you need to upgrade to V8 (unless there is something about your security setup that requires it), but the suggestion of using the REST Api is sound. With that, you can trigger a DM job pretty easily.
This said, it seems like a lot of "reinventing the wheel". It will require quite a bit of effort and Excel VBA for fairly little gain. I believe nowadays you can launch Linked Dashboards from Excel, so you could just have a Dashboard that can launch a Custom Calculation.
JackLacava
OneStream Employee
OneStream EmployeeI wouldn't say you need to upgrade to V8 (unless there is something about your security setup that requires it), but the suggestion of using the REST Api is sound. With that, you can trigger a DM job pretty easily.
This said, it seems like a lot of "reinventing the wheel". It will require quite a bit of effort and Excel VBA for fairly little gain. I believe nowadays you can launch Linked Dashboards from Excel, so you could just have a Dashboard that can launch a Custom Calculation.
Thanks, Jack! We did think about using a Dashboard and launching that from the Excel. However, a button in Excel itself was preferred so that it's a single click for the end users.
