Saving and Displaying OLAP Reports and Graphs in Other Formats

In this section:

Saving OLAP Reports and Graphs in the Private Content Folder

How to:

Display an OLAP Report and Graph in PDF Format
Save an OLAP Report and Graph as an Excel File
Display an OLAP Report and Graph as an HTML Active Technologies Report

OLAP reports and graphs appear in your browser in HTML format. You can display the report and corresponding graph in PDF, Excel, and active report formats, and in folders within the Repository path.

The following save and/or display options are available:

PDF is useful when you want a report or graph to maintain its presentation and layout regardless of a browser or printer type.
When you choose PDF format, the report appears in Adobe Acrobat Reader and the graph continues to appear above it in a browser window. If you print from Acrobat, only the report will be printed.
Excel is useful when you want to convert a large database to a spreadsheet or save a report and graph in a commonly used Office tool.
- Excel is a binary display format with limited formatting support. The computer on which the report is being displayed must have Microsoft Excel installed.
  Drill-downs of any kind are not supported.
- Excel 2000 supports most StyleSheet attributes, allowing for full report formatting. The computer on which the report is being displayed must have Microsoft Excel 2000 or higher installed.
  When you choose Excel 2000, the report and graph are displayed in the same tool where you can manipulate the data using Excel options. From Excel, you can print both the report and the graph.
  
  When you save in Excel 2000 format, only explicit drill-downs (based on parameters passed from the base report to the drill-down report) continue to work. Automatic drill downs on Dimensions and Measures are not supported in Excel.
Using an active report is useful when you want to create a self-contained HTML report that is designed for offline analysis. You can interact with the data, using analysis options similar to those found in an Excel workbook, without any connection to a server.

In the Repository path:

A user can save the HTML output in the private content folder.
A developer can save the HTML output in the workspace folders they are authorized to create content in and publish the content to users.

Procedure: How to Save an OLAP Report and Graph as an Excel File

Open the OLAP Control Panel.
Click Save at the bottom of the panel.
Select Save the data in an Excel file, Save the data in an Excel 2000 file, or Save the data in an Excel 2000 file with formulas.

Note: The Excel Save options are controlled by the TIBCO WebFOCUS® Client configuration OLAP settings. For more information, see the TIBCO WebFOCUS® Security and Administration manual.
Follow the instructions to export the data.

Saving OLAP Reports and Graphs in the Private Content Folder

In the Repository path, you can save an OLAP report and graph in your private content folder.

Open the OLAP Control Panel.
Click Save at the bottom of the panel.
Select Save as private content.
A secondary window opens.
Enter a descriptive name and click Ok to save the graph and the tabular report. If the workspace of the OLAP report is restricted not to allow the creation of private content, select a workspace from the Save in drop-down menu in the Save dialog box. If there are no workspaces listed, contact your administrator to obtain authorization to save private content to a workspace.

Note: There is no limit to the number of characters in the label legend of a graph, but long labels may appear truncated.

Saving and Displaying OLAP Reports and Graphs in Other Formats

Procedure: How to Display an OLAP Report and Graph in PDF Format

Procedure: How to Save an OLAP Report and Graph as an Excel File

Procedure: How to Display an OLAP Report and Graph as an HTML Active Technologies Report

Saving OLAP Reports and Graphs in the Private Content Folder