Remove ‘Count’ Aggregation in Data Sources created using SDK

Currently developers can create custom data source using SAP Cloud Applications Studio and use the Count Aggregation method for data types like numeric, amount etc.

However, the ‘Count’ aggregation method in a data source is not supported by the analytics framework. It is only supported in the analytics report. Moreover, the current implementation of count aggregation is similar to the Summation aggregation method. Hence, with 1902, it will not be supported any more. Customers and Partners are required to adapt their solutions before 1902 and remove the use the ‘Count’ aggregation from their custom data source.

With the 1808 release on wards, if developers are creating new custom data source using SDK, they will no longer be able to select the Count for key figures.

For existing solutions which are in the maintenance mode, customers will need to change their custom data source and remove the count aggregation. They can either use the Summation aggregation (if not already used for another key figure) or use the count key figure on the report created for the data source.

Steps to remove ‘Count’ Aggregation in Data Source created in existing SDK solutions

Prerequisites: The key figure with count aggregation should be removed from the join data source (one or both data sources are SDK created data source)

1. A developer will get the error message on opening a data source, if it already has a ‘Count’ aggregation (added in previous version).

2.Select the Aggregation tab and click on Delete button for the ‘Count’ aggregation method. It will be indicated with a red error icon.

3.Alternatively, you can select the ‘Summation’ aggregation if no other key figure is defined with this aggregation method. Currently the count aggregation method behaves like the summation aggregation method.

4.Count aggregation can also be use directly on the report built on top of the data source.