Exception Aggregation Poor Performance

[Former Member]

Hello,

We have BW on HANA system implemented and we have a simple BEX query where we are using use exception aggreation count but the BEX query performance is very poor. When we try to query count directly from hana db, result comes immediately. According to help, counter type exception aggregation is supported by HANA and we are running bw on hana 7.4. I have taken a look at all OSS notes but couldnt find any useful info. Can you please help me with this issue?

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/4b/bda228a8b43c22e10000000a42189b/frameset.htm

Thanks,

Regards.

[Former Member]

Murat,

Check below blog for more information on query execution mode settings...

What execution mode you are using ?

Thanks & Regards,

Anup Singh

[Former Member]

Thanks for your reply Anup,

I am using “Mode 6 – Exception Aggregation”.