Skip to main content
R
rpc2023
Newcomer
October 4, 2023

Multi year calculation for cube views connected via excel add in

  • October 4, 2023
  • 1 reply
  • 0 views

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

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
October 5, 2023

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

Terms & ConditionsAccessibility statement