Microsoft SQL Server Analysis Services problems with floating point datatypes
I cannot add a Double measure in a cube, in MOLAP or ROLAP: every attempt to read a Money/Numeric/Float value from Vertica throws an ADO.NET exception: Errors in the high-level relational engine. The following exception occurred while the managed IDataReader interface was being used: Input string was not in a correct format.. Errors in the OLAP storage engine: An error occurred while processing the 'Fact Campaign Event Summary' partition of the 'Campaign Events' measure group for the 'CriteOlap' cube from the CriteOlap database. It may be an issue with the Vertica.xsl cartridge - that maps SSAS types to Vertica - you provide as part of the ADO.NET installer, I'll try to edit it and let you know. But if anyone has tested it... Please let me know.