Start of Content Area

Function documentation Time Distribution  Locate the document in its SAP Library structure

Use

You can update time characteristics with time distribution when you update InfoCubes. All the key figures that can be added are distributed to the corresponding smaller time units.

Example

You can choose time distribution if the InfoSource contains a time characteristic (such as 0CALMONTH) that is more approximate than a time characteristic of the InfoCube (such as 0CALWEEK):

For example, the calendar month 07.2001 would be divided into the weeks 26.2001, 27.2001, 28.2001, 29.2001, 30.2001 and 31.2001. Each key figure that can be added receives 1/31 of the original value for week 200126, 7/31 for each of weeks 27,28,29 and 30, and exactly 2/31 of it for week 31.

The example makes more sense if you compare it to the calendar below:

This graphic is explained in the accompanying text

Functions

You cannot select the time distribution by key figure, it is valid for all key figures.

You can define whether you want the time distribution to be based on the normal calendar or on a particular factory calendar.

Within an InfoCube you may only use one and the same characteristic and one calendar for time distribution for different time characteristics. Otherwise it would not be clear how the different results are to be combined.

Example

For example if 0CALQUARTER is used for distribution on 0CALWEEK and 0CALYEAR for distribution on 0CALMONTH, and 0CALQUARTER contains the value '1.2000' and 0CALYEAR '1999', it would not be clear how the values for 0CALWEEK (01.2000, 02.2000....) should be merged with the values for 0CALMONTH (01.1999, 02.1999...). Only 0CALQUARTER or 0CALMONTH can be chosen.

Note

This function is not implemented for ODS objects.

End of Content Area