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.
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 |
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.
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.
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.
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 |