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.
[Warning [Server]:(#42758) A constraint of the dimension which can't be aggregated, is violated
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:
"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."
"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]"
- SAP Analytics Cloud
This error occurs based on two possible conditions:
- 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)
- 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.
Prior to 2017.06
- Add a filter to your Custom Dimension used on the free axis (No Axis / None) to choose only one member.
- Add Account and Version / Category Dimensions to the table structure (Row / Column / Filter)
Should not cause an error in 2017.06 and later
- Help resources
- Help portal
- SAP community network ( Questions & Answers / Direct Link to Create Question / Blogs )
- SAP community wiki
- Ideaplace forum ( for enhancement requests & new features )
- Video tutorials
- Videos by topic areas: ( Overview, What's New, Models and Connections, Stories, SAP Digital Boardroom, Planning, Predictive, Collaboration, Administration )
- Training events
- Past event recordings
- New user handbook
- How to connect to on-premise data
- Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)
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.
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