Filtering on FDA tables | Community
Skip to main content
T
timg96297954
Level 2
June 26, 2017
Solved

Filtering on FDA tables

  • June 26, 2017
  • 1 reply
  • 1064 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by florentlb

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.

1 reply

florentlb
florentlbAccepted solution
Level 10
July 3, 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.

Terms & ConditionsAccessibility statement

Loading footer...