Composite Provider / Bex Aggregation

[Former Member]

I have a Composite Provider with the correct data granularity when displayed

I have a BEX Query on this Composite Provider that does not aggregate the key figure to 7184 but displays the incorrect total of 3592. I have never experienced this historically on Cubes or Multi providers but only on this new Composite Provider. Any ideas?

[former_member274922]

Hi,

did you already check the following decision tree?

Troubleshooting Bex Queries on HANA Composite Provider (HCPR)

WIKI Page (Composite Provider):
https://wiki.scn.sap.com/wiki/x/HIBeFw

Regards,
Matthias

[vijay_velpula2]

Hi,

Hope you have found answer for this Issue.

Please share.

Regards,

Vijay

[GJ_SAN]

Hi,

I'm having a similar issue. Did you find the root cause?

Thanks,

Graham

[former_member241393]

Hi John,

Please used "Calculation" in Bex as "Summation" for the Key Figure 0SUBTOTAL_1

If Not work, then do Exception Aggregation on Key Figure 0SUBTOTAL_1 as Summation and In reference Characteristic put "0KNART" .

Regards,

Bhanu