I am trying to build a data cube from a database on Informix using Microsoft analysis services on SQL Server 7.0. At present i am trying to connect the cube to Informix database through system DSN using ODBC driver for Informix version 3.33. When the analysis manager starts processing my cube, it errors for all the columns on my fact table by saying that "It cannot convert the column...". My fact table is based on a table in Informix database and all the column indicated are defined as datatype DECIMAL(16,2).
I think either there is some problem with the right driver I need on the SQL Server to connect cube to Informix or there is some problem with Microsoft analysis manager in processing Informix data for cube.
I will appreciate if anyone can help me out with the right approach to create the cube.