SAP BEX Overview - SAP BEX

What Is Sap Bex Overview?

SAP Business Explorer (SAP BEx) offers you the set of tools to do reporting, query examination to support strategic decision. This tool offers a lot of questions and report designing functions. You can also advance Web applications on top of the SAP BI content using BEx Web Application Designer (WAD). Using the BEx Broadcast choice, you can also broadcast the objects that are formed using Business Explorer in email or in the form of a URL. This can also be available under the Knowledge Management Content on the NetWeaver portal.

The BI content is obtainable in SAP NetWeaver BI system and the data is analysed by defining the queries in BEx Query Designer. The BEx WAD can be used to progress Web Application built on the BI content available in the SAP BW system. The BEx Report Designer tool can be used to create organized reports for printing and presentation.

The resulting tools are obtainable under SAP Business Explorer −

  • Analyzer
  • Query Designer
  • Report Designer
  • Web Application Designer

Let us now appreciate in detail about the above given tools.


A reporting and designing tool under Business Explorer is termed as analyzer, which offers integration with Microsoft Excel. You can use this tool to analyse data in an Info Provider under SAP BW. This can be used for planning by writing questions in a BEx Query Designer.

Query Designer

To analyse the data in InfoProviders under the SAP BW System we use Bex query disigner. You can describe the features and the key figures in a Query Designer to analyze the data in any InfoProvider.

Report Designer

A Report Designer can be used to make formatted information by using wide formatting options and these reports can be used for printing and can be made in different formats such as – PDF.

For Example −

  • Invoice
  • Balance Sheets
  • Sales Report, etc.

Web Application Designer

The Web Application Designer can be used to make web based applications by means of BI Content. These applications comprise HTML pages which can be retrieved via Web Browsers in the client machines or can also be issued on the NetWeaver Portal under the Knowledge Management Content.

navigate to Program Files in your SAP system → Business Explorer, to see the list of tools under Business Explorer.


When you enlarge this folder, you can see the full set of Business Explorer tools as stated in the earlier topics.


Business Explorer – Features

SAP Business Explorer is a frontend implement to design Data visualization on Business Intelligence information in SAP Business Warehouse system. It is a prevalent product that offers extensive report formatting and designing features along with Web Application Development and broadcasting of objects developed in Business Explorer.

The resulting is the list of features that are provided by SAP Business Explorer BEx Suite −

BEx Query Designer Key Features

You can use queries in the BEx Query Designer for OLAP reporting and for enterprise reporting.

  • Queries can comprise different constraints like variables for characteristic values, hierarchies, formulas, text, etc.
  • In the Query Designer, you can put on a filter to limit the whole query. While defining the filter, you can add characteristic values from one or more characteristics or also key figures in the filter. All the InfoProvider data is aggregated using the filter selection of the query.
  • One can also use user-defined characteristics and determine the content of the rows and columns of the query. This is used to require the data areas of the InfoProvider over which you want to navigate.
  • You have a choice of navigating over the query that lets you to make different views of the InfoProvider data. This can be attained by dragging any of the user defined characteristics into the rows or columns of the query.

BEx Analyzer Key Features

BEx Analyzer is separated into two modes for dissimilar purposes −

  • Analysis mode − It is used for performing OLAP analyses on queries.
  • Design mode − It is used for designing the interface for query applications.

Analysis Mode − You can do the resulting tasks in the Analysis mode −

  • You can entree the BEx Query Designer to define queries.
  • You can analyze the InfoProvider data by navigating in the queries.
  • You can use diverse functions like sorting, filtering, drilling, etc., which are common in OLAP.
  • Distribution of workbooks with BEx Broadcaster.
  • For advanced programming, you can implant your own modified VBA programs.
  • You can save workbooks on the server/locally on your computer or into favorites.

Design Mode − You can perform the resulting tasks in the design mode −

  • It can be used to design the query and you can embed dissimilar query design items like dropdown box, radio button groups, grid and buttons into your Microsoft Excel workbook.
  • you can also modify your workbook with Excel’s formatting and chart functionality.

BEx Report Designer Key Features

You can perform the resulting tasks with the report designer −

  • You can use formatting choices to create report for printing and presentation.
  • Different Layout functions that can be used to design business reports to meet business requirements.
  • You can print web applications and reports in various formats.

BEx Web Application Designer (WAD) Key Features

You can perform the following tasks with the web application designer −

  • You can use BEx WAD to make HTML pages which comprise BI precise contents such as, Tables, Maps and different Chart types.
  • Web Applications can be available on the portal and can be retrieved via a web browser.
  • Use of standard markup languages and Web Design API.
  • You can make and design web templates that can be saved and used in Web applications.

Business Explorer – Product Suite

By using SAP BEx frontend tools, you can influence numerous reporting and analysis competences on the BI information in SAP Business Warehouse. This lets you to write queries, format and design report for printing and performance, develop web applications and broadcast these objects. The SAP BEx frontend tools can be installed with or without SAP GUI tools.

In older versions, SAP Business Explorer was brought with SAP GUI installer as an add-on tool. Business Explorer can be installed independently of SAP GUI for Windows 7.10 or higher or together with SAP GUI for Windows 7.10 or higher version. When the connection is done independently for BEx frontend tools, the resulting tools are available under BEx −

  • BEx Analyzer
  • BEx Query Designer
  • BEx Report Designer

When the installation is completed as a part of the frontend package with SAP GUI, one can also use BEx Web Application Designer (WAD). This tool is not available in Release 7.10 or higher if SAP GUI is not installed on the client machine.

Hardware and Software Requirements

Hardware Requirements − System must meet all the necessities for Microsoft Excel 2003 and Windows XP or Vista.
Software Requirements −

  • Windows XP or Vista
  • Microsoft .Net Framework 2.0
  • Microsoft Excel 2003 or higher

To complete the installation of the frontend tools, one must want an installer or a CD which comprises the setup file. The user must have an administrator privilege to run the installer file.

Start SapBISetup.exe by using run as administrator option if you are not logged in with an administrator user. This will open the setup wizard as shown in the resulting screenshot.


When you click on Next, you want to select the frontend tools that you need to install. Under the Product Choice, you must select SAP Business Explorer.

It also displays you the essential disk space requirement.


Make the choice of frontend tools, click on Next. You want to select the target drive where you need the installation to be done. When you select the target drive, click on Next and it will start the setup installation.

You can see the position in the Progress bar, and when it is 100% done, installation is finished for the frontend tools.


Your Business Explorer is now positively configured and prepared to use. You can navigate to Business Explorer folder under Program Files and confirm the installation by checking resulting tools shown in the screenshot given below.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

SAP BEX Topics