Loading

Dimension Filter Values for Data Sources Containing an Inner Join

Дата публикации: Apr 21, 2026
Описание

When used with a data source that has an inner join, an interactive filter shows the domain from the underlying table (all values in database), instead of the values that result from the inner join.

Решение
To limit the filter values to just those resulting from the inner join, try the following workaround:

1. Create a calculated field [Show Relevant Data] using the following calculation (where [Order ID] is the field used for the filter): 
IF ISNULL([Order ID]) THEN FALSE ELSE TRUE END

2. Drag [Show Relevant Data] to the Filters shelf, select 'True' and click 'OK'.

3. Right-click [Show Relevant Data] on the Filters shelf, and select 'Add to Context'.

4. Select the 'All Values in Context' option for the filter card.
Номер статьи базы знаний

001471434

 
Загрузка
Salesforce Help | Article