Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    May 02, 2017 at 06:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded