BEx analyzer is an analysis and reporting tool which is an add-on in Microsoft Excel. It comes as part of the SAP Business Warehouse Desktop installation. BEx analyzer is thus a user interface based on Web technology and MS Excel. There are many standard reports available in the library, as well as the required analysis tools. These analysis tools can support complex multidimensional analysis based on different data views. Business Explorer thus acts as an information catalog, which allows users to browse the available information from the business applications. Not only that, with BW users can access information in SAP BW using the Enterprise Portal, the intranet (Web application design), or mobile technologies. I am listing some features of the BEx analyzer below.

1. Using the BEx query designer users can define and update queries. One can create different query views of data. BEx analyzer allows saving multiple queries in a workbook in excel.

2. Queries created can be processed in microsoft excel or the same can be viewed in a web browser like internet explorer.

3. BEx analyzer can be connected with VBA applications and programs. Users with advanced knowledge can develop their own programs.

4. BEX tools support editing of data such as sorting, totaling etc. These editing functions can be used in microsoft excel, to set up dashboards, reports, templates as required.

Related Posts

SAP Implementation Methodology
Defining User Roles in SAP
Digital Signatures
Under Deliveries in SAP Inventory Management