Ad-hoc Query and Analysis 

With this variant, business experts can analyze data ad hoc, create query views and save and distribute the result of the ad-hoc analysis. The BEx Web Analyzer is available in the Business Explorer (BEx) for this purpose. The Web Analyzer is a user-friendly analysis tool that can be called using either a URL in the Web browser or as an iView in the portal.

It demonstrates how business experts can use data providers based either on data from SAP NetWeaver BI or from multidimensionally stored data from third-party providers to analyze business data in the Web or in the portal in a user-friendly manner.  Analysis and navigation options such as swapping columns, adding and removing characteristics and key figures using Drag&Drop, setting filter values and drilldown of data to the characteristic values are available for this purpose. In addition, the data can be displayed in chart form and exceptions and conditions can be created.

After the analysis, the changed drilldown status of the data can be saved as a query view. The query views can then be used as data providers for the BEx Web Applications, workbooks for the BEx Analyzer and for BEx Reports. The result of the analysis can also be saved and distributed using information broadcasting.

Scenario Variant Architecture

The following graphic provides an overview of the architecture:

 

In the Web Analyzer, you select the data provider, perform an ad-hoc analysis of the data, save the drilldown status of the data that has been changed by analysis and navigation as a query view, and generate a new data provider. Data providers are based either on BI InfoProviders, queries (which are based on BI InfoProviders), query views or multidimensionally stored data from third party providers. The saved query views can also be used as a data provider in other BEx tools. You can save the views changed by the analysis to the Web application and distribute them to the portal using information broadcasting. The Web Analyzer can be called using an URL in the Web browser or as in iView in the portal.

IT Processes of the Scenario Variant

These scenario variants comprise the following IT processes:

Process	What You Need to Know...
Data Provider Selection	In this process you select a data provider that forms the basis of the ad-hoc analysis. In the Web Analyzer, data providers of type query view (runtime object) are used. A query view can be based on the following elements: ·        InfoProvider from SAP NetWeaver BI ·        Query from SAP NetWeaver BI These queries are based on InfoProviders. ·        Saved query view from SAP NetWeaver BI ·        Multidimensionally stored data from third-party systems.
Ad-hoc Analysis	In this process you perform an ad-hoc analysis on the business data. A variety of analysis options are available that you can use and call using the BEx Web Analyzer. For example, you can set filter values, generate a ranked list condition (top N) and display the data in chart form. Once you have analyzed your data, you can save the changed drilldown status of the data as a query view and use them as required as a data provider in the Web Analyzer or in other BEx tools. You can save the result of the Web application generated by the analysis and distribute it using information broadcasting.