Export Data

In data analyzer you have different options to export data from your table. With the export options all data in the table at the time of the export are exported.

To start the export of your table's data, choose (Export) in the data analyzer toolbar and select one of the export options:

  • Export Excel...

  • Export PDF...

  • Export CSV...

You find the export files in the download area of your local PC.

Export Data as Microsoft Exel File

In the Export Data as Microsoft Excel File dialog you can overwrite the proposed name of your export file (data source name as default) and select Expand Hierarchy to expand all the hierarchies (if any available in the data source) for the export. Note the following when exporting data as Excel file:

  • The table is exported as you see it in the resultset (with the exception being the hierarchy – if you choose the setting Expand Hierarchy)

  • Formatting (not styling) is included by default in the export. Number formatting that is also exported includes scaling, units and currencies that were defined in data analyzer.

  • Currency/Units are exported as represented in the table (Cells, Row, Column) and you can perform calculations in the exported Excel file and click in the cell to see the raw data value. You can also sort and filter in the Excel file.

  • If your table has a hierarchy, all the nodes of the hierarchy will be exported, even if you have not drilled down on the data in your table.

  • Hierarchies are indented and exported as seen in the table (unless you choose Expand Hierarchy)

  • Repetitive Member Names are not exported unless you choose to show Repetitive Member Names (by using the table's context menu Start of the navigation pathTable Functions Next navigation step  Show/Hide Next navigation step Repetitive Member NamesEnd of the navigation path.

  • Value exceptions are represented in the export.

  • Metadata sheet is exported with the following information:

    • data source

    • time of export

    • filter and variables if applicable

For more information on specifics, points to note and possible limitations when exporting data to Microsoft Excel in data analyzer, see SAP Note 3302128 Information published on SAP site

Export Data as PDF File

In the Export Data as PDF File dialog you can overwrite the proposed name of your export file. Besides you can see the predefined settings for page orientation and pager size.

How it is exported depends on the size of the table when compared to the PDF page dimensions. Page orientation, paper size, location of the page number and the name of the file you are exporting are some other properties you can set:
Print Setting Setting Value
Orientation

  • Landscape (default)

  • Portrait
Paper Size

  • A2

  • A3

  • A4 (default)

  • A5

  • Legal

  • Letter
PageNumber Location

  • None (default)

  • Header

  • Footer
Enable Appendix The appendix is exported on a separate page at the end of PDF (Default – unchecked)
Note the following when exporting data as PDF file:

  • Formatting (not styling) is included by default for the PDF export. Number formatting that is also exported includes scaling, units and currencies that were defined in data analyzer.

  • Pages are indexed and split if necessary and the headers are repeated.

  • Hierarchies are indented and exported as seen in the table.

  • Expansion symbols for indented hierarchies in the exported table output to PDF are not displayed

  • Repetitive Member Names are not exported unless you choose to show Repetitive Member Names (by using the table's context menu Start of the navigation pathTable Functions Next navigation step  Show/Hide Next navigation step Repetitive Member NamesEnd of the navigation path

  • Value exceptions are represented in the export.

  • Non-ASCII characters are not supported for the PDF file export.

For more information on specifics, points to note and possible limitations when exporting data to PDF in data analyzer, see SAP Note 3302109 Information published on SAP site

Export Data as CSV File

In the Export Data as CSV File dialog you can overwrite the proposed name of your export file and you can choose the CSV delimiter. The following delimiters are available:

  • Comma ,

  • Semicolon ;

  • Tab

  • Space

  • Dot .

  • Colon :

  • Dash -

Note the following when exporting data as CSV file:

  • The table is exported as you see it in the resultset

  • Formatting (not styling) is included by default for CSV export. Number formatting that is also exportedincludes scaling, units and currencies that were defined in data analyzer.

  • Currency/Units are exported as represented in the table (Cells, Row, Column) and you can perform calculations in the exported Excel file and click in the cell to see the raw data value. You can also sort and filter in the Excel file.

  • Hierarchies are exported as seen in the table

  • Repetitive Member Names are not exported unless you choose to show Repetitive Member Names (by using the table's context menu Start of the navigation pathTable Functions Next navigation step  Show/Hide Next navigation step Repetitive Member NamesEnd of the navigation path

  • Value exceptions are represented in the export.