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) y...
Excel Add In
JackLacava's avatar
JackLacava
Community Manager
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).