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