2457846 - A constraint of the dimension, which can't be aggregated, is violated error in SAP Analytics Cloud

SAP Knowledge Base Article - Public

2457846 - A constraint of the dimension, which can't be aggregated, is violated error in SAP Analytics Cloud

Symptom

The following error occurs in SAP Analytics Cloud:

A constraint of the dimension, which can't be aggregated, is violated

Dimension must be in an axis or filter a single member.

These dimensions must not be aggregated, but are not in drill or filtered by a single member.

Full Error:

[Warning [Server]:(#42758) A constraint of the dimension which can't be aggregated, is violated

Type: 1,

Number: 42758,

Text: A constraint of the dimension, which can't be aggregated, is violated: : These dimensions must not be aggregated, but are not in drill or filtered by a single member

The following error message is returned in the response:

"Type": 1,
"Number": 42758"
"Text": "A constraint of the dimension, which can't be aggregated, is violated: : 'sap.fpa_data:M000_10_Accounts' must be in an axis or filter a single member."

"Type": 1,
"Number": 42758,
"Text": "A constraint of the dimension, which can't be aggregated, is violated: : These dimensions must not be aggregated, but are not in drill or filtered by a single member: [sap.fpa_data:M000_10_Accounts, sap.fpa_data:M000_10_OpInc_Version]"

Environment

  • SAP Analytics Cloud

Cause

This error occurs based on two possible conditions:

  1. A Custom Dimension with more than one Member is on the free axis (No Axis / None) and there is no filter on the Customer Dimension to reduce to one Member.
    • If a custom dimension 1 is put on the free axis (No Axis / None), there has to be a filter on that single custom dimension 1 member or the custom dimension 1 can only contain a single member (otherwise the dimension would have to be aggregated which is not possible)
  2. Account and Version / Category Dimensions are not in the table structure (Row / Column / Filter).
    • This is not valid, as the account/version dimensions have to be referenced either on the rows or columns or alternatively there has to be a filter on a single account/version member. This is because these dimensions cannot be aggregated.

Resolution

Prior to 2017.06

  1. Add a filter to your Custom Dimension used on the free axis (No Axis / None) to choose only one member.
  2. Add Account and Version / Category Dimensions to the table structure (Row / Column / Filter)

Should not cause an error in 2017.06 and later

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0