Advanced Production Reporting Options

Advanced Production Reporting options apply only to Production Reporting jobs. For more information on command-line flags and the SQR.ini file, see Oracle Hyperion SQR Production Reporting Developer's Guide Volume 2: Language Reference.

Advanced OptionsDescription

Compile

Compile the program

Benefits:

  • Save time later when running the job

  • Validate SQL ASK parameters

  • Check program validity

Command-line flags for Job Execution

Optional command-line flags

Some flags can be over-ridden by job-output option formats and demand-paging options, for example, -burst and -printer.XX where XX is a format type.

This command-line flag option is unavailable: -EH_CSVONLY.

The system accepts 250 characters on the command line.

Use SQR.ini from File System on Job Factory Host

Use the SQR.ini file location

Custom SQR.ini

Path to a custom SQR.ini file

Browse for the file locally or in the repository.

  • Add File from my PC—Select a local file.

  • Add File from the Repository—Select a file from the database.

Enable search indexingAllows keywords generation during job execution. This is in support of searching for Production Reporting jobs.
Persist foreground job output in repository when running this jobStores output in the repository.
Allow Job Runners the option to change the persistence optionWhen this is selected, Persist foreground job output when running this job is available to users when running the job in real time.