Procedure for Evaluating Non-Cumulative Key Figures 

For evaluating on non-cumulative key figures, you can usually use the corresponding Business Content.See also: Installing Business Content

You can read which Business-Content objects are delivered under inventory management (SAP Library ® SAP NetWeaver Components  ® Information Integration  ®  Business Information Warehouse  ®  BI Content  ®  Supply Chain Management  ®  Supply Chain Performance Management  ® Inventory Management). Especially look at

·        the InfoCube material movements (0IC_C03),

·        the InfoSources material stocks (from 3.1 Content) (2LIS_03_BX), material movements (2LIS_03_BF) and revaluations (2LIS_03_UM) and the associated DataSources.

If you want to model your own objects, proceed as follows:

...

       1.      Source system

There are two extraction modes for non-cumulatives in the source system. The DataSources for non-cumulatives have to support one of these extraction modes.

       2.      Modeling:

Determine in which way you wish to evaluate the non-cumulative key figure. If you only wish to evaluate the non-cumulative, or the non-cumulative changes as well as the non-cumulative using a particular time period, choose modeling as a non-cumulative value with non-cumulative changes. If you also want to evaluate the inflows and outflows separately, then choose modeling as a non-cumulative key figure with inflows and outflows.

       3.      Key Figure Definition:

The non-cumulative change, or inflows and outflows, which you require for the definition of the non-cumulative key figure, must already be created as InfoObjects if the non-cumulative key figure is created. Therefore, first define either the non-cumulative change or the inflow and outflow as normal cumulative key figures where necessary. These key figures must correspond to the non-cumulative key figures, which still have to be defined, in the type definition. The non-cumulative changes, or inflows and outflows, must have ‘summation’ as aggregation and as exception aggregation.

Define the non-cumulative key figure by assigning to it the previously defined non-cumulative change, or in and outflows.

Choose the exception aggregation you want to use. Standard aggregation always equals “summation”.

       4.      InfoCube Definition:

If you transfer the non-cumulative value into the InfoCube, then the respective cumulative values (non-cumulative change, or in- and outflows) are automatically included in the InfoCube definition.

Include all time characteristics into the InfoCube definition, via which you want to evaluate the InfoCube data.

You can also choose one or more characteristics via Extras ® Maintain Non-Cumulative Values, which further specify the validity of the non-cumulative. These characteristics are additionally listed in the validity table of the non-cumulative right down to the most detailed time-reference characteristic.

Refer to the notes for defining validity tables. You do not usually have to include additional validity-determining characteristics in the validity table.

Activate the InfoCube.

       5.      InfoCube definition

Create the InfoSource(s). If you wish to load an initial non-cumulative, note that you must create two differing InfoSources for posting the initial non-cumulative and for posting the non-cumulative changes. However, initialization is not absolutely necessary.

Only non-cumulatives, therefore no non-cumulative changes, in- and outflows, or other cumulative values can be loaded with the InfoSource for the initialization.

When using the InfoSource for non-cumulative changes, only the changes, or in- and outflows, and not the non-cumulative itself, are updated.

You assign this InfoSource in the maintenance using DataSource transfer rules.

       6.      Loading Data:

If you want to load an initial non-cumulative, load this first, followed by the non-cumulative changes.

If a non-cumulative change is updated when loading data for the first time, then no further initial non-cumulative can be loaded for this characteristic value.

When loading data, the validity areas for the individual validity-defining characteristic values are automatically updated.

       7.      Query Definition:

Both the non-cumulative key figure and the non-cumulative change, or in- and outflows, are available for selection for the query definition in the InfoCube.

With evaluations in reporting, there is no difference in the way cumulative and non-cumulative values are dealt. Cumulative and non-cumulative key figures can be evaluated at the same time in a query, since the key figures are automatically aggregated correctly.