Data in a spreadsheet, chart, or pinboard can now be exported unformatted to Excel, Clipboard or to a file. To access this, right click a report object and select Export Data, then Unformatted.
When exporting data to Excel using the Unformatted option (Export Data, then Unformatted, then To Microsoft Excel), filter dimensions with members selected are included in the Excel output. For example, if a Web Analysis document against Essbase Sample Basic has the Scenario dimension in the filter, and the member Budget is selected, the Budget member appears in the Excel output above the column headers.
Note: | This feature does not apply to the Query-Ready or Formatted export types. |