Start of Content Area

Function documentation Exporting the List to the BEx Analyzer  Locate the document in its SAP Library structure

Use

You can export the list to the BEx Analyzer and use its comprehensive analysis functions.

The Two Implementations of the BEx Analyzer

In the BEx Analyzer, you can analyze selected data by navigation, using the context menu, or using drag and drop. You use the OLAP functionality of NetWeaver BI to do this.

You can use the BEx Analyzer in two different ways:

      As part of the Business Explorer

If you are using the BEx Analyzer within the product landscape of the Business Explorer, you are using it as an analytical reporting and design tool. The data you display in the BEx Analyzer comes from various sources that are changed and prepared by means of complex mechanisms. You can save these mechanisms in the system. If the original data changes, you can repeat the preparation and carry out the analysis again with updated material.

      As an analysis tool for data of the SAP List Viewer

If, however, you are using the BEx Analyzer with data you have exported from a list of the SAP List Viewer, you do not need all the preliminary steps for the preparation, preselection, and presentation of the data. The data is transferred directly from the list to the Excel table of the BEx Analyzer and presented in a predefined way. The data is automatically converted as required so it can be correctly displayed in the BEx Analyzer.

Note

In design mode of the BEx Analyzer, you can save complex templates and queries for the presentation of the data. You can use these again and again, even if the data changes.

When exporting from the SAP List Viewer, however, you cannot save such settings. You can change the Excel table as necessary and then save it as a local file. The next time the list is exported, the system defaults are used again to display the data. Your saved file has no effect on the presentation of the data or on whether it is up-to-date.

For a detailed description of the analysis functions of the BEx Analyzer, see Analysis Mode. This documentation describes all the settings you can make in the BEx Analyzer.

Note

Note that some of these descriptions may possibly not apply directly to your Excel table if your data comes from the SAP List Viewer.

Prerequisites

      The BEx Analyzer is installed on your computer.

      In the application toolbar for the list, the UI element for exporting the list is visible and active.

Features

When exporting a list from the SAP List Viewer to the BEx Analyzer, the system automatically carries out many conversions. The most important of these conversions are listed below:

      Mapping of the columns to characteristics and key figures

Alphanumeric columns in the list become characteristics.

Numeric columns in the list become key figures. Various formats are recognized, such as date, time, currency, and so on.

Columns that contain, for example, symbols, pushbuttons, or hyperlinks instead of text are not exported.

Note

Due to differing rounding mechanisms, differences can sometimes arise during the transfer of numeric values.

In the BEx Analyzer, the length of a characteristic is restricted to 60 characters. Longer values from the list are shortened accordingly.

      Sorting

By default, characteristics are displayed in the BEx Analyzer sorted in ascending order. If you have sorted a column in the list in descending order, this sort direction is retained during the export.

      Filters

If you have defined a filter in the list, it is transferred to the BEx Analyzer as long as you have defined it as an inclusion filter. The filter can then be defined using a single comparison value or as a range. Wildcard characters in the filter cannot be transferred.

You can change the filter in the BEx Analyzer as required.

      Calculations

By default, each numeric column of the list in the BEx Analyzer is added up and the total sum is displayed in a separate results row.

If you calculate the minimum or maximum for a column in the list, this is displayed instead of the total sum.

You cannot transfer the mean value to the BEx Analyzer.

Activities

...

...

       1.      To export the list to the BEx Analyzer, choose Export in the application toolbar and then BEx Analyzer.

The BEx Analyzer starts. The list is converted according to the predefined settings and displayed in the Excel table of the BEx Analyzer.

       2.      Make the settings required to use the data in the analysis.

 

End of Content Area