Skip to Content
0
Former Member
May 10, 2018 at 06:11 PM

Bex Query Filter push down to HANA calculation views

1393 Views Last edit May 16, 2018 at 11:38 AM 2 rev

Hi,

We are currently using BW on HANA 7.4 SP 19. We have a composite provider which is built on top of multiple aDSO's and one HANA calculation view. When we execute the Bex report (built on top of this composite provider) it takes more than 5 minutes to retrieve the results.

We think this could be because Bex query could not pass the filter (Fiscal year) to HANA calculation view base projection tables (Has million of records).

So question is, in this scenario does Bex automatically pass filters to HANA calculation view? Is there a way to confirm?

Thanks