3691223 - Dynamic filter pushdown for local table or remote table in SAP Datasphere when using DP agent

It is observed that there is no "Dynamic filter" option in "Local table" or "Remote table" in SAP Datasphere.

Or when using Dynamic filter projection there is memory issue like this : 

"DBS-070407: |Reader *** SQL submitted to database <> resulted in error <General error;403 internal error: Error opening the cursor for the remote database <***> No more memory available to add rows to an internal table."

• SAP Datasphere

Select filter for local table or remote table.

This is known limitation.

• Refer to SAP Note 3320662 - Date calculation in filter in SAP Datasphere for guidance on handling dynamic date filters.
• As a workaround please check the blogs mentioned in see also.

SAP Datasphere - Remote Table dynamic filter pushd... - SAP Community

Dynamic filter push down in SAP Datasphere - reyemsaibot

dataflow failure, dynamic date filter, sap datasphere, ecc data extraction, projection node, DBS-070407, DBS-054003, data flow error, dynamic filter pushdown, local table, date calculation, error opening cursor, no memory available, internal table error, sap note 3320662, workaround , KBA , DS-DI-RT , Remote Tables , Problem