Skip to Content
Former Member
Jun 10, 2008 at 10:20 PM

11.5 OLAP Query to SSAS 2005


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)

<Value xsi:type="xsd:double">3.396E4</Value>

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.