Influence the behavior of the value filter.
Posted: Wed Jan 08, 2025 4:23 am
When filtering multiple columns from the same table, the current default behavior combines these filters into one, considering only existing combinations. For example, if you have a “Year” column with values like “2023” and a “Month” column with values like “January 2024,” filtering on both columns will only consider valid combinations. The combination of the month January 2024 with the year 2023 does not exist and therefore would not be included in the filter. However, there are situations where the results can be surprising.
This month, we introduced the option to control this behavior in your semantic model using the “Value Filter Behavior” setting in the model view properties panel. There are three options available:
Automatic: This is the default setting and currently enables the Merged behavior. When this preview ends, new models set to “Automatic” will use Standalone; there will be an announcement at that time.
Independent: This option forces filters on the senegal whatsapp resource same table to be kept separate. After setting the “Value Filter Behavior” option to “Independent”, filters will not be combined.
Merged: This option enables merged values filter behavior for the semantic model, combining filters from the same table into one.
It is important to note that setting the “Value Filter Behavior” to Automatic currently equates to Merged, but will be changed to Independent for new semantic models in the future.
Data connectivity
Snowflake Connector Updates
The driver used by the Snowflake connector is updated to the latest version to achieve incremental improvements.
The Snowflake connector has improved performance by reducing metadata queries when they are not needed.
This month, we introduced the option to control this behavior in your semantic model using the “Value Filter Behavior” setting in the model view properties panel. There are three options available:
Automatic: This is the default setting and currently enables the Merged behavior. When this preview ends, new models set to “Automatic” will use Standalone; there will be an announcement at that time.
Independent: This option forces filters on the senegal whatsapp resource same table to be kept separate. After setting the “Value Filter Behavior” option to “Independent”, filters will not be combined.
Merged: This option enables merged values filter behavior for the semantic model, combining filters from the same table into one.
It is important to note that setting the “Value Filter Behavior” to Automatic currently equates to Merged, but will be changed to Independent for new semantic models in the future.
Data connectivity
Snowflake Connector Updates
The driver used by the Snowflake connector is updated to the latest version to achieve incremental improvements.
The Snowflake connector has improved performance by reducing metadata queries when they are not needed.