Forum Discussion

harijanakiram's avatar
harijanakiram
New Contributor II
2 years ago

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 ...
Consolidation
User Interface
  • JackLacava's avatar
    JackLacava
    2 years ago

    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's avatar
JackLacava
Honored Contributor
2 years ago

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.

  • harijanakiram's avatar
    harijanakiram
    New Contributor II
    2 years ago

    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.