Saving and Displaying OLAP Reports and Graphs in Other Formats

WebFOCUS Online Help > Analyzing Data in an OLAP Report > Saving and Displaying OLAP Reports and Graphs in Other Formats

In this section:

Saving OLAP Reports and Graphs in the My Reports Folder

How to:

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

The following image shows a pop up menu listing the available formats to save and/or display.

PDF (Adobe Acrobat's Portable Document Format) is useful when you want a report or graph to maintain its presentation and layout regardless of a user's browser or printer type.
When you choose PDF format, the report appears in Adobe Acrobat Reader; 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. Two Excel formats are available:
- 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.
- 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.

In Managed Reporting:

A user can save the HTML output in his or her My Reports folder.
A developer can save the HTML output in the Other folder, where it can be distributed to users as a Standard Report. Developers can refer to the WebFOCUS Managed Reporting Developer's Manual for details on how to save a transformed report as a Standard Report.

Top of page

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

Open the Control Panel.
Click the Options button at the bottom of the window.
Select Display as a PDF Report.
The graph appears in the browser above the report, while a second browser opens and launches the report output in Adobe Acrobat as shown in the following image.

Tip: If you wish, you can save and print the PDF report from Adobe Acrobat.

Top of page

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

Open the Control Panel.
Click the Options button at the bottom of the window.
Select Save the data in an Excel file or Save the data in an Excel 2000 file.
Follow the instructions to export the data.

Top of page

Saving OLAP Reports and Graphs in the My Reports Folder

In Managed Reporting, you can save an OLAP report and graph in your My Reports folder.

Open the Control Panel.
Click the Options button at the bottom of the window.
Select Save as My Reports.
A secondary window opens.
Enter a descriptive name and click OK to save the graph(s) and the tabular report.

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

WebFOCUS⁷