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

As I can see the concistency check only checks for surrounding blanks in the variable names, not in the data itself... (which is the problem)

Hi,
These features has not been modified, but anyway the problem is not the datasource. It is in Answers that the blank characters are removed.

Problem is that I would have to do this for every attribute I have and that is not what I want.. I want Answers to NOT trim the values, because that will make an indifference with the physical value.

Ok, you are probably right. This is actually a common problem to be aware of because it can give wrong results, especially when doing drill downs.

Do you have any suggested to this? Adding a TRIM to all attributes seems a bit "dirty", also for performance.