Search found 1 match
- Thu Aug 24, 2017 11:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 DBSW loop in VBA
- Replies: 1
- Views: 1775
TM1 DBSW loop in VBA
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 ...