How To Fix UPC_FW165 - Key figure &1 does not have SUM as the aggregation type

SAP Error Message - Details

• Message type: E = Error

• Message class: UPC_FW - Messages for Planning Framework, Areas, Levels and Packages

• Message number: 165

• Message text: Key figure &1 does not have SUM as the aggregation type

What causes this issue?

You have included key figure &1 in your planning level. The key figure d
oes not have SUM as the aggregation type or exception aggregation.
In BPS, SUM is the only aggregation type that is used.
This has the following result:
If SUM has been defined as the normal aggregation behavior for key figur
e &1, but a different aggregation type has been defined as the exception
aggregation, this only affects the way that the totals are displayed in
the planning layout. In contrast to BW Reporting, the system ignores the
exception aggregation; the values are always totaled in BPS,
irrespective of the exception aggregation type that is defined for the
key figure.
If the normal aggregation for the key figure is not SUM but MIN or MAX,
the consequences are more extensive. When the InfoCube is compressed, th
e aggregation type that is defined for the key figure is used. The data
entered in planning is changed in accordance with the aggregation
behavior of the key figure.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

System Response

How to fix this error?

If the key figure does not have SUM as the exception aggregation, note t
he information given above about how totals will be displayed.
If the key figure has an aggregation type other than SUM defined as the
normal aggregation, remove the key figure from the planning level. If yo
u do not remove the key figure from the planning level, incorrect data
may be produced when the InfoCube is compressed.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.