Filtering on FDA tables

Avatar

Avatar

timg96297954

Avatar

timg96297954

timg96297954

26-06-2017

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:

1237744_pastedImage_0.png

Now I want to set a filter on the remote table:

1237745_pastedImage_1.png

And get the following error:

1237746_pastedImage_2.png

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

florentlb

Total Posts

1.1K

Likes

234

Correct Answer

239

Avatar

florentlb

Total Posts

1.1K

Likes

234

Correct Answer

239
florentlb

03-07-2017

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.

Answers (0)