Since Strategy Analytical Engine 9.3.1, the VLDB property ‘Analytical Engine > ‘Filtering on String Values’ has been available at project level.
This property determines whether filters consider trailing spaces in attribute elements when filtering data in Strategy.
Consider that an Attribute is defined based on the below table, the second row data has a space at the end, as shown in the table below:
2021 | 2021 |
2021 | 2021 |
Note: The above table was defined just for the purpose of this example and is not a recommended model.
This VLDB property has the following options:
Do not trim trailing spaces : Attribute elements that include trailing spaces can be returned as separate attribute elements when filtering on the attribute as shown in the image below:


Trim trailing spaces (default): Attribute elements that include trailing spaces are not returned as separate attribute elements when filtering on the attribute as shown in the image below:

