Using the pushbuttons available in BEx Web Analyzer, you can quickly navigate to important functions, where you can analyze your business data. You can also use the navigation pane and context menu to access a variety of analysis functions.
To perform an analysis based on a data provider from an external system, you first need to create the external system in the portal system landscape.
External systems can be connected using JDBC. The data from the external systems is available as external InfoProviders.
External systems are only visible in BEx Web Analyzer when the BW Directory Provider property is activated for the system object in the system landscape.
More information: BI Java Connectors and Working with Data Providers .
The following functions are available as pushbuttons, in the navigation pane and the context menu:
New Analysis
Use this pushbutton to create a new analysis by selecting a data provider to base your analysis on. You can select data providers from a BW system or from a non-SAP data source. You make this selection in the upper dropdown box in the dialog box.
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 specified in the Display As dropdown box.
Data providers of this type are query views or InfoProviders, which you can select from the InfoArea view. Select the required data provider in this view and choose OK. The data is displayed as specified in the Display As dropdown box.
You can now run an analysis of your data. You can use the navigation pane, the interaction options in the analysis grid, and the context menu in the Web application here:
The navigation pane displays the navigational state of the data provider. All the characteristics and structures of the data provider are listed. You can change the navigational state to analyze your data. You can perform the following navigation steps for example:
You can also use the various navigation options in the analysis grid, by moving characteristics or structures in the analysis grid for example.
More information: Analyzing Data in an Analysis Grid (with Navigation and Filter Panes) .
You can use a variety of navigation functions in the grid's context menu. You can create new documents, show existing ones, or personalize the Web application for example. More information: Context Menu Functions .
Open
You can open saved analyses from your favorites or the BEx Portfolio view.
Save As…
You can save the current view of your analysis with an appropriate name as a bookmark in your portal favorites or in 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 view of your 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 this query iView as a data provider for other BEx applications.
Display As
You specify 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:
Information
You can use this pushbutton to display information about the selected data provider. You can display information about the key date, how up-to-date the data is, 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 the static and dynamic filter values of the query and the variable values used to fill the query.
Send
Using this pushbutton, you can start the Broadcasting Wizard and use the information broadcasting functions. You can use this function to broadcast your analysis. More information: Precalculating and Broadcasting Queries, Query Views, Web Templates, and Reports .
Print Version
You can use this pushbutton to make settings for a print version of your analysis. You can specify the format for the print version for example, and decide whether a header should appear on the printed pages. Once you have made your settings and chosen OK, a PDF is generated. You can print the generated PDF document. More information: Creating Print Versions of BEx Applications
Export to Excel
You can use this pushbutton to export the query result to Microsoft Excel. The query data is displayed in the same way as queries in BEx Analyzer. You see the filter restrictions and the data in the table. Exceptions are highlighted in color the same as on the Web. You can continue editing the data using the Microsoft Excel functions.
Comments
You can use this pushbutton to create comments for the data provider.
More information:
Using Documents in Web Applications