bigint datatype conversion to OBIEE
722156Oct 21 2010 — edited Dec 2 2010I am trying to source data from SQL Server database and one of the fields in the table is defined as bigint datatype. when I import the table in OBIEE, it changes the datatype to Double. however the data does not get converted right. data shows up as *1025710002331167400.* instead of *1025710002331167428* replacing last 2 digits with "00.". I tried changing the datatype in OBIEE to Varchar but did not work. I am using ODBC 3.5 to connect to SQL Server database. Is there any work around to make this thing work. Changing the datatype in SQL Server database is not an option.