Skip to main content

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.

Comments

Free Web Scraping said…
Hello Dude,

Bex enables end user to locate reports, view reports, analyze information and can execute queries. The queries in workbook can be saved to there respective roles in the Bex browser. Thanks a lot.....
November 17, 2011 at 7:27 PM
Post a Comment

Popular posts from this blog

Step by Step guide on BADI with Filter implementation

Step 1 à Before implementing filter objects to a BADI. We need to deactivate all the implementation for that BADI. Go to SE18 (BADI definition) and from there navigate to all BADI implementation to view all the active implementations for that BADI Select the BADI implementations listed on the screen and deactivate the implementation. Once done, return back to the initial screen of SE18 and proceed with next step. Step 2 à go to SE18 – BADI Definition screen and change the existing BADI definition that we created in the earlier tutorial.   Select the FILTER –DEPENDENT check box under the TYPE section. This will open up the FILTER TYPE field for inputs. And do an F1 on the FILTER TYPE field. Click on the F4 on the FILTER TYPE field name and enter some search criteria to find a relevant data element. And click on the continue button   Select the data element from the list to set up your filter and hit enter. Click on the save butto...
1 comment
Read more

Create Data Source in SAP

Data Sources are extraction structure. Data Sources are used to extract data from various source system. In the below steps, we will see how to create a data source using a SAP table VBAK. 1) Execute transaction RSO2 2) Enter data source name to be created 3) Press Create 4) Enter description of the data source 5) Enter the name of table or view on which data source has to be created. Data Source can also be created using a View, Info set or a Function Module. 6) Save the data source 7) Execute RSO2 again and click Change 8) Select VBELN field as selection 9) Save the Data Source 11) To check whether data is getting extracted, execute transaction RSA3 12) Enter the name of data source as shown below and press 'Extraction' 13) An information message will appear stating no. of records fetched 14) Additional button 'Display list' will appear, press button 15) Select one of the data packet and double click to get records fetched 16) Data Source is ready to be used!
4 comments
Read more

Operational Data Store (ODS) using SAP BW 3.5

Operational Data Store (ODS) using SAP BW 3.5 ODS consists of 'Key fields' and 'Data fields'. Data fields can also contain characteristics e.g. customer, product etc.. ODS is not used for multi-dimensional analysis like Infocube . The data from ODS can be updated with delta update into a Infocube. The data in ODS is stored in a transparent table. There is no fact or dimensional table created for ODS. Following are the steps to create an ODS: 1) Execute transaction RSA1, select the InfoArea under which you would like to create ODS. Right click the InfoArea, select 'Create ODS Object' 2) Enter ODS Object 'Name' and 'Description', press 'Create' 3) Check the box against 'BEx Reporting' to enable ODS for BEx reporting, press 'InfoObject Catalog' button to get the InfoObjects which you would like to add to ODS 4) Select the characteristics (InfoObjects) which you would like to add as 'Key fields' or 'Data fields...
3 comments
Read more