SAP Knowledge Base Article - Public

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


A measure is created with exception aggregation AVG (average) by including all dimensions.  The exception aggregation does not properly apply when you input data at the leaf or node level.

When the value has directly been input at a higher node level, the same value is treated as average (avg.) aggregation, as expected, and according to the exception aggregation settings, the value gets changed at base member level at same proportion.  The average at higher node level is the same with what you input.

When you select another dimension (for example, products) base level (leaf/child) members in a page level filter and repeat the same activity of changing data values, the distribution of the input value to the filtered members changes to average at top node (parent) level. 


SAP Analytics Cloud (Enterprise)


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