Loading

Dimension Filter Values for Data Sources Containing an Inner Join

Publiseringsdato: Apr 21, 2026
Beskrivelse

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.

Løsning
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-artikkelnummer

001471434

 
Laster
Salesforce Help | Article