Distributing Key Figures

You can distribute the cost or quantity across a particular periodic breakdown in the planning sheet. For example, to distribute cost or quantity across months when a monthly query is used.

Note Note

Only one line item can be distributed at a time. Suppose cost is not distributed equally throughout the periodic breakdown, then the number in the last periodic breakdown cell will be rounded off.

End of the note.

Prerequisites

You have the required roles and authorizations.
Financial plans linked with master project structures (also known as execution structures) are available in the system.
SAP BusinessObjects Analysis, edition for Microsoft Office is installed on your system.
You have made the following settings in Customizing under SAP Commercial Project Management Project Cost and Revenue Planning :
- Define Plan Scenarios
- Define Resource Types
- Define Resources
- Define Plan Types

Procedure

Distributing Quantity Equally

Select a quantity cell on the relevant line item.
Enter the new value to be distributed.
On the Analysis ribbon in the Financial Planning section, choose Distribute.
The entered quantity value is distributed equally across the periodic breakdown.
On the Analysis ribbon in the Planning section, choose Save Data to transfer the data to the InfoCube.

Distributing Quantity by Self-Reference

Example Example

Self-reference distributes the quantities according to the pre-existing ratio of the periodic distribution of the quantity cells. For example, for a line item, if the quantity for March is 200 and that for April is 300, when you distribute by self-reference, the quantities for March and April are distributed in the ratio 2:3.

End of the example.

Select a quantity cell on the relevant line item.
Enter the new value to be distributed.
On the Analysis ribbon in the Financial Planning section, choose Recalculate.

The quantity value entered is distributed according to the pre-existing ratio of the periodic distribution.
On the Analysis ribbon in the Planning section, choose Save Data to transfer the data to the InfoCube.

Distributing Cost with Reference to Quantity

Example Example

In this distribution logic, the cost is distributed in proportion to the quantity. For example, if the quantity for April is 300 and for May is 500, then the cost is distributed for the months of April and May (for that line item) in the ratio 3:5.

End of the example.

Select a cost cell on the relevant line item.
Enter the new value to be distributed.
Select the cell and on the Analysis ribbon in the Financial Planning section, chooseDistribute.
The Options dialog box appears.
Select the Reference by Quantity radio button.
Choose OK.

The entered cost value is distributed with reference to quantity.
On the Analysis ribbon in the Financial Planning section, choose Save Data to transfer the data to the InfoCube.

Distributing Cost Equally

Select a cost cell on the relevant line item.
Enter the new value to be distributed.
On the Analysis ribbon in the Financial Planning section, choose Distribute.
The Options dialog box appears.
Select the Equally Distribute radio button.
Choose OK.

The cost value entered is distributed equally across the periodic breakdown.
On the Analysis ribbon in the Financial Planning section, choose Save Data to transfer the data to the InfoCube.

Distributing Cost with Reference to Revenue

Example Example

In this distribution logic, the cost is distributed in proportion to the revenue. For example, if the revenue for April is 300 and for May is 500, then the cost is distributed for the months of April and May (for that line item) in the ratio 3:5.

End of the example.

Select a cost cell on the relevant line item.
Enter the new value to be distributed.
Select the cell and on the Analysis ribbon in the Financial Planning section, chooseDistribute.
The Options dialog box appears.
Select the Reference by Revenue radio button.
Choose OK.

The cost value entered is distributed by reference of revenue.
On the Analysis ribbon in the Financial Planning section, choose Save Data to transfer the data to the InfoCube.