|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 errors in back-end database Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 1/21/2006 1:20:11 PM 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 'Suppliers Fact' partition of the 'Suppliers Fact' measure group for the 'Suppliers Zara Cube' cube f...more >>
RE: Errors in the back-end database access module. OLE DB was unable to convert a value to the data type requested for column Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 1/21/2006 1:20:06 PM >
> I am new to time series,
> I trying to build a time series model on real estate search data.
> I have basically built a mining structure with a datetime keyTime and StateCode which a text as Key
>
> rest of the fields are input/Predict
>
> Below are part of the errors given below. Kin...more >>
how to create data source Posted by maxzsim via SQLMonster.com at 1/20/2006 9:06:12 AM Hi ,
I am just starting to use the SQL Server 2000 Analysis Services. I have
created a data source but i did not save the password as i was "told" by the
system that "it's unsafe as the password stored will be unencrypted"
However, when i tried to create a cube , it says login failed but th...more >>
Creating and dropping models using SQL Posted by Erik at 1/18/2006 9:20:07 PM Hi,
Is it only possible to execute SELECT DMX statements from SQL via 'OPENQUERY'? I would like to do things like this;
SELECT * FROM OPENQUERY(ASLOCAL,
'DROP Mining Structure sGLDetCostDebet')
But I get this error message;
"The OLE DB provider "MSOLAP.3" for linked server "ASLOCAL" in...more >>
Score via DMX Posted by Erik at 1/17/2006 10:00:12 PM Hi,
Is it possible in someway to execute some DMX statement against a trained model and recive a "score" or a measure, or anything, that describes how well the model will perform predicting?
I would like to be able to compare many models using code and DMX,
/Erik...more >>
SSIS for processing cubes Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 1/17/2006 10:00:06 PM Are there any examples, information to build a SSIS package to process the cubes/mining models ?...more >>
creating data mining objects using DMX language Posted by ziga at 1/17/2006 8:40:11 PM Hi!
I am creating mining structures and mining models using DMX language.
First I create Mining model, for example:
CREATE MINING MODEL [myModel]
( list of attributes, content types, data types...) USING SomeAlgorithm (AlgParameters)
It also creates a MINING STRUCTURE called MyModel_Structu...more >>
Leave-One-Out Cross Validation Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 1/16/2006 7:40:11 PM Hi,
Are there any provisions/methods for performing Leave-One-Out N-Fold cross validation of mining models? Say I do not have enough observations to create separate Training & Test sets. Therefore, to get a good idea of the error rate of my classifier, I may want/wish to hold out 10 observations,...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Having trouble sorting numerical data from SQL analysis cube Posted by Andy S. at 1/16/2006 6:08:05 PM I've built a cube with a numerical dimension in SQL 2000 analysis
services. When I add that dimension as a column, it sorts as follows
1
10
100
2
20
instead of
1
2
10
20
100
I've tried doing a sort in Excel 2003 and 2000, even setting the type as
Number. In Analysis servi...more >>
How to change Storage location of SSAS Database Instance Posted by vplusplus NO[at]SPAM hotmail.com.NOSPAM at 1/15/2006 11:40:15 PM Platform: SQL Server 2005 Analysis Services on W2K3
While creating regular databases, I know how to change the storage location of database files.
By default SSAS2005 points
"C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data"
I can see this when I right-click SSAS Database and view ...more >>
Need help on SQL2005 Posted by vplusplus NO[at]SPAM hotmail.com.NOSPAM at 1/15/2006 11:40:10 PM Got the following error while creating Time Dimension.
Using W2K3, SQL Server 2005, Visual Studio 2005.
Source database and target SSAS Database are all on my local workstation.
Unlike treditional Visual Studio projects, I do not see add references option for Analysis Services Projects.
Wi...more >>
Executing DMX Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 1/15/2006 10:20:07 PM Hi,
What is the easiest way of getting the result of a prediction query saved into a table using only SQL? I want to build a normal database stored procedure, that executes a DMX statement, and saves the result into a table.
/Erik...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |