Forum Discussion

rpc2023's avatar
rpc2023
New Contributor
2 years ago

Multi year calculation for cube views connected via excel add in

When end users utilize the excel add in functionality, they are only able to calculate 1 year at a time using the calculate button. 

Is there a solution to allow users to calculate all (multiple) years shown on the cube view with a click of 1 button in the excel add in?

Excel Add In
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    You could write an Excel matro that uses a REST Api call to kick off a Data Management task (which accepts a Time filter you'd set as Parameter).