Creating Transformations for InfoCubes (SAP Library

Creating Transformations for InfoCubes

Use

You create a transformation for InfoCube Sales Overview(ZD_SALES).

Note

The source (DataSource) and target (InfoCube) of the transformation have different time characteristics. The granular time characteristic CALENDERDAY is in the source, whereas the InfoCube contains several less granular time characteristics. By assigning CALENDERDAY to these less granular time characteristics, they are automatically filled by an automatic time conversion. You are not required to make a special entry.

Procedure

...

1. Go to the Data Warehousing Workbench; in the Modeling area choose InfoProvider.

2. In the context menu of your InfoCube, choose Create Transformation...

3. On the next screen, select object type DataSource as source of the transformation, and select the DataSource for transaction data ZD_SALES and source system PC_FILE.

4. Choose This graphic is explained in the accompanying text Create Transformation.

The maintenance screen for the transformation appears. The fields of the DataSource are displayed at the left and the rule group with the target InfoObjects at the right.

5. With the mouse, connect the DataSource fields with the target InfoObjects as follows:

DataSource Field	InfoObject
PRODUCT	ZD_PROD
SALESDOC	0DOC_NUMBER
CALENDARDAY	0CALMONTH 0CALMONTH2 0CALWEEK 0CALYEAR
CHANNEL	ZD_CHAN
QUANTITY	ZD_QTY
REVENUE	ZD_REV

Fields UNIT and CURRENCY are automatically assigned.

This graphic is explained in the accompanying text

6. Activate your transformation.

Result

You created the transformation for the sales data and have now completed all preparations for creating and executing the load process for the sales data.

Continue with ....

Creating Master Data Directly in the System