You create the key figures Revenue, Quantity and Price.
Revenue and Quantity are values that can be analyzed at a later time. These are quantities and amounts and form the data part of the InfoCube.
The key figure Price is used in our scenario as an attribute for the InfoObject Product, which you will create at a later time.
...
1. Log onto the BI system with a user that has sufficient authorizations for executing the scenario.
2. Start the Data Warehousing Workbench in the SAP menu by choosing Modeling → Data Warehousing Workbench: Modeling.
Various functional areas are displayed at the left in the Data Warehousing Workbench. In the functional area Modeling you can display different views on the objects used in the Data Warehouse, such as InfoProviders and InfoObjects. These views show the objects in a tree. You call the functions for the relevant object from context menus (right mouse button).
3. Under Modeling, choose InfoObjects .
The InfoObject tree is displayed.
4. From the context menu at the root node InfoObjects of the InfoObject tree, choose Create InfoArea.
5. On the next screen, enter a technical name and a description for the InfoArea.
The InfoArea is displayed in the InfoObject tree. It is used to group your InfoObjects.
6. In the context menu of the InfoArea, choose Create InfoObject Catalog.
7. On the next screen, enter a technical name and description, and select Key Figure as the InfoObject Type.
8. Choose Create.
You go to the screen for InfoObject catalog editing.
9. Activate the InfoObject catalog.
The InfoObject catalog is displayed in your InfoArea. It is used to group your key figures.
10. Perform the following procedures to create each of the key figures Revenue, Quantity and Price.
a. Choose Create InfoObject... in the InfoArea for your InfoObject catalog for key figures.
b. Enter the required data on the next screen:
Input Field |
Revenue |
Quantity |
Price |
KeyFig. |
ZD_REV |
ZD_QTY |
ZD_PRICE |
Long description |
Revenue |
Quantity |
Price |
c. Choose Continue.
The key figure maintenance screen appears.
d. Make the following entries on the tab page Type/unit:
Field |
Revenue |
Quantity |
Price |
Type/Data Type |
Amount |
Quantity |
Amount |
Data Type |
CURR – Currency field, stored as DEC |
QUAN – Quantity field, points to a unit field with format UN |
CURR – Currency field, stored as DEC |
Unit/currency |
0CURRENCY |
0UNIT |
0CURRENCY |
The information on the tab page is as follows for the key figure Revenue:
e. Activate the InfoObject.
You created the following key figures for the scenario:
● Revenue (ZD_REV)
● Quantity (ZD_QTY)
● Price (ZD_PRICE)
These key figures are displayed in your InfoObject catalog. Revenue and Quantity can be used later to define the InfoCube.