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.
TM1 DBSW loop in VBA
- Steve Rowe
- Site Admin
- Posts: 2417
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: TM1 DBSW loop in VBA
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).
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).
Technical Director
www.infocat.co.uk
www.infocat.co.uk