Loading

Dimension Filter Values for Data Sources Containing an Inner Join

Julkaisupäivä: Apr 21, 2026
Kuvaus

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.

Ratkaisu
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.
Knowledge-artikkelin numero

001471434

 
Ladataan
Salesforce Help | Article