EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB217869: How does the VLDB property ‘Filtering on String Values’ under Analytical Engine work?


Community Admin

• Strategy


The VLDB property ‘Analytical Engine > ‘Filtering on String Values’ determines whether filters consider trailing spaces in attribute elements when filtering data in MicroStrategy.

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
'/'||CT_NAME||'/'CT_SALARY/James/22500/James /32500

2021
'/'||CT_NAME||'/'CT_SALARY/James/22500/James /32500

2021
'/'||CT_NAME||'/'CT_SALARY/James/22500/James /32500

2021
'/'||CT_NAME||'/'CT_SALARY/James/22500/James /32500

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:

ka0PW00000013a9YAA_0EM440000002CCk.jpeg
ka0PW00000013a9YAA_0EM440000002CCu.jpeg

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:

ka0PW00000013a9YAA_0EM440000002CCv.jpeg
ka0PW00000013a9YAA_0EM440000002CCx.jpeg

Comment

0 comments

Details

Knowledge Article

Published:

April 20, 2017

Last Updated:

March 4, 2024