List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

Running a Query (BEx) for Data Extraction

Data Warehouse is setup based on reporting requirements of business users. Hence, Reporting is a crucial functionality of any data warehousing solution.

SAP BW provides easy to use graphical functionality named Business Explorer (BEx) to create and execute queries
to retrieve data from InfoProviders e.g. InfoCubes, Operational Data Store etc..

Business Users can directly execute the pre-defined queries whenever they want to get the information available in business warehouse.

We will see how to execute a already defined BEx query in this section.

1) Go to 'Start', select 'Business Explorer', select 'Analyzer'

2) Following bar will appear with Microsoft Excel

3) Open the query to be executed and press 'Refresh' button (3rd from left in the above bar)

4) Following window will appear with system to be connected, select the system (system details from the below screen are earsed)

5) Enter user id and password to connect to SAP system

6) Based on query definition, a selection window will appear (if defined), press execute button

7) System will display status bar for the query. Display report will look like this.



This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget