Macro commands for the system
Command | Parameters | Description | Examples |
---|---|---|---|
AbortCyclePeriod | Cycle, [Cycle Period], Reason, [Time out] | Aborts the selected cycle period. Changes the status of the cycle period from Pending, or Running, to Aborted. When you execute this command, any running workflows for the cycle period or scenario are aborted. The status of the selected cycle period must be Pending or Running. |
|
ArchiveCyclePeriod | Cycle, [Cycle Period], [Time out] | Archives the specified cycle period and sets the status of the cycle period to Archived. The status of the selected cycle period must be, Completed. |
|
CompleteCyclePeriod | Cycle, [Cycle Period], [Scenario to Publish], [Time out] | Completes the selected cycle period. Changes the status of the selected cycle period from Running to Completed and sets the status of the scenario to Published. The status of the selected cycle period must be Running. |
|
RestoreCyclePeriod | Cycle, [Cycle Period], [Time out] | Restores the specified cycle period. The status of the selected cycle period must be, Archived. |
|
PauseCyclePeriod | Cycle, [Cycle Period], [Time out] | Pauses the selected cycle period. Changes the status of the cycle period from, Running to Paused. The status of the selected cycle period must be Running. |
|
ResumeCyclePeriod | Cycle, [Cycle Period], [Refresh], [Current Planning Bucket], [Time out] | Resumes the selected cycle period. Changes the status of the selected cycle period from, Paused to Running. The status of the selected cycle period must be Paused. |
|
StartCyclePeriod | Cycle, [Cycle Period], [Current Planning Period, [Time out] ] | Starts the cycle period for the current/ selected cycle. Changes the status of the cycle from Pending to Running. The status of the selected cycle period must be Pending. |
|
RunCodeListInterfaceService | Interface Service Name, Direction, [Reject all on error], [Time out]
|
Run an interface service that imports or exports the code list elements. |
|
CreateCyclePeriod | Cycle, [Cycle Period], [Cycle Period Label], [Previous Period], [Time out] | Creates a new cycle period for the current cycle. |
|
RunCommand | Data Source, Command text, [Time out] | Run a command for a data source. This command is similar to RunSQL, but also supports ITK commands on the system level that are not specific to the context of a scenario. |
|
RunSQL | Data Source, SQL Command, [Time out] | Run an SQL command for the data source of a database. |
|
SaveDiscardScenarios | Cycle, [Cycle Period], [Module], [Scenario], [Discard], [Time out] | Save or Discard a single scenario, or Save or Discard all the scenarios for a module or a cycle period. This is defined as a system macro as the completion of processes and an update of the status is required, before the additional commands are executed. This is used to unlock the scenarios of a specific cycle period. |
|
EditShareScenario | Cycle, [Cycle Period], [Module], [Scenario], [Share], [Users], [Roles], [Time out] | Edit and/or Share scenario or Edit and/or Share, all scenarios for a module or cycle period to all account managers. This is defined as a system macro and requires completion of the process, an update of the status, and availability before executing the additional commands. |
|
RunCyclePeriodMacro | Macro, Cycle, [Cycle Period], [Time out] | Run a Cycle Period Macro, passing the Cycle and Cycle Period. | RunCyclePeriodMacro("CreateUpsideScenario","Normal","Nov 12","") |
RunScenarioMacro | Macro, Cycle, [Cycle Period], Module, Scenario, [Time out] | Run a Scenario macro, passing the macro name and Cycle,
[Cycle Period], Module and Scenario names. When you run this macro, you
can also transfer context variables for the worksheet data, using these
parameters:
|
RunScenarioMacro("InitFinanceScenario","Normal","","Finance","Baseline","") . |
RunSCV | Job, [Log level], [Parameters] | Run a job in Supply Chain Vault (SCV) passing Job, logging level and parameters details. Parameters can be named or ordered |
RunSCV("Import from M3","","Base") Run an "Import from M3" SCV job to execute commands for the import of data from M3 to SCV and transfer data to the core table, with the default logging and a single "Base" parameter: RunSCV("Import from M3","","Base"). Examples of SCV commands:
RunSCV(job:"Export to M3",logLevel:"Debug",profile:"Base") Run an "Export to M3" SCV job to execute commands to transfer data from SCV to the outbox, before exporting data to M3. The log level of the job is set to Debug; and a single parameter, profile, with the value "Base" is transferred to the job: RunSCV(job:"Export to M3",logLevel:"Debug",profile:"Base"). Examples:
RunSCV("Update statistcs from M3","Info","Base","Transactional") Run an "Update statistics from M3" SCV job to execute commands to import transactional data from M3 to SCV. Data is transferred to the core table, with log level set to Info, and two parameters: "Base" and "Transactional" are transferred to the job: RunSCV("Update statistcs from M3","Info","Base","Transactional"). Examples:
|
RunSystemMacro | Macro | Call a System Macro from the current system macro | Run the system macro S+ Initialize Engine from another macro:
|