October 16, 2005 at 4:43 am
Hi folks,
I have the September CTP and am getting the following error while processing a cube.
Column 9 of the Sales table is Cost which is Decimal(15,2) NOT NULL.
The internal type of the Cost measure is "double".
Any ideas???
"Errors in the back-end database access module. OLE DB was unable to convert a value to the data type requested for column 9. Errors in the OLAP storage engine: An error occurred while processing the 'Sales' partition of the 'Sales' measure group for the 'Sales' cube from the SalesReporting database."
October 19, 2005 at 8:00 am
This was removed by the editor as SPAM
March 1, 2011 at 8:09 am
Are you using a view for one of the tables involved? I had this problem where I was using a view during prototyping like "SELECT Service_Site, L4_Code FROM Service_Site" as a bridge "table" for a many-to-many relationship. Service_Site was integer and L4_Code was char(2) in both of the related dimension tables. So there should not have been a problem but I was able to resolve the issue by explicitly casting the L4_Code column by changing the view to read "SELECT Service_Site, CAST(L4_Code AS char(2)) AS L4_Code FROM Service_Site".
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply