Question Re: How to use Aggregation function in a table in Technology Q&A

How to use Aggregation function in a table

former_member691645 — Thu, 10 Sep 2020 15:43:07 GMT

Hey,

I am curious about how to use the aggregation function within a table in a story to calculate the average value of a certain measure over time where time acts as dimension.

When I open the fx editor within the measures I don't get the "Aggregation" option in the dropdown. If I open the "Add measure" dropdown I am not able to create a new measure from calculation (other than in this tutorial)

So how to come about it? Note that the option is well available once I switch to a barchart e.g.

Re: How to use Aggregation function in a table

Ashok_R — Thu, 10 Sep 2020 16:45:32 GMT

Hi Jonas,

which is the datasource are you trying to access here?

Regards,

Ashok R

Re: How to use Aggregation function in a table

former_member691645 — Fri, 11 Sep 2020 07:22:03 GMT

Hey Ashok,

the table is linked to a model which itself queries the data via a live connection from CB1/BW.

Regards,

Jonas

Re: How to use Aggregation function in a table

former_member6443 — Fri, 11 Sep 2020 08:42:39 GMT

Hi Jonas,

To get the Exception Aggregation and Aggregation you will need to highlight on the measures and then ... ( 3 dots ) which will then give you the option and then this can be displayed in the grid.

Good Luck

Afshin

Re: How to use Aggregation function in a table

former_member691645 — Fri, 11 Sep 2020 08:58:38 GMT

Thanks for your reply. Somehow it doesn't seem to work, could you please again guide me more specifically.

So I hover the Measures and get the three point icon:

Then clicking it I get the following dropdown:

hen going to "Add Calculation" I end up in the fx editor which then doesn't offer me the "Aggregation" function as shown in my initial post.

Looking forward to your reply.

Thanks and kind regards, Jonas

Re: How to use Aggregation function in a table

former_member6443 — Fri, 11 Sep 2020 09:12:43 GMT

Hi Jonas,

Click on Add Calculation and you should see something like this,

Suggest Live Models you do in the HANA side

Regards

Afshin

Re: How to use Aggregation function in a table

former_member6443 — Fri, 11 Sep 2020 09:25:12 GMT

Sorry the Image that did not come through.

image.png

Re: How to use Aggregation function in a table

former_member691645 — Fri, 11 Sep 2020 11:46:29 GMT

Hey,

this is where I end up then:

Which is a totally different dialogue and it doesn't offer the "aggregation" function at all.

Kind regards,

Jonas

Re: How to use Aggregation function in a table

former_member6443 — Thu, 17 Sep 2020 10:44:40 GMT

Hi,

I suspect you did not click on the measures .. I can see this is done on the dimension Calendar Day.

Cheers

Afshin

Re: How to use Aggregation function in a table

horynao — Thu, 17 Sep 2020 12:58:51 GMT

Hello, if you try to do it all under data import, is it all right? SAC like live connection from S4/HANA mostly. Other live conn have some issues.. For examle I didnt even calculate percentage under live data from SAP Universe.. aggregation was possible.

Also you could look to support matrix, if you connection is not old version SAC Wiki.

Good luck

Ondrej