Exporting Data Options

You can export spreadsheets, charts or pinboards to Microsoft Excel, Word and PowerPoint. The following table describes the Export Data right-click menu.

Table 2.  Export Data Options

TypeFormatExport OptionComment
Microsoft ExcelFully FormattedSelected ObjectFormatted HTML, current page of selected data object.
  All ObjectsFormatted HTML, current pages of all data objects in a report (all in one worksheet; it is not possible to split object to separate worksheets).
 Query ReadySelected ObjectData object on Essbase data source; re-queries Essbase server from MS Excel, if selected data object based on Essbase data source and exports data object in Query-Ready HTML.

Note:

Query Ready format supports one object per worksheet in Smart View. Therefore, “All Objects” is not available for Query Ready exports.

 UnformattedSelected ObjectUnformatted HTML; current page of selected data object.
  ALl ObjectsUnformatted HTML; current pages of all data object in a report.
Microsoft WordImageSelected ObjectImage; current page of selected data object.

Note:

Image format supports one image per page in Microsoft Word and PowerPoint. Therefore, “All Objects” is not available for Image exports.

  ScreenImage; screen shot of the report.
Microsoft PowerPointImageSelect ObjectImage; current page of selected data object.
  ScreenImage; screen shot of the report.
FileImageSelected Object 
  Screen 
 Fully FormattedSelected Object 
 UnformattedSelected Objects 
  All Objects 
ClipboardFully FormattedSelect Object 
 UnformattedSelected Object