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
Type | Format | Export Option | Comment |
---|---|---|---|
Microsoft Excel | Fully Formatted | Selected Object | Formatted HTML, current page of selected data object. |
All Objects | Formatted 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 Ready | Selected Object | Data 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. | |
Unformatted | Selected Object | Unformatted HTML; current page of selected data object. | |
ALl Objects | Unformatted HTML; current pages of all data object in a report. | ||
Microsoft Word | Image | Selected Object | Image; 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. |
Screen | Image; screen shot of the report. | ||
Microsoft PowerPoint | Image | Select Object | Image; current page of selected data object. |
Screen | Image; screen shot of the report. | ||
File | Image | Selected Object | |
Screen | |||
Fully Formatted | Selected Object | ||
Unformatted | Selected Objects | ||
All Objects | |||
Clipboard | Fully Formatted | Select Object | |
Unformatted | Selected Object |