Creating an InfoCube

The following steps demonstrate how to create an InfoCube, the fact table and associated dimension tables, for the sales data shown in Table 1.4.

Work Instructions

Step 1. Select Data targets under Modelling in the left panel. In the right panel, right-click InfoArea demo and then select Create InfoCube….

 

 

SCREEN 2.22

graphics/02fig22.gif

Step 2. Enter a name and a description, select the option Basic Cube in block InfoCube type, and then click graphics/attribute.gif to create the InfoCube.

 

 

Note

An InfoCube can be a basic cube, a multi-cube, an SAP remote cube, or a general remote cube.

A basic cube has a fact table and associated dimension tables, and it contains data. We are building a basic cube.

A multi-cube is a union of multiple basic cubes and/or remote cubes to allow cross-subject analysis. It does not contain data. See Chapter 8, Aggregates and Multi-Cubes, for an example.

SCREEN 2.23

graphics/02fig23.gif

A remote cube does not contain data; instead, the data reside in the source system. A remote cube is analogous to a channel, allowing users to access the data using BEx. As a consequence, querying the data leads to poor performance.

If the source system is an SAP system, we need to select the option SAP RemoteCube. Otherwise, we need to select the option Gen. Remote Cube. This book will not discuss remote cubes.

Step 3. Select IO_CUST, IO_MAT, and IO_SREP from the Template table, and move them to the Structure table by clicking graphics/previous.gif.

Next, click the Dimensions… button to create dimensions and assign these characteristics to the dimensions.

 

 

SCREEN 2.24

graphics/02fig24.gif

Step 4. Click , graphics/create1.gif and then enter a description for the dimension.

 

 

Note

BW automatically assigns technical names to each dimension with the format .

Fixed dimension is reserved for Data Packet, Time, and Unit. Section 12.2.3, "Data Load Requests," discusses the Data Packet dimension.

A dimension uses a key column in the fact table. In most databases, a table can have a maximum of 16 key columns. Therefore, BW mandates that an InfoCube can have a maximum of 16 dimensions: three are reserved for Data Packet, Time, and Unit; the remaining 13 are left for us to use.

Repeat the same procedure to create two other dimensions. Next, click the Assign tab to assign the characteristics to the dimensions.
 

SCREEN 2.25

graphics/02fig25.gif

Step 5. Select a characteristic in the Characteristics and assigned dimension block, select a dimension to which the characteristic will be assigned in the Dimensions block, and then click graphics/assign.gif to assign the characteristic to the dimension.

 

 

SCREEN 2.26

graphics/02fig26.gif

Step 6. After assigning all three characteristics to their dimensions, click graphics/continue.gif to continue.

 

 

SCREEN 2.27

graphics/02fig27.gif

Step 7. Select the Time characteristics tab, select 0CALDAY from the Template table, and move it to the Structure table by clicking graphics/previous.gif.

 

 

SCREEN 2.28

graphics/02fig28.gif

Step 8. Select the Key figures tab, select IO_PRC, IO_QUAN, and IO_REV from the Template table and move them to the Structure table by clicking graphics/previous.gif.

Next, click graphics/check.gif to check the InfoCube. If it is valid, click graphics/activate.gif to activate the InfoCube.

 

 

SCREEN 2.29

graphics/02fig29.gif

Result

You have created the InfoCube IC_DEMOBC. A status message InfoCube IC_DEMOBC activated will appear at the bottom of Screen 2.29.

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