Select language:

Procedure documentation Creating Key Figures 

Use

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.

Procedure

...

  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.

This graphic is explained in the accompanying text

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

You go to the screen for InfoObject catalog editing.

This graphic is explained in the accompanying text

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

This graphic is explained in the accompanying text

  e.  Activate the InfoObject.

Result

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.

Continue with ...

Creating Characteristics

 

 

Was this page helpful to you?