Next, let's see how BW Monitor can help us troubleshoot during the ETTL process.
Step 1. Select InfoCube demo: Basic Cube, and then click .
Step 2. Leave Selection date blank to list the status of all data loads into this InfoCube. Click to continue.
Step 3. We see the status of all data loads (12 successful, 7 failed), plus date/time information, the number of records selected from the source system, and the number of records coming into the BW system.
Double-click the last failed load operation to get its details.
Step 4. Click to display the error.
Step 5. Review the error message.
Step 6. Under the Details tab, notice how the data flowed and where the error occurred.
You have learned how to use BW Monitor to display the status of data loads and to find out when, where, and how errors (if any arose) occurred.
To examine the status of other data loads, we can click in Screen 4.10. In the new screen, we can specify selection conditions to display the status of the data loads in which we are interested (Screen 4.11). For example, by clicking in the Further selections block, we can specify user-related selection conditions.
Part I. Guided Tours
Business Scenario and SAP BW
Creating an InfoCube
Loading Data into the InfoCube
Checking Data Quality
Creating Queries and Workbooks
Managing User Authorization
Part II. Advanced Topics
Aggregates and Multi-Cubes
Operational Data Store (ODS)
Generic R/3 Data Extraction
Appendix A. BW Implementation Methodology
Appendix B. SAP Basis Overview
Appendix C. Glossary
Appendix D. Bibliography