How To Fix R7845 - Choose a reference characteristic for InfoCube non-cumulative values

SAP Error Message - Details

• Message type: E = Error

• Message class: R7 - BW: Data basis

• Message number: 845

• Message text: Choose a reference characteristic for InfoCube non-cumulative values

What causes this issue?

You chose non-cumulative values in the InfoCube.
For a non-cumulative value, it is required that a mutual reference
characteristic for time aggregation be determined, that defines the
granularity (degree of detail), in which the non-cumulative values are
managed. This (time) reference characteristic is valid for <zh>all</>
non-cumulative values of the InfoCube and must, therefore, be the
"smallest" time characteristic in the InfoCube, in which the
non-cumulative values can be managed.
Examples
The InfoCube contains warehouse non-cumulative values as well as the
time characteristics 'calender month' and 'calender year'.
In this case, define the InfoObject calendar month (0CALMONTH) as a
reference characteristic for the time-based aggregation.
The InfoCube contains warehouse non-cumulative values as well as the
time characteristics 'calender week' and 'calender month'.
Here you must firstly include the time characteristic 'calender day' in
the InfoCube, since 'calender week' is not the "smallest" unit of
'calender month'. Then define the InfoObject 'calender day' (0CALDAY)
as a reference characteristic for the time-based aggregation.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message R7845 - Choose a reference characteristic for InfoCube non-cumulative values ?

  The SAP error message R7845, which states "Choose a reference characteristic for InfoCube non-cumulative values," typically occurs in the context of SAP BW (Business Warehouse) when working with InfoCubes that contain non-cumulative key figures. This error indicates that the system requires a reference characteristic to properly handle the non-cumulative values.
  
  Cause:
  The error arises when you are trying to define or manipulate non-cumulative key figures in an InfoCube without specifying a reference characteristic. Non-cumulative key figures are those that do not accumulate over time, such as stock levels or balances, and they require a reference characteristic to determine how the data should be aggregated or reported.
  
  Solution:
  To resolve this error, you need to specify a reference characteristic for the non-cumulative key figures in your InfoCube. Here are the steps to do this:
  
  
  Open the InfoCube in the Data Warehousing Workbench (RSA1):
  
  Navigate to the InfoCube that is causing the error.
  
  
  
  Edit the InfoCube:
  
  Go to the "Modeling"