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.
Dave