BEx Web Analyzer 

The BEx Web Analyzer is a standalone, convenient Web application for data analysis that you can call using an URL or as an iView in the portal.

The Web Analyzer allows you to execute ad hoc analyses on the Web: After you have selected a data provider (query, query view, InfoProvider, or external data source), the data is displayed in a table with a navigation pane. You can navigate to the data and use other functions of the Web Analyzer that are available in the application toolbar. You can, for example, change the type of data display, use the information broadcasting functions to broadcast your analyses to others, and create printable versions of your analyses.

Technical Data

Type of application	Internet application that can be called using a URL or as an iView in the Enterprise Portal.
Technical name	The Web template 0ANALYSIS_PATTERN forms the basis of the BEx Web Analyzer.
Supported from Release	SAP NetWeaver 2004s

Included in the Following Roles

Business Explorer	com.sap.ip.bi.business_explorer_showcase
Business Intelligence	com.sap.ip.bi.bi_showcase

Features

The BEx Web Analyzer provides you with a wide range of functions for ad hoc data analysis which you can call up by means of various pushbuttons and function links. You can also use the dropdown box next to Display As… in the application toolbar of the Web Analyzer to define how the data is to be displayed:

●     in a table

●     in a graphic

●     in both a table and an graphic

The following functions are available in the Web Analyzer by means of pushbuttons or links:

Pushbuttons

●     New Analysis

You use this pushbutton to create a new ad hoc analysis by first selecting a data provider to form the basis of your analysis. You can select data providers from a BI system or from a non-SAP data source. 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 that you can select from the history, favorites, roles or InfoArea views. Select the required data provider in one of these views and then choose OK.  The data is now displayed according to the selection you made in the Display As… dropdown box.

○     Data providers from a non-SAP system:

Data providers of this type are query views or InfoProviders that you can select from the InfoArea view. Select the required data provider in this view, and then choose OK. The data is now displayed according to the selection you made in the Display As… dropdown box. 

Now you can analyze your data ad hoc. The navigation pane and the context menu of the Web application are available for this:

○     Navigation pane

The navigation pane shows the navigation status of the data provider. All the characteristics and structures of the data provider are listed. You can alter the navigation status to analyze your data by using Drag&Drop to drag characteristics or structures to an axis (rows or columns) of the table, or to remove them. You can swap axes in the navigation pane using Drag&Drop. The table changes accordingly. You can also drag characteristics onto the filter pane using Drag&Drop. For more information, see Navigation Pane.

○     Context menu

You use a variety of navigation functions from the context menu of the table. For example, you can create new documents or show existing documents. For more information, see Context Menu Functions.

Note the following constraints for some context menu entries in the Web Analyzer:

■      You use the pushbutton Print Version to reach the function of the Print Version menu entry in the Web Analyzer.

■      You use the pushbutton Settings on the tab page Conditions to reach the function of the menu entry Filter ® Conditions in the Web Analyzer.

■      You use the pushbutton Settings on the tab pageExceptions to reach the function of the menu entry Exceptions in the Web Analyzer.

■      You use the pushbutton Settings on the tab pages Table, Graphic and Data Provider to reach the function of the menu entries Properties ® Web Item and Properties ® Data Provider in the Web Analyzer

A context menu is also available in the graphic display type.

●     Open

You use this pushbutton to open saved ad hoc analyses from your favorites or the BEx Portfolio view.

●     Save As…

You use this pushbutton to save the result of your ad hoc analysis under 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 navigation status of the data. To access the saved result of your ad hoc analysis again, choose the pushbutton Open.

To save the navigation and drilldown status of the data as a new query view, choose Save 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 determine the type of display for the data using the dropdown box next to Display As…. You can choose from the following options for displaying the data:

○     in a table

○     in a graphic

○     in both a table and a graphic

●     Information

You use this pushbutton to 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. You also receive information about which static and dynamic filter values the query has and the variable values with which the query is filled. 

●     Send

You use this pushbutton to open the broadcasting wizard and use the functions of information broadcasting. You can broadcast your ad hoc analysis. For more information, see Precalculating and Broadcasting Queries, Query Views, Web Templates and Reports.

●     Print Version

You use this pushbutton to make the 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 appears on the pages printed.  When you have made your settings and have chosen OK, a PDF generation is triggered. You can print out the created PDF document.

●     Export to Excel

You use this pushbutton to export the query result to Microsoft Excel. The query data is displayed in the same way as queries are displayed in the BEx Analyzer. You see the filter restrictions and the data in the table. Exceptions are highlighted in color in the same way as they are on the Web. You can continue to edit the data using the Microsoft Excel functions.

●     Comments

You use this pushbutton to create comments on the data provider.

Function Links

●     Filters

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

●     Settings

This link provides access to the following functions:

○     You can make settings for the table, graphic, and for the data provider used for the ad hoc analysis.

■      Table

You can make settings for the layout (display alternating styles for table rows) and data cells (for example, display symbols for existing info provider documents) as well as data-specific settings (for example, display scaling factors) for the table. See Analysis.

■      Graphic

You can make settings for the Web item chart on which the graphic is based (for example, chart type selections) as well as settings for the chart texts (for example, overwrite axis labels) and data-specific settings (for example, swap axes for display) for the graphic. See Chart.

■      Data provider

You can make various settings for the data provider for runtime. For example, you can define the place in which the results are to be displayed in the table. See Data Provider Properties.

○     You use this link to display existing exceptions and conditions for the data provider or to define new exceptions and conditions in a step-by-step process.

■      Choose Insert on the Exceptions tab page to reach a new browser window in which you are taken through the process of creating new exceptions step by step. For more information, see Defining and Changing Exceptions.

You can display details for existing exceptions, change their status or delete them.

■      Choose Insert on the Conditions tab page to reach a new browser window in which you are taken through the process of creating new conditions step by step. For more information, see Defining and Changing Conditions.

You can display details for existing conditions, change their status, or delete them.

Integration

The BEX Web Analyzer is a standalone Web application that can be called through a URL by specifying the template 0ANALYSIS_PATTERN (standard Web template for ad hoc analysis).

You can also call the BEx Web Analyzer as an iView in the portal. For more information, see Overview: Integration and Display Types of BI Content and BEx Web Application or Query As iView in the Portal.

Optional Settings

As with all Web templates, you can also override the Web template properties for the standard Web template for ad hoc analysis and, therefore, for the Web Analyzer, using the appropriate parameterization. For more information, see Parameter Override.