Summary

In this chapter, we created an InfoCube. To display its data model, you can right-click InfoCube demo: Basic Cube, then select Display data model…(Screen 2.30).

SCREEN 2.30

graphics/02fig30.gif

The data model appears in the right panel of Screen 2.31.

SCREEN 2.31

graphics/02fig31.gif

Note

IO_SREG and IO_SOFF are not listed under IO_SREP as attributes; rather, they have been created as independent characteristics. Section 3.6, "Entering the Master Data, Text, and Hierarchy Manually," describes how to link IO_SOFF and IO_SREG to IO_SREP via a sales organization hierarchy. Section 7.2, "InfoCube Design Alternative I – Time-Dependent Navigational Attributes," discusses a new InfoCube design in which IO_SOFF and IO_SREG are IO_SREP's attributes.

 

Key Terms

Term Description
Key figure Key figures are numeric values or quantities, such as Per Unit Sales Price, Quantity Sold, and Sales Revenue. The maximum number of characters allowed for the technical name is 9.
Characteristic Characteristics are descriptions of key figures, such as Customer ID, Material Number, Sales Representative ID, Unit of Measure, and Transaction Date. The maximum number of characters allowed for the technical name is 9.
InfoObject In BW, key figures and characteristics are collectively called InfoObjects.
InfoObject Catalog InfoObject Catalogs are used to organize InfoObjects. Two types of InfoObject Catalogs exist: one for characteristics and one for key figures. The maximum number of characters allowed for the technical name is 30.
InfoArea InfoAreas are used to organize InfoCubes and Info Objects. Each InfoCube is assigned to an InfoArea. Through an InfoObject Catalog, each InfoObject is assigned to an InfoArea as well. The maximum number of characters allowed for the technical name is 30.
InfoCube An InfoCube consists of a fact table and its associated dimension tables in the star schema. The maximum number of characters allowed for the technical name is 30.

Next…

We will load the data described in Chapter 1, Business Scenario and SAP BW, into the InfoCube.

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