How to have same level of aggregation in BW4HANA reporting preview and SAP SAC

[bouirik73]

Hello,

First of all I'll describe the problem, I have a difference in type of aggregation of key figures between bw4hana reporting view and SAP SAC in many queries which are based on a composite provider where I have a left outer join between two ADSO

Here is an example of data that I have, the problem is that I don't have a key wich identifies unique lines in left ADSO , in BW4hana reporting preview take this into consideration and take just one value of the repeated lines, But in SAC take the sum of all repeated lines, I tried to create other key figures in the sac with Max aggregation but it's become complex when I used these key figures to calculate others with periodic aggregation ......

he result in a BW4HANA reporting preview seems like the picture below

The result in SAC seems like the picture below

I think the difference is because SAC takes all fields as Key

How can I achieve the same result in both sides without using aggregation in SAC?

Kind regards,

[N1kh1l]

bouirik

How are you joining in SAC. Is it a story blending between 2 models or you are doing the join in Data Wrangling of SAC in one model itself? I think as there are no unique fields, mapping of fields 1 to Field 5 will return more than one record from right ADSO and left ADSO records will get repeated which will cause wrong aggregation.

Nikhil

[bouirik73]

There is just one model in my case because i did all the data joining in bw4hana and i consume the model via a query

[SimonVanHerck]

Hi Achraf,

You can achieve your desired result via Exception Aggregation in the Query.

FYI:

https://blogs.sap.com/2014/02/16/how-to-utilize-exception-aggregation-using-bex-query-designer/

https://blogs.sap.com/2017/08/28/understanding-exception-aggregation-via-examples/

With best regards,

Simon | Cubis