Command options

Use the options in the Command tab to specify how Analytics executes commands.

Autoexecute Commands

If you turn this option on, Analytics immediately executes certain commands using the selected field in the view as input. You cannot edit the command or apply a local filter. The option applies only to some command, and the selected input field must be the data type required by the command.

Automatic Output Filenames

If you turn this option on, Analytics auto-generates names for command output files. The auto-generated name contains the command name and an incremental number starting at 01. You can accept the name, or specify a more meaningful name.

Use Output Table

If you turn this option on, the Use Output Table checkbox, located in command dialog boxes that create tables, is selected by default. When the checkbox is selected and you execute a command, Analytics automatically closes the active table and opens the table created by the command. If you do not want the output table to open, you can deselect the checkbox before running a command.

Show Group Tests in Log

When you run a script, this option affects the display of group results as they appear in the command log. Analytics displays the group results of If, While, For, and Next tests beside the commands to which they apply. Because more than one test in a group can apply to each command, the syntax can get very long.

If you turn this option off, Analytics does not display the tests when a script is run.

Changes to this setting are recorded in the log using the following syntax:

SET TEST {ON|OFF}

Suppress XML Output for Command Results

When this option is selected, command output to screen appears as plain text rather than formatted text.

Changes to this setting are recorded in the log using the following syntax:

SET SUPPRESSXML {ON|OFF}

Return Matches for Null Fields

This option controls how Analytics interprets null character values. A character value is “null” when it is empty and contains no data. For example, NAME="" is an expression with a null character value: there is nothing between the quotation marks.

When this option is selected, Analytics interprets a null as a wildcard. For example, the view filter NAME = "" displays records with any value in the NAME field.

When this option is not selected, Analytics interprets a null literally as a null. For example, the view filter NAME = "" displays only records with no data in the NAME field.

Intervals

This option indicates the number of intervals chosen by default for a stratification or histogram. Enter a number from 1 to 255. The default is 10.

Error Limit

This option sets the default number of errors after which Analytics stops processing the Sequence or Verify commands. Enter a number from 1 to 255. The default is 10.

Retry Command Attempts

Note

Applies to Analytics scripts only. Does not apply to the Analytics user interface.

Specifies the number of times Analytics attempts to import or export data if the initial attempt is unsuccessful. Enter a number from 0 to 255. If you enter 0, no additional attempts are made after an initial failure. The default is 0.

There is no waiting period between retry attempts. Each successive attempt is made immediately after a preceding failure.

The ability to specify retry attempts is useful when connecting to databases or cloud data services, which can be temporarily unavailable.

Changes to this setting are recorded in the log using the following syntax:

SET RETRY num

Applies to the following commands:

Import
  • ACCESSDATA
  • IMPORT GRCPROJECT
  • IMPORT GRCRESULTS
  • REFRESH

    (for tables initially created using ACCESSDATA or IMPORT SAP only)

SAP (Direct Link)
  • IMPORT SAP
  • RETRIEVE
Export
  • EXPORT . . . ACLGRC

    (export to HighBond Results)

Maximum Categories

This option specifies the maximum number of unique values that can occur in a character key field used as input for the Train command. Enter a number from 1 to 255.

Notify Settings

Retry Attempts

This option specifies the number of times the Notify operation will attempt to send an email if the initial attempt is unsuccessful. Enter a number from 0 to 255. If you enter 0, no additional attempts are made after an initial failure. The default is 5.

One possible reason for the Notify operation failing to send an email is that the email server is unavailable.

Retry Interval (seconds)

This option specifies the amount of time in seconds between additional attempts to send an email after an initial failure. Enter a number from 1 to 255. The default is 10 seconds.

Stop Script if Notify Fails

If you turn this option on, Analytics stops processing a script if the Notify operation fails. The script stops after the initial failure, or after the specified number of Retry Attempts, if none of the attempts are successful. The default setting is off, which allows a script to continue even if a Notify operation fails.

An invalid email recipient is not considered a failure of the Notify operation and does not cause a script to stop regardless of how Stop Script if Notify Fails is set.