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'
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.
