I have successfully connected and queried data from a SQL Server Analysis Services 2005 database. My problem is that all data of DOUBLE or DECIMAL data type does not show the proper precision.
From the log, I can see that SSAS 2005 is returning (for example)
referring to 33,960. The Lighthammer OLAP driver, however, does not appear to be recognizing the "E" and simply returns 3.396.
Does anyone know a workaround for this issue? Is the OLAP driver supported with SSAS 2005? Any help is appreciated.