Loading

Dimension Filter Values for Data Sources Containing an Inner Join

Date de publication: Apr 21, 2026
Description

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.

Résolution
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.
Numéro d’article de la base de connaissances

001471434

 
Chargement
Salesforce Help | Article