How To Fix CM_SUB_INFOSYS036 - Contained indirectly also is only possible with dimension "relationshp"

CM_SUB_INFOSYS036 - Overview

• Message type: E = Error

• Message class: CM_SUB_INFOSYS - Substance information system

• Message number: 036

• Message text: Contained indirectly also is only possible with dimension "relationshp"

What causes this issue?

In the search <LS>Specification contains components</>, you can choose
<LS>Cont. indirectly also</> only if you have entered a relationship
(technically MPROPO, PROPOR, or VPROPO) as a unit of measurement
dimension in the <LS>Ref. quantity</> field.
A multilevel component relationship cannot be summarized as a
single-level relationship if it contains a dimension that cannot be
interpreted as a percentage (for example, weight specified in
kilograms).
Example:
A substance A contains a substance B that contains a substance C. These
two component relationships have the following weights specified:
Substance A
|
| 10 kg
|
Substance B
|
| 20 kg
|
Substance C
From the data model it is not possible to determine how many kilograms
of substance C are contained in substance A without additional
information.

Error message extract from SAP system. Copyright SAP SE.

CM_SUB_INFOSYS036 - Details

• The SAP error message CM_SUB_INFOSYS036 typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when dealing with data modeling, particularly when working with InfoObjects and their relationships. The error message indicates that a certain operation or configuration is not allowed because it involves dimensions that are not compatible with the specified relationship type.
  
  Cause:
  The error message "Contained indirectly also is only possible with dimension 'relationship'" suggests that you are trying to create or modify a data model or InfoProvider that involves dimensions that cannot be linked in the way you are attempting. Specifically, it indicates that the relationship you are trying to establish is not valid for the dimensions involved.
  Possible Causes:
  
  Incorrect Dimension Type: You may be trying to use a dimension that is not defined as a "relationship" dimension.
  Modeling Restrictions: There may be restrictions in the data model that prevent certain types of relationships from being established.
  Hierarchy