SAP Knowledge Base Article - Public

2457906 - How to create measures with average aggregation using HANA Live Data Connection in SAP BusinessObjects Cloud


  • In SAP BusinessObjects Cloud you create a model using HANA Calculation view.
  • The only aggregation types available are: SUM, MIN, MAX, NONE


  • SAP BusinessObjects Cloud 2017.6

Reproducing the Issue

  1. Create a Calculation View using HANA on-premise or SAP Cloud Platform
  2. Create a new model using Live Data Connection. Select that view
  3. Even if you created the view using aggregation type AVG, the aggregation type displayed in the model is SUM


You need to create the aggregation Average in the model.


  1. Select Exception Aggregation Type: AVG
  2. Select Exception Aggregation Dimension: the dimension that will be used to calculate that average.

If you want to calculate the average sales in different regions, you need to decide which is the dimension that will be considered a single value for the average calculation: for example, a store.  If you explore your data in a country where you have 300 stores, it will use each store sales value as a single value to calculate the average for the country. If you drill down to province, it will recalculate the average sales for the province, for example 25 stores and so on. For this example the values would be:

Measure: Average sales per store:

  1. Exception Aggregation Type: AVG
  2. Aggregation Dimension: store

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.


HCP, SCP, HANA, view, average, AVG, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud , KBA , avg , boc , average , aggregation , businessobjects cloud , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem


SAP Analytics Cloud 1.0