You create an InfoCube into which sales data for the scenario is loaded. As InfoProvider, the InfoCube provides the basic data for the query.
...
1. You are in the Modeling functional area of the Data Warehousing Workbench.
2. Choose InfoProvider.
The InfoProvider tree is displayed. The InfoArea created previously in the InfoObject tree is also displayed in the InfoProvider tree. It contains the characteristics that were defined as InfoProvider and is used to group further objects.
3. In the context menu of the InfoArea, choose Create InfoCube.
4. In the next screen, enter ZD_SALES as the technical name under InfoCube and Sales Overview as the description.
5. Select Standard InfoCube as InfoProvider Type and choose Create.
You go to the screen for InfoCube editing.
6. Choose Create New Dimensions in the context menu of the folder Dimensions.
7. Enter Product as the description for the new dimension and choose Create Another Dimension.
8. Enter Sales Organization as the description for the new dimension and choose Continue.
The dimensions are inserted.
9. In the toolbar in the left area, choose InfoObject Catalog.
10. On the next screen, select your InfoObject catalog for characteristics as the template and choose Continue.
The InfoObject catalog is displayed in the left area with the characteristics you created.
11. Assign the characteristics to the dimensions as follows with drag and drop:
Characteristic |
Dimension |
ZD_PROD (Product) |
Product |
ZD_CHAN (Channel) |
Sales Organization |
12. Choose InfoObject Direct Input in the context menu of the dimension Sales Organization.
13. On the next screen, enter the characteristic 0DOC_NUMBER (Sales Document) and choose Continue.
The characteristic Sales Document is a shipped InfoObject of BI Content.
14. Expand the folder Navigation Attributes. Activate the navigation attribute Product Group (ZD_PROD__ZDPGROUP) by setting the indicator in column On/Off.
15. If it does not yet exist, add the following time characteristics of BI Content to the dimension Time. To do this, choose of InfoObject Direct Input in the context menu of the dimension Time, enter the required data, and choose Continue.
○ 0CALMONTH (Calendar Year/Month)
○ 0CALMONTH2 (Calendar Month)
○ 0CALWEEK (Calendar Year/Week)
○ 0CALYEAR (Calendar Year)
16. Choose of InfoObject Direct Input in the context menu of the folder Key Figures and enter the following key figures:
○ ZD_QTY (Quantity)
○ ZD_REV (Revenue)
17. Delete Dimension1, which is not required, if it exists. To do so, choose Delete in the context menu of the dimension.
18. Activate the InfoCube.
You created the InfoCube Sales Overview. You can now create the required objects for loading data.
Creating DataSources for Master Data