We have a table in SQL Server 2005 with a varchar field (Dept_Name). The Dept_Name field is having values with trailing spaces (e.g., 'dept1 ','dept1' etc). When we are importing the table in OBIEE physical layer, the trailing spaces are getting trimmed. So 'dept1 ' is becoming 'dept1'. This is causing data errors in our reports. The OBIEE version is 10.1.3.4.1.
I am wondering if this is a bug or there is any configurable parameter at OBIEE end to do this trimming ? Any help will be highly appreciated.