Skip to Content
3

Is there a way to aggregate values on SAP Smart Business in SCP?

Apr 28, 2017 at 08:03 PM

81

avatar image

I have an entity set created that has multiple transactions. For each transaction, there is a gross value and a customer number associated with the transaction. I would like to use SAP Smart Business to view this table and create a tile that aggregates the gross value of each customer. I could then rank the customers by gross value. Currently, it appears I can only report on an individual line of the data set. Please let me know if this is possible.

Below is an example data set:

I'd like to use an SAP Smart Business in SCP and this entity set to generate a tile that would display something like the following:

Thanks!!

Lane

data-set.png (68.1 kB)
report-outcome.png (43.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Shaik Imtiyaz Shariff
May 02, 2017 at 06:28 AM
2

Hello Colleague,

To answer in short, if data is persisted on HANA, you can use calc view to project the Odata - this will auto aggregate.

Smart Business does not deal with data aggregation. We consume Odata service that provides us the aggregated data and visualize in the form analytical charts.

Hope this clarifies.

Thanks & Regards, Imtiyaz

Share
10 |10000 characters needed characters left characters exceeded