HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Performing On-Report Analysis with Web Intelligence 249
The document is saved in InfoView.
Saving documents as Excel, PDF, or CSV files
You can save Web Intelligence documents in the following file formats:
• Microsoft Excel spreadsheets
• Adobe Acrobat PDF files
• Comma Separated Values (CSV) files
Saving Web Intelligence documents as Excel Spreadsheets
Creating a copy of your documents as a Microsoft Excel file is especially useful if you want
to combine the information in your Web Intelligence document with other data in an Excel
spreadsheet.
Unlike Web Intelligence documents, the Excel files are not connected to the database. This
means you cannot refresh the data in the Excel file. To display up-to-date data in Excel
format, refresh the Web Intelligence document and then save it as a new Excel file.
Note: When you name reports in a document that you want to save as an Excel
spreadsheet, the names of reports must not include more than 31 characters or include
spaces or the following special characters: * : \ / [ ]
Note: Dates prior to 1900 do not display correctly in Excel.
To save a Web Intelligence document as an Excel spreadsheet
1. With the document open, click Document, on the toolbar above the displayed report.
2. Select Save to my computer as>Excel.
The File Download dialog box appears.
3. Type a file name or accept the default name displayed.
4. Select Save this file to disk, and then click OK.
5. Select a file location on your computer, then click Save.
Web Intelligence saves a copy of your document in Microsoft Excel format to the
location you specified on your computer. Each report within the Web Intelligence
document converts to a separate Excel worksheet within the Excel file.
NOTE: Some Web Intelligence chart formats do not exist in Excel. These charts
are automatically converted to the closest corresponding chart format available in
Excel.