The BEx Web Analyzer provides you with a standalone, comfortable Web application for data analysis that you can call using an URL or as an iView in the Enterprise Portal. You can open a query or a view in the Web Analyzer or you can define a new query. You can change the view of the data analysis using tab pages (in table form or graphically). You can also request information for the selected data provider (query or view) or you can call the BEx Broadcaster to precalculate and distribute queries, for example.
Type of application
Internet application that can be called using a URL or as an iView in the Enterprise Portal.
The Web template 0ANALYZER forms the basis of the BEx Web Analyzer.
Supported from Release
SAP BW 3.5
Included in the following role
The BEx Web Analyzer enables a wide variety of features for data analysis via various tab pages and the corresponding view-specific application toolbars. You can also open and save queries or views using functions that can be called up as a link and you can also call the Ad-hoc Query Designer for query definition.
The following describes the functions of the various tab pages with the associated view-oriented pushbutton bars, along with the additional functions that can be called using links.
· Open Query and Open View
With this function, you get to an open dialog that is displayed in a separate browser window. Depending on which element you select from the dropdown box, you can select a query or a view from the history, favorites, InfoAreas or roles.
· Saving a view
If you have analyzed data in the Web application and want to save a specific navigation state, you can get to this function from the save dialog, which is displayed in a separate browser window. Assign a description and a technical name to a view and select whether the existing view should be overwritten.
· Query Designer
If you define new queries in the Web Analyzer or want to change the existing query, you can call the Ad-hoc Query Designer in a separate browser window with this function. You can find more information under Functions of the Ad-hoc Query Designer.
· Data Analysis
In this view, the query or the view is displayed as a table. You can navigate to the query or the view using the context menu of the table or you can use navigation via the navigation block. In addition, the following functions are available through the application toolbar.
You can set a bookmark that enables you to call up a certain navigational state for the query at a later date. The system generates a URL that can be used as a bookmark. This URL is displayed in the address line of your Web browser. You save the URL in your favorites or copy and paste it into other files so that you are able to access bookmarks again later. For more information, see Setting Bookmarks.
¡ Variable Screen
If the query contains variables, you can use this function to display the screen for variables so that you can select additional variable values as required. For more information, see The Variables Screen.
¡ Exceptions and Conditions
If you call this function, a screen area for the creation of exceptions and conditions is displayed above the navigation block and the table.
Using Create in the Exceptions screen area, you get to a separate browser window where you are able to create new exceptions. The existing exceptions are displayed along with their status (active, inactive, not applicable, not used). In the context menu of an exception, you can deactivate, change, or delete the exception. If want to display the exception in the table, select Transfer. For more information, see Defining and Changing Exceptions.
Using Create in the Conditions screen area, you get to a separate browser window where you are able to create new conditions. The existing conditions are displayed along with their status (active, inactive, not applicable, not usable). In the context menu of a condition, you can deactivate, change, or delete the condition. If want to display the conditions in the table, select Transfer. For more information, see Defining and Changing Conditions.
If you call this function, you get to the document browser, where you are able to create documents on the navigational state or you are able to change or delete existing documents. For more information, see Using Documents in Web Applications.
¡ Export to MS Excel 2000
You can export query data to MS Excel 2000. 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. However, you can continue to edit the query using the MS Excel functions.
¡ Export to CSV
You can export the query data into a CSV (comma separated value) file. Unlike exporting to MS Excel 2000, you do not see the numbers in context and you cannot see the filter data. The query formatting (such as how the exceptions are displayed) is also not transferred to the CSV file.
· Graphical Display
In this view, you can display query data graphically. Using the selections in the dropdown box, you can define whether the query should be displayed as a column, line, pie, bar or stacked column diagram. The following functions are also available to you in the graphic view:
¡ Bookmark (see description above))
¡ Swap Axes
You can swap the axes of the chart in the display without affecting the navigational state of the view itself. To undo the swapping of the axes, select Swap Axes again.
¡ Export to Excel (see description above)
In this view, you get information about the key data, the timeliness of the data, the time changed, 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 with which variable value the query is filled.
You can also call up the document browser with the query documentation using Query Information.
· Information Broadcasting
In this view, you can also use the functions of the BEx Broadcaster. You can also precalculate and distribute various objects with business intelligence content (Web templates, queries, workbooks). Since the precalculation and distribution of the current query is obvious from the context of the BEx Web Analyzer, you can make all settings that are possible for the precalculation and distribution of queries using Create New Setting and Create New Setting with Wizard. The saved settings are then displayed in the table.
If you have already made broadcast settings in the current query, they will be displayed in the table. Using the context menu, you can edit, delete, execute or schedule settings.
Query Settings takes you to a separate browser window for the open dialog, from which you are able to select other queries to be precalculated and distributed. You can schedule broadcast settings for queries, Web templates and workbooks. To do this, select Web Template Settings or Workbook Settings.
In addition to the option of calling the BEx Broadcaster from the information broadcasting view, you also get to the broadcaster functions through the tabular view under the Data Analysis tab page. To do this, select Distribute ® by E-Mail orby Enterprise Portal in the context menu.
For more information, see Functions of the BEx Broadcaster.
The BEX Web Analyzer is a standalone Web application that can be called through a URL by specifying the template ID 0ANALYZER.
You can also call the BEx Web Analyzer as an iView in the Enterprise Portal. For more information, see Overview: Integration- and Display Types of BW Content in the Enterprise Portal and BEx Web Application or Query as iView in the Enterprise Portal.
As with all Web templates, you an also override the Web template properties in the standard Web template for ad-hoc analysis using the appropriate parameterization. For more information, see Overriding Attributes and Object Tag for the Properties of Web Templates.