Filtering on FDA tables

[timg96297954]

Hi guys,

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?

Kind regards

Tim

Merken

[florentlb · Accepted solution]

Hi Tim,

It is generally recommended not to perform:

• queries on high volume 1-N related tables
• queries on 1-N related tables connected through FDA

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,

Florent.