1 Reply Latest reply on Feb 7, 2013 9:41 AM by sayak

    Trailing spaces getting trimmed


      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

      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.