Showing posts with label mining. Show all posts
Showing posts with label mining. Show all posts
Wednesday, March 21, 2012
error creating named calculation
I'm new to MS DM and am using the book "Data Mining with SQL Server 2005" by Wiley. On page 95 I try to follow the procedure for creating a named calculation, but I get this error: IErrorInfo.GetDescription failed with E_FAIL(0x80004005). Any ideas what's wrong?Can you provide some more details? Are you using Access or SQL as your source database?|||Jamie, Thanks for the help. I'm using the Access MovieClick DB that I downloaded from the Wiley web site. Also, I can create other named calculations just fine, such as adding two columns, or taking the log of one. It just seems to be the CASE examples that give me the error.|||You need to import the data into a SQL Server database using the instructions in the text before using the named calculations.|||Thanks! For those not wanting to convert the Access DB to SQL Server, you can use the Access code =IIF([Num Bedrooms] = 1, 'One',IIF([Num Bedrooms] <=3, 'Two or three',IIF([Num Bedrooms] >= 4, 'Four or more')))sql
Subscribe to:
Posts (Atom)