Skip to main content
Newcomer
Oct 4, 2023 3:24 AM UTC

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?

1 reply

Employee - Sage
Oct 5, 2023 9:34 AM UTC

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).