Export (Method)

Applies To:

ChartSection object, (CubeQuery) QuerySection object, DataModelSection object, Document object, DashboardSection object, OLAPQuerySection object, PivotSection object, QuerySection object, ResultsSection object, Section object, TableSection object, ReportSection object

Description:

Creates a file with the information from a section object. Files can be created using the standard data formats from the BqExportFileFormat constant group.

Note:

For UNIX users of the Export and ExportToStream methods, Interactive Reporting references the umask command of the user running the Interactive Reporting Service to determine the three-digit octal code. This code defines the read-write-execute permissions to be turned off. Typically, umask is used in .login or .profile and in the Bourne and C shells. It is a built-in command.

Note:

The use of the Export (Method) or ExportToStream (Method) does not display a prompt dialog in the EPM Workspace or Jobs/Scheduler.

Note:

You cannot export Report sections using the Excel 2007 format (*.xlsx).

Syntax:

Expression.Export(Filename As String, [optional] FileFormat As BqExportFileFormat, [optional]IncludeHeaders As Boolean], [optional] Boolean Prompt), [optional] BqEncoding Encoding)

Expression Required:

An expression that returns an object for any of these sections:

Constants:

The BqExportFileFormat constant group consists of these values:

The BqEncoding constant group values include:

For information on exporting an Interactive Reporting document file to HTML format statically, see HTMLExportBreakRowCount (Property) and HTMLVerticalPageBreakUnits (Property) in the Oracle Hyperion Interactive Reporting Object Model and Dashboard Development Services Developer's Guide, Volume IV: Object Model Guide to Properties and Constants.

For information on exporting an Interactive Reporting document file to the HTML format dynamically (EPM Workspace), see DHTMLExportBreakRowCount (Property), and DHTMLVerticalPageBreakUnits (Property) in the Oracle Hyperion Interactive Reporting Object Model and Dashboard Development Services Developer's Guide, Volume IV: Object Model Guide to Properties and Constants.

Example:

This example shows how to export a Results section to HTML. The first part of the script creates a computed column that displays the contents of the URL columns as HTML HREFs:

//Call the JavaScript link() method to convert the string to HREFs
var ComputedExpression = "URL.link()"
ActiveDocument.Sections["Results"].Columns.AddComputed("Clickable URLS",ComputedExpression)
ActiveDocument.Sections["Results"].Export("C:\\HTML\\MyResults.htm", bqExportFormatHTML,false)