Analytics Software

It seems like Answers is removing leading and trailing blanks when it takes the values to the SQL. This is very "dangerous" because it means that it will not be able to find a value that in the database table is:
e.g.
"Short-term receivables " (one blank at the end)

when Answers take this to the SQL it removes the trailing blank and searches for this value:
"Short-term receivables" (no blanks!!)

e.g. it won't find this row when e.g. drilling down on details. This can be fixed by adding TRIM to alle Character values in the BI Server (or in the data warehouse) but I rather want Answers to include the blanks (performance etc.).

Is there any way to tell Answers to include blanks (or not remove them) ?

(There is a similar issue with capitalized letters, but that is another case :)