IBM Support

PA on Cloud: Turbo Integrator syntax for Powershell script

Troubleshooting


Problem

How to execute a powershell script from within a turbo integrator process, specifically, on Planning Analytics on Cloud environment.

Resolving The Problem

A.  Create the powershell script and place it in the DATA directory of the tm1 server instance (model)
B.  Insert the ExecuteCommand in your TI.
Example #1:
          ExecuteCommand('Powershell .\nameofscript.ps1', 0);
 Example #2:      

         PowerCmd= 'powershell.exe .\nameofscript.ps1';

         ExecuteCommand(PowerCmd,1);

       

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 September 2021

UID

ibm10879371