Start of Content Area

Procedure documentation Creating InfoCubes  Locate the document in its SAP Library structure

Use

You create an InfoCube into which sales data for the scenario is loaded. As InfoProvider, the InfoCube provides the basic data for the query.

Procedure

...

       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 This graphic is explained in the accompanying text 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 This graphic is explained in the accompanying text Create Another Dimension.

       8.      Enter Sales Organization as the description for the new dimension and choose This graphic is explained in the accompanying text Continue.

The dimensions are inserted.

       9.      In the toolbar in the left area, choose This graphic is explained in the accompanying text InfoObject Catalog.

   10.      On the next screen, select your InfoObject catalog for characteristics as the template and choose This graphic is explained in the accompanying text Continue.

The InfoObject catalog is displayed in the left area with the characteristics you created.

This graphic is explained in the accompanying text

   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 This graphic is explained in the accompanying text 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.

This graphic is explained in the accompanying text

   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 This graphic is explained in the accompanying text 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.

Result

You created the InfoCube Sales Overview. You can now create the required objects for loading data.

Continue with ...

Creating DataSources for Master Data

 

 

End of Content Area