New to TM1. Attempting to replace DBSW formulas with VBA loop to send values back to TM1. However, VBA loop is much slower than TM1 formulas, likely because the VBA cannot batch the DBSW.
For x = 1 to 250000
var_value = Run("DBSW", var_input(x), ...)
Next x
What options are there to batch the DBSW?
Can W_DBSENABLE be applied?
Examples are appreciated.
For x = 1 to 250000
var_value = Run("DBSW", var_input(x), ...)
Next x
What options are there to batch the DBSW?
Can W_DBSENABLE be applied?
Examples are appreciated.