Stock Coverage

You can use a special key figure in a query to display how long the available quantity of a given stock value will cover the planned or expected demand for.

The special key figure for stock coverage calculates how long the stock will last for using the key figures for stock and demand with reference to a time characteristic.

Example The stock in a calendar week is 10 items. This is a closing stock. The first demand to be taken into account for the stock coverage calculation is therefore in the week that follows the stock. The expected demand for the following four weeks is two items, three items, four items and two items. The stock will therefore last for 3.5 weeks. (Cells whose value is not relevant for the example contain an x).

Calendar Week	Stock	Demand	Stock Coverage
14.2013	10	x	3,5
15.2013	x	2	x
16.2013	x	3	x
17.2013	x	4	x
18.2013	x	2	x

Example The stock in a calendar week is 5 items. This is an opening stock. The expected demand for the calendar week is two items. For the following two weeks, the expected demand is two items and four items. The stock will therefore last for 2.25 weeks.

Calendar Week	Stock	Demand	Stock Coverage
14.2013	5	2	2,25
15.2013	x	2	x
16.2013	x	4	x

A key figure for stock coverage can be used in all InfoProviders, with the exception of DataStore objects. If a key figure for stock coverage is used in aggregation levels, it is not input-enabled.

A key figure for stock coverage can be used in formulas, formulas with exception aggregation, conditions and in all possible navigation states of a query. Key figures for stock coverage are not availablein the standard queries on an InfoProvider.

If a time characteristic in the query is in the drilldown or filter, or a time characteristic is a reference for an exception aggregation, this time characteristic must be compatible with the time characteristic for calculating stock coverage. If it is not compatible, you will not be able to obtain meaningful results. A time characteristic is compatible with the time characteristic for calculating the stock coverage if a unique value from the time characteristic can be assigned for every value in the time characteristic for calculating stock coverage.

Example Calendar week is compatible with Calendar day. Calendar week is not compatible with Caldendar month however (and vice versa).

To be able to obtain meaningful results, the values in the time characteristics must also be consistent. The system can only check this for InfoCubes. For all other InfoProviders, you have to ensure time consistency yourself.

Example An InfoProvider contains the time characteristics Calendar day and Calendar month. In a data set, calendar day has the value 25.04.2014, and calendar month has the value 04.2014. The time characteristics in this data set are consistent. In a second data set, calendar day has the value 18.03.2014, and calendar month has the value 02.2014. The time characteristics in this data set are not consistent. On account of the second data set, there is no consistency with regard to the time characterstics in the InfoProvider.

If fiscal periods are selected as time characteristics for calculating stock coverage, no coverage is calculated for special periods. The demand from special periods is taken into account during the stock coverage calculation, but the special period is not counted in the stock coverage calculation.

Example

The stock in this example is a closing stock.

The stock in fiscal period 11.2013 is sufficient to fully cover the demand in fiscal period 12.2013 and special period 1 2013, and to partly cover the demand in special period 2 2013. For the stock coverage calculation, only fiscal period 12.2013 is counted. The special periods are not counted. The stock coverage in fiscal period 11.2013 is therefore 1.

The stock in fiscal period 12.2013 is sufficient to fully cover the demand in special periods 1 2013 and 2 2013, and to cover 50% of the demand in fiscal period 2.2013. For the stock coverage calculation, only fiscal period 1.2014 is counted. The special periods are not counted. The stock coverage in fiscal period 12.2013 is therefore 0.5.

No stock coverage is calculated in special periods 1 2013 and 2 2013.

Fiscal Period	Stock	Demand	Stock Coverage
11.2013	10	x	1
12.2013	8	5	0,5
Special Period 1 2013	5	3
Special Period 2 2013	3	3
18.2013	x	4	x