You create a transformation for InfoCube Sales Overview(ZD_SALES).
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.
...
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 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.
6. Activate your transformation.
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.
Creating Master Data Directly in the System