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 Hyperion Interactive Reporting Studio)
Email Section—Dashboard, Report, Results, Chart, Pivot, and OLAPQuery
Email Document—Entire Interactive Reporting file
Note:
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 actions list, select a value and click Go.
Table 81. Export Action Options
Option
Description
Section
Section to be saved, printed, mailed, or exported.
Filename
Export file name (no extension)
Format
Export file format:
Microsoft Office Web Archive (*.mhtml)
Excel (*.xls)
HTML (*.htm)
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 action type.
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.)
Output Directory
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 exported file
Save in Output Sets the type of output saved with the Interactive Reporting document. The output types include the Results section and computed items. Use the Include drop-down to view and select the output type. Available options include: Inherit from BQY—The output saved with the document is determined when the Interactive Reporting document (BQY) was created.
Results and Computed Item—Saves the Results set and computed items. Saving results with your query allows you to analyze and generate reports without being connected to the database. Results are saved for an individual query or for multiple queries for which results have been generated. Having your results set makes sense if you cannot connect to a database, for example, when traveling or working remotely, or if you are scheduling or forwarding documents for someone else’s use.
Computed values are recalculated when the document is opened and the query is reprocessed. If the corresponding Results section contains a large number of column items which use complex formulas in their definitions, the document make take a while to open.
Results and No Computed Items—Saves the Results section, but not computed items. This is especially useful when you need to view a Results set, but do not need to show and recalculate computed items.
No Results—Saves computed items, but not the Results section with the document. To automatically recalculate the values of computed columns when a document is opened, do not select the corresponding Results section. The document may take longer to open, especially if the Results set contains a large number of computed columns or uses complex formulas in the definitions, since all computed values are recalculated in the Results section and in any other section that references the Results section.
Compress
For saving the job file in Interactive Reporting, compressed-file format.
Message Enter the message text to send with the email Attach File Select to include the scheduled file in an email message Save in File
Sets the type of output saved with the Interactive Reporting document attached in the email. The output types include the Results section and computed items. Use the Include drop-down to view and select the output type. Available options include: Inherit from BQY—The output saved with the document is determined when the Interactive Reporting document (BQY) was created.
Results and Computed Item—Saves the Results set and computed items. Saving results with your query allows you to analyze and generate reports without being connected to the database. Results are saved for an individual query or for multiple queries for which results have been generated. Having your results set makes sense if you cannot connect to a database, for example, when traveling or working remotely, or if you are scheduling or forwarding documents for someone else’s use.
Computed values are recalculated when the document is opened and the query is reprocessed. If the corresponding Results section contains a large number of column items which use complex formulas in their definitions, the document make take a while to open.
Results and No Computed Items—Saves the Results section, but not computed items. This is especially useful when you need to view a Results set, but do not need to show and recalculate computed items.
No Results—Saves computed items, but not the Results section with the document. To automatically recalculate the values of computed columns when a document is opened, do not select the corresponding Results section. The document may take longer to open, especially if the Results set contains a large number of computed columns or uses complex formulas in the definitions, since all computed values are recalculated in the Results section and in any other section that references the Results section.
Compress
For sending the saved job file in Interactive Reporting compressed-file format.