We are working on a project where data from a cloud system is read to BWoH system on the fly. This data from the remote system is then joined with BW data and made available for third party access.
When third party system try to access the data from the view which pull data on the fly from remote system and BW. We could see in some instances the filters are not pushed to remote system and entire tables gets loaded to memory in HANA.
We want to understand if there are any parameters that can be maintained in the system which will allow filters to be pushed to remote system and consume limited memory
We are currently on BW 7.4 SP7 & HANA SPS 10.
Any other ideas to help fix this issue will be appreciated