Skip to Content
0
Former Member
Oct 08, 2009 at 07:42 AM

Usage of exception aggregation affecting query performance

28 Views

Hi Guys,

I am facing a BEx query performance issue. There is one query which is taking almost 3hrs to execute. This query is based on a multiprovider which inturn is a combination of various infosets (Cube+DSO using left outer join).

There is one execption aggregation based on one characterisitc applied on one of the KF in Bex query. However if I remove this particular KF then query throws the output within 10mins.

Any idea how can I replace this exception aggregation functionality with something else?

Pls advice.

Regards,

Ashu.