March 1, 2010 at 1:00 pm
Guys I'm having problems redeploying an Analysis Services Cube the original cube was deployed on SQL Server 2005 X32 I'm wanting to move it over to our new servers that are running SQL Server 2008 X64. The SQL Server 2005 box has a dblink back to Oracle I've also created the same dblink on the SQL 2008 boxes. Also the 2005 has the 32 bit Oracle clients installed while the 64 bit server runs the 64 bit Oracle clinet. The SQL database has several views in it that were generated from Oracle tables. I've backed up and restored the SQL database after that I backed up and restored the cube to analysis services. However if I try to process the cube it kicks out the below errors. I'm confused because this runs fine on the SQL Server 2005 boxes. I actually copied the SQL code from the analysis services error box ran it in analyzer and still received the below Operand error.So any help with this one would be much appreciated
OLE DB error: OLE DB or ODBC error: Operand data type nvarchar is invalid for subtract operator.; 42000.
Errors in the OLAP storage engine: An error occurred while processing the 'Current Facts' partition of the 'Current Facts' measure group for the 'CurrentSales' cube from the CurrentSales AS database.
March 4, 2010 at 2:07 pm
Sounds like there is a calculated member that is trying to perform a subtraction using a string
March 4, 2010 at 3:08 pm
Any chance of posting the SQL? Would make it significantly easier to try and determine the cause.
Also, not sure if you tried, but dobule-clicking the error in SSMS will (often, not always) take you to the offending line in the code.
Steve.
March 9, 2010 at 5:32 am
Daniel Hallam (3/4/2010)
Sounds like there is a calculated member that is trying to perform a subtraction using a string
Or a named calculation in the DSV...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply