Start of Content Area

Background documentation Analysis Pattern  Locate the document in its SAP Library structure

Definition

The analysis pattern is a schema for user-friendly BEx Web Applications intended for users with basic BI knowledge. It can be used for comfortable ad hoc analysis of business data. In the context of the portal, the analysis pattern is also called the Web Analyzer.

Structure

The analysis pattern allows you to perform ad hoc analysis of business data on the Web. The various analysis options are provided on the application toolbar and as functions that can be called as links. In the main screen area of the pattern, the data is displayed in a table, a graphic, or both, depending on the settings. The navigation pane is to the left of the pattern.

The following figure is a schematic display of the analysis pattern.

 This graphic is explained in the accompanying text

Functions of the Analysis Pattern

The most important functions of ad hoc analysis are listed below:

Application Toolbar

Pushbutton

Description of Functions

New Analysis

You create a new ad hoc analysis by first selecting a data provider as the basis of your analysis. You can select data providers from a BI system or external data sources. You make this selection in the upper dropdown box of the dialog box.

Data providers from the BI system:

Data providers of this type can be queries, query views, or InfoProviders, which you can select from the history, favorites, roles, or InfoArea views. In one of these views, select the required data provider and choose OK. The data is displayed as you selected in the Display As dropdown box.

Data provider from an external system:

Data providers of this type are query views or InfoProviders, which you can select from the InfoArea view. In this view, select the required data provider and choose OK. The data is displayed as you selected in the Display As dropdown box. 

Open

You can open saved ad hoc analyses from your favorites or BEx Portfolio view.

Save As…

You can save the result of your ad hoc analysis with an appropriate name in your portal favorites or in the BEx Portfolio. This saves the type of data display (table, graphic, table and graphic) in addition to the navigational state of the data. To access the saved result of your ad hoc analysis again, choose Open.

To save the navigational and drilldown state of the data as a new query view, choose Save View in the context menu of the Web application. You can use the query iView created in this way as a data provider for other BI applications.

Display As

You specify the type of display for the data using the dropdown box next to Display As. You can choose one of the following options to display the data:

     in a table

     in a graphic

     in a table and in a graphic

Information

You can display information about the selected data provider. You can display information about the key date, the age of the data, the time of the last change, the person who last changed the query, and the date of the last refresh.

Send

You can open the broadcasting wizard and use information broadcasting functions. You can broadcast your ad hoc analysis. For more information, see Broadcasting BI Applications with the Broadcasting Wizard.

Print Version

You can make settings for a print version of your ad hoc analysis. For example, you can set the format for the print version and define whether a header is to appear on the pages printed.  When you have made your settings and have chosen OK, a PDF is generated. You can print the generated PDF document. For more information, see Printing BI Applications.

Export to Excel

You can export the query result to Microsoft Excel. Like queries, the query data is displayed in the BEx Analyzer, the analysis tool of the Business Explorer that is integrated into Microsoft Excel. The filter constraints and the data are displayed in the table. Exceptions are displayed in color in the same way as links on the Web. You can further edit the data with Microsoft Excel functions. For more information about the functions of the BEx Analyzer, see the Power User Guide under Enterprise Reporting, Query, and Analysis.

Comments

You can create comments for the data provider. See also Using BI Documents in BI Applications. 

Functions That Can Be Called As Links

Filter

You can use this link to display the filter pane. The characteristics that you use for filtering are displayed in the filter pane. For each characteristic used in the data provider, you can enter characteristic values to be used for filtering.

For more information about the Settings function, see the Power User Guide under Enterprise Reporting, Query, and Analysis.

Functions of the Analysis Pattern

After you have selected a data provider (query, query view, InfoProvider, external data source), the data is displayed in a table with a navigation pane on the left side of the pattern. You can use the following options in addition to those described above for data analysis:

     Drag and drop

Using drag and drop, you can drag characteristics and key figures to an axis (row or column) in the table or take them from axes. You can swap the axes in the navigation pane using drag and drop; the table changes accordingly. To filter the table according to these characteristics and change the drilldown, you can also drag characteristics to the filter pane using drag and drop.

     Context menu

You can use additional navigation and analysis functions in the context menu of the table. For example, from the context menu, you can display existing documents for the cells or create a comment for a certain cell. For more information, see Context Menu Functions.

 

End of Content Area