Creating an ODS Object

First, let's create an ODS object.

Work Instructions

Step 1. Right-click InfoArea – demo, and then select Create ODS object….

 

 

SCREEN 9.1

graphics/09fig01.gif

Step 2. Enter a name and a description, and then click graphics/attribute.gif to create the named ODS object.

 

 

SCREEN 9.2

graphics/09fig02.gif

Step 3. Select the BEx Reporting option, allowing us to create queries on the ODS object from BEx Analyzer.

 

 

Note

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 graphics/infoobject.gif to get the necessary InfoObjects.
 

SCREEN 9.3

graphics/09fig03.gif

Step 4. Select IOC_DEMO_CH, which was created in Section 2.2. Click graphics/continue.gif to continue.

 

 

SCREEN 9.4

graphics/09fig04.gif

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.

 

 

SCREEN 9.5

graphics/09fig05.gif

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.

 

 

SCREEN 9.6

graphics/09fig06.gif

Step 7. Repeat Steps 35 to add 0CALDAY (Calendar day) to the ODS object. Be sure to add it to the Key fields folder.

 

 

SCREEN 9.7

graphics/09fig07.gif

Step 8. Clickgraphics/check.gif. A new InfoObject, 0RECORDMODE, is added. In Section 9.5, we will learn how to use it in delta data loads.

Click graphics/activate.gif to activate the ODS object.

 

 

SCREEN 9.8

graphics/09fig08.gif

Result

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

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-2017.
If you may any questions please contact us: flylib@qtcs.net