Preparing to Load Data into the ODS Object, Then into an InfoCube

To load data into the ODS object, we need to create an InfoSource, transfer rules, and update rules as we did in Chapter 3. After loading the data into the ODS object, we will aggregate the data from the ODS object and load them into an InfoCube.

Prerequisites

A new InfoCube has been created that will accept the data from the ODS object. Screen 9.9 shows its data model.

SCREEN 9.9

graphics/09fig09.gif

Work Instructions

Step 1. Repeat the procedure outlined in Section 3.7 to create an InfoSource, IS_ODS_DEMO, and then create transfer rules. Screen 9.10 shows the active transfer rules.

 

 

SCREEN 9.10

graphics/09fig10.gif

Step 2. Repeat the procedure outlined in Section 3.8 to create update rules. The InfoSource is IS_ODS_DEMO. Screen 9.11 shows the active update rules.

Let's check the update type for ODS data fields. To display the update type for Sales quantity, select Sales quantity and then clickgraphics/salesquantity.gif.

 

 

SCREEN 9.11

graphics/09fig11.gif

Step 3. Screen 9.12 shows one of the differences between ODS objects and InfoCubes: The default update type for an ODS object is Overwrite, and the default update type for an InfoCube is Addition.

 

 

SCREEN 9.12

graphics/09fig12.gif

Step 4. Repeat the procedure outlined in Section 3.8 to create update rules for the InfoCube shown in Figure 9.2. In this case, use the ODS object ODS_DEMO as the DataSource instead of the InfoSource as shown in Screen 3.64. Click graphics/infosource.gif to continue.

 

 

SCREEN 9.13

graphics/09fig13.gif

Step 5. After proposing update rules, BW finds out that one or more InfoCube key figures cannot have one-to-one mappings with the key figures in the ODS object. It therefore decides the update type for these key figures should be set to "no update."

In Screen 9.15, we will find out which InfoCube key figures do not have the one-to-one mappings with the key figures in the ODS object. Click graphics/continue.gif to continue.

 

 

SCREEN 9.14

graphics/09fig14.gif

Step 6. Screen 9.15 shows that the key figure Sales revenue does not have a one-to-one mapping with a key figure in the ODS object. Let's create an update rule for it. Select Sales revenue, and then click.graphics/salesquantity.gif

 

 

SCREEN 9.15

graphics/09fig15.gif

Step 7. Click graphics/attribute.gif to create an update rule.

 

 

SCREEN 9.16

graphics/09fig16.gif

Step 8. Enter a description, and then click graphics/editor.gif to open the ABAP editor.

 

 

SCREEN 9.17

graphics/09fig17.gif

Step 9. Enter RESULT = COMM_ STRUCTURE-/BIC/IO_QUAN * COMM_ STRUCTURE-/BIC/IO_PRC. as shown on line 21, and then click graphics/check.gif to check the routine. If it is valid, click graphics/save.gif to save it and go back.

 

 

SCREEN 9.18

graphics/09fig18.gif

Step 10. Click graphics/continue.gif to continue.

 

 

SCREEN 9.19

graphics/09fig19.gif

Step 11. Click graphics/check.gif to check the update rules. If they are valid, click graphics/activate.gif to activate them.

 

 

SCREEN 9.20

graphics/09fig20.gif

Result

Screen 9.21 shows you have achieved a data flow path from the flat file source system all the way to the InfoCube.

SCREEN 9.21

graphics/09fig21.gif

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

InfoCube Design

Aggregates and Multi-Cubes

Operational Data Store (ODS)

Business Content

Generic R/3 Data Extraction

Data Maintenance

Performance Tuning

Object Transport

Appendix A. BW Implementation Methodology

Object Transport

Appendix B. SAP Basis Overview

Object Transport

Appendix C. Glossary

Appendix D. Bibliography



SAP Bw. A Step-By-Step Guide
Sap Bw: a Step By Step Guide for Bw 2.0
ISBN: B000LZM8CM
EAN: N/A
Year: 2002
Pages: 106

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net