First, let's create an ODS object.
Step 1. Right-click InfoArea – demo, and then select Create ODS object….
Step 2. Enter a name and a description, and then click to create the named ODS object.
Step 3. Select the BEx Reporting option, allowing us to create queries on the ODS object from BEx Analyzer.
We leave other options open so we have opportunities later to manually complete these tasks. It helps us to understand the data load process.
Next, click to get the necessary InfoObjects.
Step 4. Select IOC_DEMO_CH, which was created in Section 2.2. Click to continue.
Step 5. Drag IO_ORD (Order number), IO_CUST (Customer ID), IO_SREG (Sales region), IO_SOFF (Sales office), IO_SREPN2 (Sales representative ID new 2), and IO_MAT (Material number) from the left panel into the right panel and place them under the Key fields folder. Here IO_ORD is a newly created characteristic for sales orders.
Step 6. Repeat Steps 35 to add IO_QUAN and IO_PRC to the ODS object. Be sure to add them to the Data fields folder.
Step 7. Repeat Steps 35 to add 0CALDAY (Calendar day) to the ODS object. Be sure to add it to the Key fields folder.
Step 8. Click. A new InfoObject, 0RECORDMODE, is added. In Section 9.5, we will learn how to use it in delta data loads.
Click to activate the ODS object.
You have created an ODS object that includes a new InfoObject, IO_ORD, for sales orders.
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