Creating a BEx query to directly access SAP BW as a data source

You can again use the sample data from eFashion that we have downloaded earlier. We will refer the dataset from eFashion, you can choose cube of your own that is available in your system:

1. Start BEx Query Designer and connect to the SAP BW system when asked to provide login credentials.
2. Create a new BEx Query using the Info Provider eFashion cube. Move the characteristic store (technical name = EF_STORE) to the Rows section.
3. Use the basic key figures, amount sold (EFAMTSOLD) and quantity sold (QTY_SOLD), in the Columns section.
4. Save the query in the role folder.
5. Execute the query in the BEx Web Analyzer to view the data and see if it is correct.
6. Make the necessary changes in the BEx query definition to enable users of your report.
7. To select the data related to specific countries states (EF_STATE). Save the query and execute it in BEx Web Analyzer in the same way you did previously.
8. Execute the report with restrictions on STATE and check the results.