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.
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 ?