Google+ SAP Business Information Warehouse Explorer - SAP ABAP

SAP Business Information Warehouse Explorer

The Business Explorer helps to analyze the data in the SAP Business Information Warehouse.In the Business Explorer Analyzer, you define queries that are based on a selection of InfoObjects or pre-defined query templates for an InfoCube. By navigating through queries, you generate various view of the data which enable you to analyze and present the InfoCube data. You save the queries in workbooks and can manage them in your favorites.The Business Explorer Browser allows you to manage and execute workbooks that are in your favorites folder, or that belong to one of the roles that you are assigned to.

From InfoCube to Workbook

You analyze the database in the Business Information Warehouse, by defining queries for InfoCubes.If you imagine the InfoCube as a multi-dimensional cube, when you select characteristics and key figures in a query, a smaller cube is cut out of the larger InfoCube .The multi-dimensional structure of the query data enables you to generate various views of the data in an InfoCube. The OLAP processor creates the queries from the InfoCube data and provides methods for navigation within this data.

The Business Explorer requests the data that you want for the query and presents the current view of the saved data. Only data which is actually required is transferred. If you want a new data view in the Business Explorer, the OLAP processor calls up the data from the InfoCube while you are navigating through the data.

BEx Browser: Overview

Use the BEx Browser to access all types of documents that have been assigned to you in the role maintenance, or that you saved in your favorites.The administration of the document types displayed in the BEx Browser is based on the role maintenance (activity group maintenance) in the SAP Easy Access Menu. This is where you create new roles, assign them users, and maintain authorizations. You can select and organize documents in the BEx Browser. You can also create folders and specify how you want them presented on the screen regarding their position and any graphics used. You can maintain your favorites and add new folders and objects.Alternatively, you can maintain your favorites in the SAP Easy Access Menu in BW. The objects are displayed in a tree.

Executing Queries in the BEx Analyzer

You can find the query definition you selected under Query in the BEx Analyzer, assigned to the corresponding InfoArea and InfoCube.A search function helps you to find the query quickly. You can either enter the description or the technical name of the query.When you find the query, select it with the mouse and confirm with OK. If the InfoCube contains data, the query result is shown on an Excel worksheet.

Managing Queries in the BEx Browser

If you want to save the query in a new favorites folder, proceed as follows:

ŸOpen the 'Favorites' folder in the tree structure of the BEx Browser. Place the cursor on the right side of the screen and create a new folder (right mouse-click - New -> Folder. Give it an  oppropriate name and specify how you want it presented by choosing Select Color and Symbol. Ÿ Open the BEx Analyzer and execute the selected query. Save the workbook by choosing Save -> Save as new workbook. Enter a name for the query and select the folder you created in your favorites. Confirm with OK. When you call the BEx Browser you see the name of the query in your new folder, as long as your favorites are open. Double -click on the name to start the query.

Creating a Query

Procedure for creating a new query:

ŸChoose the New icon in the toolbar.
ŸChoose the pushbutton Queries. Choose pushbutton New.
ŸThis brings you to the selection screen containing all of the InfoCubes for which you can define a new query. Select the InfoCube on whose data you want the query to be based, by selecting it with the mouse. You can see the technical name of the InfoCube by choosing Technical Name (wrench icon). To create the query, choose New.

Choosing Characteristics and Key Figures

The objects available for the InfoCube you have selected are shown as a tree structure in the left- hand part of the query definition screen. These objects include the key figures and characteristics of the dimensions.The right-hand part contains empty directories for filter selections, rows, columns, and the free characteristics of the query. The bottom right-hand part of the screen shows a preview of the query result area. This area is empty at first.By clicking the plus or minus symbol for the directories, you can expand or compress the directory structure. By expanding the key figure node in the InfoCube tree, for example, you can display a list of all the key figures for the InfoCube. You can drag the characteristics and key figures for the InfoCube into the directories for the query definition (filter, rows, columns, free characteristics).When you have finished defining your query, choose Save Query. Choose Enter (checkmark icon) to start working with the query.

Changing a Query

Choose Change Query to modify the query.
There are two options for changing the query:

ŸChoose the mode Change Query (local view) to easily move or restrict the objects that are already in the query definition. The worksheet is refreshed each time you execute the query, but the changes are not saved in the query definition.

Choose Change Query (global definition) to return to the definition screen, where you can use the same functions you could use when you first defined the query. Before executing the changed query, save the changes in the query definition. This applies the changes to the original query definition.

There are two ways of saving the changed query:
ŸYou can save the changed query under its previous name. To do this, choose Save Query in the toolbar. You can save the changed query under a new name. To do this, choose Save Query as... in the
toolbar. Enter a new technical name and a new description. You can change this description at any time.

Schema: Exception Reporting

There are three types of exception reporting:

ŸThe evaluation of exceptions online when you execute a query.
ŸThe evaluation of exceptions in the background.
ŸAnd the Alert Monitor (notifies you that exceptions have occurred).

BEx Map

SAP has developed a geographical information system for BW: the BEx Map. With it, you can display query data on a designated map.BEx Map is fully integrated in the BEx Analyzer; the user can call up BEx Map for every query that contains geo-relevant characteristics.BW customers receive maps, on which they can display query results immediately after completing a few simple maintenance activities.


Using the report/report interface you can jump from one BEx query to another query or transaction, to gain additional information for your query result. The contents of the query result cells, from which you start navigating, function as a filter.

You have the following drill-through options:

ŸFrom a BEx query to a BEx query using an InfoCube
ŸFrom a BEx query to a BEx query using an ODS object
ŸFrom a BEx query to an InfoSet query
ŸFrom a BEx query to a transaction in a source system

MultiCube Query

A MultiCube is a virtual InfoCube that contains no data itself, but that accesses data from other InfoCubes that are specified when the MultiCube is created.You can put different InfoCubes together in one MultiCube, as long as they have at least one common key field.You can use the same reporting functions for the MultiCube as for a Basis InfoCube.

Related Posts

No comments :

Post a Comment