SAP Knowledge Base Article - Public

3099882 - Exceptional aggregation AVG does not work as expected when filtering a dimension to base level members


A measure XXX is created with exceptional aggregation AVG by including all dimensions.  The exceptional aggregation does not properly apply  when you input data at node level.

When the value has directly been input at higher node level, same value is treated as Avg, as expected,  and accordingly to the exceptional aggregation setting , the value gets changed at base member level at same proportion.  Average at higher node level is same what you input. So far, no issue.

When you select few of the product ( for example) dimension base members in the page level filter and repeat the same activity of changing value. Story distributes the input value to the filtered members and changes Avg at top node level. 


SAP Analytics Cloud 2021.18.1


This issue is currently under investigation by development.


This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.


SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped
, KBA , LOD-ANA-PL , Planning , Problem


SAP Analytics Cloud 1.0