Skip to Content
0
Former Member
Jul 24, 2014 at 02:06 PM

BW on Hana - Composite Provider - Slow performance

1057 Views

Hello experts,

I'm doing an implementation with BW on Hana ( 7.3 ). In our case we created many composite providers to join DSOs we have created.

I don't understand the inner structure of Composite providers but I can see in Hana that BW creates many views.

0BW:RST:BIP:ZMM_CP02.0BW:RST:BIP:ZMM_CP02

0BW:RST:BIP:ZMM_CP02.AGGR0001

0BW:RST:BIP:ZMM_CP02.AGGR0002

0BW:RST:BIP:ZMM_CP02.AGGR0003

0BW:RST:BIP:ZMM_CP02.AGGR0004

0BW:RST:BIP:ZMM_CP02.JOIN0001

0BW:RST:BIP:ZMM_CP02.JOIN0002

0BW:RST:BIP:ZMM_CP02.JOIN0003

0BW:RST:BIP:ZMM_CP02.UNION

If I create a SQL statement manually direct in Hana with necessary inner/outer joins, the query is extremely fast, even in table with tens of millions of records. But the composite provider does not have the same performance at all. I almost sure it's because of this many views BW creates.


Does anyone have already gone through this situation and how to tune it ?


Many thanks,