You probably know how to start the BEx Query Designer, but having a short explanation of it and its layout, can help you better understand the BEx Query Designer’s functional areas and the other details that you need to know before working on the BEx Query Designer. How to start the BEx Query Designer? To […]
The purpose of the overview of the SAP BW Reporting tools landscape is to look deep into the BEx Query Designer to help us understand how we create our reports and where they can be used. The SAP BW Reporting tools landscape consist of the following structure: InfoProvider, InfoCubes InfoObjetcs DSOs InfoSets Virtual InfoProviders MultiProviders […]
Limited time give away… Ends April 24th 2013 Just enter you details below to join my newsletter and I’ll send you the course link *** Offer Finished *** Name: Email:
The Business Explorer Analyzer (BEx Analyzer) is the analysis and reporting tool of the Business Explorer that is embedded in Microsoft Excel. You can call up the BEx Query Designer in the BEx Analyzer, in order to define queries.
Full Course – Click Here
Subsequently, you can analyze the selected Info Provider data by navigating to the query created in the Query Designer and create different query views of the data. You can add the different query views for a query or add multiple queries to a workbook and save them there.
You can save the workbook in your favorites or in your role on the BW Server. You can also save the workbook locally on your computer. Beyond that you can distribute the workbook by e-mail to recipients.
In this document we will learn how to access and run BEx queries in addition to introducing some reporting functionalities used within BEx.
Access BEx Analyzer
To start the BEx Analyzer, choose Start→ All Programs → Business Explorer →Analyze. This will open Microsoft Excel with the SAP BEx plugins enabled.
Click on the Add-ins tab
Choose the Open Icon in the BEX Analysis toolbox
In the Opened menu click on “Open Query”
A window will pop up asking you to log on to the BW system. Insert your SAP BW username and password?Note that the User for BW client is different from the user in ERP client.