Jan 5, 2022
VBA functions in Slice
Slice supports the following TM1 VBA functions:
-
TM1RECALC1 – Recalc active worksheet
-
TM1REFRESH – Rebuild active worksheet
-
TM1REBUILDALL – Rebuild all worksheet in a workbook
-
DBSSEND – Send DBS in active worksheet
-
DBSSENDALL – Send DBS in active workbook
-
N_CONNECT – Connects to a TM1 instance
- RunTIProcess(serverName,parameterValues…) – Execute TI processes from VBA or worksheets
The functions can be executed in VBA using Application.Run:
Sub RecalcWorkbook() Application.Run "TM1RECALC1" End Sub