Data Visualization Jobs

Defines the connection profile for the job.

Rules:

• Characters: 1−30

• Case Sensitive: Yes

• Invalid Characters: Spaces

For more information about creating a local connection profile for this job, see Creating a connection profile.

Defines the path and name of the job that you want to run.

Rules:

• Characters: 1-4096 characters
• Case sensitive: Yes

Variable Name: %%JOBNAME

Defines the path and name of the job that you want to run in a readable format.

Rules:

• Characters: 1-4096
• Case sensitive: Yes

Variable Name: %%COGNOS-LOCATION

Defines the type of job, which can be job, report, or reportView.

Rule: Case sensitive

Variable Name: %%COGNOS-TYPE

Determines the values of the IBM Cognos prompt in the selected report or reportView as follows:

• Name: Indicates the name of the prompt

  Variable Name: %%COGNOS-REPORT_PARAMS-P001-PRM_NAME

• Type: Indicates the type of prompt

  Variable Name: %%COGNOS-TYPE

• Multi:

• Required: 

• Range: 

• Value: 

• Description: 

Defines if the report is run as a burst report.

Variable Name: %%COGNOS-BURST_REPORT

Defines what Control-M does with the IBM Cognos job output.

Determines the report output format in one or more of the following options:

• CSV
• HTML
• MHT
• PDF
• SingleXLS
• spreadsheetML
• XHTML
• XLS
• XLWA
• XML

Determines whether the report is saved to the Cognos server or as a report view, as follows:

• To Cognos Server: Saves the report at the default location on the Cognos server.

  Variable Name: %%COGNOS-DEST-SAVE_REPORT-SERVER

• As Report View: Saves the report as a report view with the name and location that you define.

  Variable Name: %%COGNOS-DEST-SAVE_REPORT-VIEW

Defines the report view name when As Report View is selected.

Rule: Case sensitive.

Variable Name: %%COGNOS-DEST-SAVE_REPORT-VIEW_NAME

Defines the report archive system file location.

Variable Name: %%COGNOS-DEST-FILE-DIR

Determines the file name, with options as follows:

• Use the report name: 

• Specify a file name: Names the file as you define. If the file name is empty, the default report name is used.

  Variable Name: %%COGNOS-DEST-FILE-NAME

Determines which connection profile to use to connect to the Power BI endpoint.

Determines one of the following options for execution in Power BI:

• Dataset Refresh

• Pipeline Deployment

(For Dataset) Defines a Power BI workspace where you want to refresh data.

(For Dataset) Defines the ID for the specified Power BI workspace (defined in Group Name).

Defines a Power BI data set that you want to refresh under the specified workspace.

(For Dataset) Defines specific parameters to pass when the job runs, defined as JSON pairs of parameter name and value.

For more information about available parameters, see Datasets - Refresh Dataset in the Microsoft Power BI documentation.

To specify parameters, the dataset must be in Premium group.

Format: {"param1":"value1", "param2":"value2"}

For no parameters, specify {}

{
  "type":"Defragment",
  "commitMode":"transactional",
  "maxParallelism":20,
  "retryCount":2,
  "objects":[
      {"table":"Contributions"},
      {"table":"Traffic_Popular"}
    ]
}

(Optional) Determines the maximum number of seconds to wait for REST API requests to respond, before disconnecting.

Default: 10

(Optional) Determines the number of seconds to wait before checking the status of the job.

Default: 10

Defines the connection profile for the job.

Rules:

• Characters: 1−30

• Case Sensitive: Yes

• Invalid Characters: Spaces

Determines one of the following options to load data into the environment:

• Full: Deletes all the tables in the current environment and reloads the data from the data sources.

• Partial: Keeps the tables in the current environment and executes the Load and Select statements, preceded by an Add, Merge, or Replace prefix.

Defines the Qlik Sense app name, which contains one or more workspaces, called sheets.

Determines whether the job logs are included in the Control-M output.

Determines the number of seconds to wait before checking the status of the job.

Default: 10