Jan 5, 2022

    VBA functions in Slice

    Slice supports the following TM1 VBA functions:

    1. TM1RECALC1 – Recalc active worksheet

    2. TM1REFRESH – Rebuild active worksheet

    3. TM1REBUILDALL – Rebuild all worksheet in a workbook

    4. DBSSEND – Send DBS in active worksheet

    5. DBSSENDALL – Send DBS in active workbook

    6. N_CONNECT – Connects to a TM1 instance

    7. 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

    Related content

    Loading related content