Exporting as a CSV File/Excel File (SAP Library

Exporting as a CSV File/Excel File

Use

In order to process a query executed in a Web application further, you have to export the query as a CSV file or a Microsoft Excel file.

Prerequisites

· You have executed a query in your Web application and want to display it in a different format to continue processing the query.

· To export the data to an Excel file, you have opened the BEx Analyzer

Procedure

...

1. From the context menu (left mouse-click on the text of a characteristic, characteristic value, structural component, description of exception, description of condition), choose Export As.... ® CSV File or Export As.... ® MS Excel File The system exports the data into a CSV file or a Microsoft Excel file.

Note

Export to Microsoft Excel files from Microsoft Excel 2000 is supported.

2. If you choose Export As...® CSV File, the query is displayed in CSV format (comma separated value). The numerical values of the query are displayed in a list and are separated with commas. The numerical values context, formatting (for example, displaying exceptions) and the filter data are available in the CSV file. You cannot navigate further with BI functions.

3. If you choose Export As....® MS Excel File, the query is embedded in the BEx Analyzer that you opened previously:

Note

You have to make a few settings in your Windows Explorer so that the query is embedded in the BEx Analyzer. For more information, see SAP Note 439936.

a. Choose This graphic is explained in the accompanying text (Refresh Query) from the BEx toolbar. You are asked to log on to the system. Once you have logged on, the query is displayed in the BEx Analyzer. You can navigate in the query as usual and use all of the BI functions from the context menu and the toolbar.

b. To display the query and its current navigational status again, from the BEx toolbar choose This graphic is explained in the accompanying text (Tools) ® Launch in Web Browser ® Query (Default View). The query is displayed on the Web in its current navigational state. This Web display is based on the Standard Web Template for Ad Hoc Analysis.