I am trying to set a filter on a remote table (FDA).
The remote table is connected with the recipient table in a 1:N relationship:
Now I want to set a filter on the remote table:
And get the following error:
When I set up a selection with the remote table as the filtering dimension, it works.
But I want to set the filter in the interaction engine and there is no filtering dimension, so I want to set the filter directly on the remote table.
Do you know why I get this error?
It is generally recommended not to perform:
This is for performance reasons mostly and the reason why it is working better when working on a different filtering dimension.
I'd recommend to try by applying the recommendations mentioned here: Accessing an external database.
Also, can you share your server and console versions?
Please let me know how it goes,