To set process options for a multiple-cycle, Interactive Reporting job:
From the Explorer module, right-click the job and select Run Job.
Click Go to add another cycle to this job.
Click Process Options (+) to display all process options.
Table 125 5
Save job output with the job
For storing the job output in the folder containing the job
Save job output in another folder
For specifying an output folder
Process results to Interactive Reporting file
For processing queries to the Interactive Reporting file
Process results to database table
For creating a database table to store the data set. (Items
on the Request line become the column headings. You can
append columns to the table and query it. You need Create
and Insert privileges on the database to process to a
For selecting the query to process to a database table.
For entering the name of the table that you are creating or
to which you are appending columns (See your database
administrator if you want to use a new table.)
Create a table for each run, appending date to table
For creating a table for each job run and appending the
date to its name
Delete and recreate table for each job run
For deleting the old table and creates a table for each job
run (Runs use the same table name.)
Create table on initial run, and then append data to
For creating a table on the initial run and adding data to
Grant access to:
For entering additional usernames (separated by commas)
(You need Grant privileges to use this field. If Grant Access
to is not selected, the table is granted only to your user
Action Options for Multiple-Cycle Jobs
The action is the output method. The options on the actions page vary depending on the action.
Actions and items to which they apply:
Export—Dashboard, Report, Results, Chart, Pivot, OLAPQuery, and an entire document
as a web page
Save Document—Entire Interactive Reporting file
Print—Dashboard, Report, Results, Chart, Pivot, and OLAPQuery (Available if the
administrator defined a printer for Oracle's Hyperion® Interactive Reporting Studio)
Job Parameter Options s 413
Import Document—Dashboard, Report, Results, Chart, Pivot, OLAPQuery, and an entire
document as a web page.
E-mail Section—Dashboard, Report, Results, Chart, Pivot, and OLAPQuery
E-mail Document—Entire Interactive Reporting file
A cycle can have only one Save As Job Output action. It can have multiple save actions but
can be saved as a file on only some output folders.
To set action options for a multiple-cycle, Interactive Reporting job:
From the Explorer module, right-click the job, and select Run Job.
Click Go to add another cycle to this job.
From the actions list, select a value and click Go.
Table 126 6 Export Action Options
Section to be saved, printed, mailed, or exported.
Export file name (no extension)
Export file format:
Microsoft Office Web Archive (*.mhtml)
Lotus 1-2-3 (*.wks)
Text (Tab Delimited)(*.txt)
Text (Comma Delimited)(*.csv)
Adobe Acrobat (*.pdf)
Graphics file (*.jpg)
Note: The choices depend on the export section type and text port
Export as job output
For exporting the section to the current job folder in the repository. (The
filename is not used with this option.)
Save as job output
For saving the section to the current job folder in the repository. (The file
name is not used with this option.)
The directory for saving the export file or Interactive Reporting document
Append Unique Identifier to Filename
For appending the job ID# and report cycle name to the saved document
or export file; ensures that the file is recognizable if similar files are saved
to one directory.
Append Date to Filename
For appending the date (year, month, and day) to the saved document or
414 Using Interactive Reporting Jobs
Save Results with Document
For saving Results section contents with the document
Save Computed Values with Document
For saving the computed values with the document.
Save in Compressed Format
For saving the job file in Interactive Reporting, compressed-file format.
For including the scheduled file in an e-mail message
For including Results section contents with the e-mailed document
Send Computed Values
For including computed values with the e-mailed document.
For sending the saved job file in Interactive Reporting compressed-file
Enter e-mail message text.
Example: Importing and Scheduling a Job
This example illustrates importing and scheduling of an Oracle's Hyperion® Interactive
Reporting – System 9 job. In this example, you import and schedule
to run once
Navigate to the folder to which to import the job.
Select File > Import > File as Job.
In File, click Browse to search for the file sample1.bqy. Click Next.
For Query, on Connecting to Data Sources, under Connection, select Sample for the Query/
DataModel name called SalesQuery, and click Next.
For Interactive Reporting Job Properties, select Users running this job can define their own cycles and
actions, and click Next.
For Job Defaults, set General Properties and Locale and click Next.
On Advanced Options, click Edit Permissions to open permissions access.
Give the World group access to sample1.bqy.
Under Available Users, Groups, and Roles, click Update List.
From Available Users, Groups, and Roles, select a user and click
Under Selected Users, Groups, and Roles, select the user and click Edit.
On Permissions, select the access permissions level for the job and the job output, and set
the adaptive state.
Access to file—Full Control
Adaptive state—View only
Example: Importing and Scheduling a Job b 415
VB.NET PDF - Convert PDF with VB.NET WPF PDF Viewer
Convert PDF to image file formats with high quality, support converting PDF to PNG, JPG, BMP and GIF. VB.NET WPF PDF Viewer: Convert and Export PDF. convert multiple page pdf to jpg; best convert pdf to jpg
Permissions is displayed.
Click Finish and Schedule.
On General Properties, in Name, enter Quarterly, and click Next.
On Job Parameters, click Next.
On Cycles, by Add another cycle to this job, click Go.
Define a cycle:
Under Define Cycle, in Cycle Name, enter
Under Add a(n) (blank) Action to this Cycle, select Email Document, and click Go.
On Add/Modify Action: Email Document, in To, enter your email address.
Select Send File and/or Send Results, and click OK.
On Define Cycle, click OK.
On Cycles, select Save Job Parameter Name, select Personal from the drop-down list, enter a name in the
box, and click Next.
On Time Events, select Define when to run this job starting with, and select A New Recurring Time
Event, and click Next.
On Define Event:
In Name, enter a name.
In Days to Run, select By Quarter.
Under Notification, select Display notification in Schedule Module, and click Finish.
The job is now scheduled to run.
416 Using Interactive Reporting Jobs
Using SQR Production
Reporting and Generic Jobs
In This Chapter
Prerequisites for Importing Jobs
Generic Job Properties
Modifying SQR Production Reporting and Generic Job Properties...........................................................429
Setting SQR Production Reporting and Generic Job Parameters............................................................429
Output Options for Scheduling Jobs4
Working with Secure SQR Production Reporting Jobs........................................................................431
Supporting Exceptions in SQR Production Reporting or Generic Programs.................................................433
Setting Priority on Output Programmatically4
SQR Production Reporting jobs are created with Oracle's Hyperion® SQR® Production
Reporting Studio. Generic jobs are created using applications with a command-line SQR
Production Reporting interface. You can use the Explore and Schedule modules to import, run,
and schedule SQR Production Reporting and generic jobs. You also use properties and
parameters to further define SQR Production Reporting and generic job options.
This chapter explains the properties specific to SQR Production Reporting jobs, generic jobs,
and SQR Production Reporting documents (SQR Production Reporting job output).
For basic importing procedures, see Chapter 4, “Importing Artifacts.” For basic job execution
and scheduling procedures, see Chapter 13, “Scheduling Jobs and Batches.”
Prerequisites for Importing Jobs
Information needed for importing a SQR Production Reporting job:
Database connectivity, database type, and SQR Production Reporting version needed to run
the SQR Production Reporting program that you are adding (select from the list); for
example, Marketing SQR Production Reporting v. 9
Files that the SQR Production Reporting program references:
Include files (#INCLUDE commands)
Input data files (open
Image files (print-image and declare-image commands)
Compile-time parameters (ASK commands) and runtime parameters (INPUT commands).
For secure SQR Production Reporting jobs, the security organization of the program: which
users have access to which data and how the output is (divided) (bursted).
The properties explained in the following topics pertain only to SQR Production Reporting and
generic jobs. Properties that do not apply to generic jobs are noted. See “Generic Job Properties”
on page 427 for properties unique to generic jobs.
SQR Production Reporting jobs have these properties:
Connectivity and run options
SQR Production Reporting and generic jobs and other items, such as BQY jobs share many
general properties and advanced options. See “Working with Properties” on page 117.
To access properties:
From the Explorer module, select a Production Reporting job.
Select File > Properties.
Click General. See “General Properties” on page 117.
Click Advanced. See “Advanced Properties” on page 118.
Click Production Report to review Production Reporting properties:
Click Required Files. See “Required Files” on page 420.
Click Connect. See “Connection and Run Options” on page 420.
Click Parameters. See “Parameters” on page 422.
Click Output Options. See “Job Output” on page 425.
Click Advanced. See “Advanced SQR Production Reporting Options” on page 422.
Dependency Analysis Commands
When importing SQR Production Reporting job, the system can analyze your SQR Production
Reporting program for dependencies. The analysis occurs if you request the system to scan for
418 Using SQR Production Reporting and Generic Jobs
required files and INPUT and ASK parameters. Analysis can be time-consuming if your SQR
Production Reporting program is large.
The system examines these commands in your SQR Production Reporting program:
INCLUDE—Includes an external source file in the SQR Production Reporting report
specification; for example, a SQR Production Reporting code file,
when it compiles
OPEN—Opens an operating system file for reading or writing; for example, an OPEN
statement that opens a file for sequential reading the data in the file, which is identified to
the program as 1:
open 'stocks.dat'as 1 for-reading record=100
DECLARE-IMAGE—Declares the type, size, and source of an image to be printed; for
declare-image control flow
type = eps-file
source = 'controlf.eps'
image-size = (321, 309)
PRINT-IMAGE—Prints an image in any report section (As with the declare-image
command, the print-image command accepts type, size, and source arguments.)
ASK—Retrieves a compile-time substitution variable (Retrieval can be by user input,
command-line arguments, or entries in the @file on the command line.)
INPUT—Retrieves a runtime variable (Retrieval can receive by user input, command-line
arguments, or entries in the
on the command line.)
PRINT URL=”...”—Prints the file found at the URL location, usually an image file (The file
is listed with the required files for the job.)
SECURE—Retrieves the secure tag
The Security Tags Included property, which is read-only, indicates whether the job is secure.
Secure jobs can have only HTML output. All other advanced options are explained in “Working
with Properties” on page 117.
Connectivity and Run Options
These topics describe all data source connection properties and run properties for SQR
Production Reporting jobs:
Connection and Run Options
Advanced SQR Production Reporting Options
Job Properties s 419
Connection and Run Options
Use these options, which apply only to SQR Production Reporting jobs, to configure or change
the database connections and the SQR Production Reporting engine for the job.
Data Source and Production Reporting Engine
For selecting a data source and a SQR Production
If the data source or engine that you need is not available,
see your administrator.
Use Job Service connectivity for this data source—For
using the default username and password
Prompt for username/password—For prompting users
to enter IDs and passwords at runtime
Use the username/password specified below—For
setting the username and password now on import
Allow pass-through where end user’s authentication
system is enabled for it
For enabling users to access data sources without
When importing a file or job, you can identify and locate required files by scanning the SQR
Production Reporting program, or you can manually enter the required files.
Scanning the SQR Production Reporting program to locate required files is possible only during
the import process.
As you identify and locate required files, they are added to the required files screen. For generic
jobs, you must manually enter required files.
Files that can be associated with a job or SQR Production Reporting document and required for
For SQR Production Reporting jobs, Include, Data, Image files, and INI file
For generic jobs, associated files used for running the job
SQR Production Reporting documents and associated files used in viewing the document
This chapter concentrates on required files managed through a listing interface, namely files for
SQR Production Reporting and generic jobs and SQR Production Reporting documents. The
INI file and the custom-form required files are managed through another interface.
Scan for required files before manually entering required files, because the scanned results
replace the required files list. If duplicate required files are listed, you must delete the extra files.
420 Using SQR Production Reporting and Generic Jobs
Documents you may be interested
Documents you may be interested