aggregation issue in SAP analytics cloud

[former_member776672]

Hi SAC Experts,

I am Facing aggregation issue in SAP analytics cloud in my scenarios. Here, my model is consuming live data from Cloud Foundary Hana and we are trying to calculate three fields in Hana which are Total Time, No of Entries and Average Time.

Here Average Calculation is Total Time divide by No of Entries.

Now when we enable Input Control (with multiple selections) field which is a day range field like (0-30,31-60,61-90 and so on). we get correct output of average time when we have all check boxes enabled. we also get correct output when we have single check box enabled. we only get issue when we select multiple check boxes.

When select multiple check boxes what it does, it just summed up (average time) from individual range in the output, which should not be the case. what it should do, it should be like (sum of Total Time(diff_time)/sum of No of Entries(Count_en)) for selected range(refer screen shot 4).

I tried with exception aggregation at SAC for day range field, but it is also not giving expected results. Attaching screen shot for reference.

Please help me with more aggregation concept in SAC.

Note: we are getting correct data at Hana output.

Very Thankful,

Heena Varnwal

[AnnaBurkhardt]

Hi Heena,

to be able to help you it would be helpful to see all the calculations you have defined in SAC that are used for the scenario. Otherwise it is difficult to understand what you actually did.

Above you also said "we are trying to calculate three fields in Hana". Are you doing the calculations on HANA side or on SAC side?

Cheers

Anna

[former_member776672]

Hi Anna,

Thank you for your response and sorry for making it difficult !

FYI, all calculations are performed in CF Hana at aggregation node. we are just fetching all dimensions/measures via live connection. I feel like this is an aggregation issue. In SAC, Hana calculated columns are working same as calculation before aggregation concept (even calculations are performed at Aggregated node in Hana) but it should work like calculation after aggregation.

Today, I tried implementing same calculations in SAC. and tested with my scenario day range(Input control), calculations seems to be working fine for single, multiple and all check boxes. But I have to test it with more scenarios.

Let see, how it goes. hoping for the best 🙂

Thanks Again,

Heena Varnwal