DSO Analysis

 InfoCube: 0FC_MC01

This MultiCube merges information on open items determined on the key date using the mass activity, and settled items determined for the interval using the mass activity. The DSO (Day Sales Outstanding) is calculated for monthly periods. For this reason it is necessary that intervals for settled items are at least one month long, and that the end of an interval matches the corresponding key date for determining open items.

Example:

For the DSO calculation for the month of April, you must select the interval 04.01.04 04.30.04 for the extraction of settled items, and the key date 04.30.04 for the extraction of open items.

You can select the evaluation Calendar day, Calendar year/week, Calendar year/month and Calendar year. The system determines the value from the posting date.

DSO is calculated as follows:

DSO = Balance / Periodic business volume * 30

The balance is composed of all open items on the key date, and the periodic business volume is composed of all revenue posted in the period.

Data Modeling