After loading and activating the ODS data, we can aggregate the ODS data and move the aggregated data into the InfoCube defined in Screen 9.9.
We could have skipped this step if we had selected the option Update data targets from ODS object automatically in Screen 9.3.
Work InstructionsStep 1. To load the ODS data, right-click ODS demo, and then select Update ODS data in data target….
Step 2. Select the Initial update option. In the next section, we will see how to do delta data loads.
Step 3. BW opens an InfoPackage. Under the Processing tab, in the Update data… box, BW has selected Data targets only because it is the only choice allowed.
Step 4. Because we selected the Initial update option in Screen 9.40, the InfoPackage is set to Initialize delta process. Start the data load process from the Schedule tab.
The data have been loaded into the InfoCube. Screen 9.43 shows the fact table's contents.
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