TM1 Forum

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.

Pretty sure you can't do this via VBA.

If you have the skills to write VBA then you are likely better off putting the data into a csv (programmatically) and then triggering a TI to load the data (programmatically).