Error On Custom Data Mining Plugin: Content Type Mismatch
Jan 11, 2007
Good afternoon,
I'm doing a custom clustering plugin for text to pre-process ("clean" the texts), calculate weights, estimate the number of clusters (using the PBM index) and finally, do the actual clustering.
So... I've made each of these modules on C++ and I'm putting them all togheter on the plugin.
My database (MDB file) has only one table, with only two fields within: a key (auto-incremental) and a small text. What I intend to do is to get the text in each test case, store them togheter somewhere and call my classes to cluster these texts.
I'm trying to log the texts in a file (just a test) on the ProcessCase method, in the CaseProcessor class. I've did it with no problems with numerical data.
But when I load the MDB file on the Mining Structures Wizard, it says the content type of the field holding the texts is "Continous" and the data type is "Text". Actually, when I saw it I didn't really mind.
But when I run the mining model it gives me the following error: "Error 1 Error (Data mining): The data type of the Table1.Texto mining structure column must be numeric since it has a continuous content type (Content is set to Continuous or Key Time or Key Sequence). 0 0 "
So... How do I change this content type ? (the content type combobox on the Mining Structures Wizard couldn't the changed)
Can anyone help me on this, please ?
Thanks a lot.
View 6 Replies
ADVERTISEMENT
Jan 17, 2007
Good morning,
Well... As I said in other topics, I'm doing a clustering plugin for text mining. I'm facing many problems and, with your help, solving them one by one.
First of all, thanks a lot again.
Well... I've made a clustering function that is actually working very well. But I'm exporting its results to a log file I use as an algorithm trace for debugging.
My clustering method returns a vector containing information of what cluster each register belongs. For instance:
vector[0] = 1 -> The register of index 0 belongs to cluster 1.
vector[1] = 9 -> The register of index 1 belongs to cluster 9.
vector[2] = 2 -> The register of index 2 belongs to cluster 2.
...
And so on.
But... I know that none of the Navigation methods receives a structure like this one discribed above. I only use it to log the results to debug the algorithm.
But how to pass this information (what register (or test case) belongs to what cluster) to the Navigation ?
Thanks a lot again, and any help will be very appreciated.
View 1 Replies
View Related
Dec 20, 2006
I'm stucked in a problem and I thought if you would be so kind as to helping me to resolve it.
I'm implementing a clustering algorithm plugin for text mining. I've already read the tutorials and sample codes provided by the MSDN Library.
Well... My problem is: I can't go through the data when the Predict method is called. I've read that this method implements the "core" of the custom algorithms. Here is a small snippet of my code for you to understand my doubt:
STDMETHODIMP ALGORITHM::Predict(/* [in] */ IDMContextServices* in_pContext,/* [in] */ DM_PREDICTION_FLAGS in_Flags,/* [in] */ IDMAttributeGroup* in_pPredAttGroup,/* [in] */ DM_CaseID in_CaseID, /* [in] */ ULONG in_ulCaseValues,/* [in] */ DM_ATTRIBUTE_VALUE* in_rgValues,/* [in] */ ULONG in_ulMaxPredictions,/* [in] */ ULONG in_ulMaxStates, /* [out] */ DM_ATTRIBUTE_STAT** io_prgPredictions,/* [out] */ ULONG* out_pulPredictions) {
for(UINT i=0;i<in_ulCaseValues;i++) {
DM_ATTRIBUTE_VALUE& dmattributevalue = in_rgValues;
ULONG iAttribute = dmattributevalue.Attribute;
if (iAttribute == DM_UNSPECIFIED)
continue;
double dblValue = ::DblContinuous(dmattributevalue.Value);
char buffer[129];
sprintf(buffer,"%f ",dblValue);
RENAN_Log::log(buffer);
}
return S_OK;
}
As you can see, I'm going through in_rgValues to get its values, but i'm only obtaining the first register of the table on the database. I need to roll over a kind of resultset so I could access all the registers I need. Is there any way to do so ?
I expected Predict() received a matrix containing all my data, but the only thing I noticed that could represent the data is that in_rgValues vector. So I can go through this vector, but it holds only the first register of the table in the database (that's what's being saved on my log). I need all of the registers in order to pre-process the data and implement my clustering algorithm.
Well... That's it... I would be very pleased if you could help me.
View 7 Replies
View Related
May 31, 2006
Hoping someone will have a solution for this error
Errors in the metadata manager. The data type of the '~CaseDetail ~MG-Fact Voic~6' measure must be the same as its source data type. This is because the aggregate function is not set to count or distinct count.
Is the problem due to the data type of the column used in the mining structure is Long, and the underlying field in the cube has a type of BigInt,or am I barking up the wrong tree?
View 16 Replies
View Related
Apr 30, 2015
I'm a beginner with SQL 2012 SSDT & SSMS. I get this error message when I try to deploy my project:
"Error 6
Error (Data mining): KEY SEQUENCE columns are not supported at the case level. The 'Customer Key' column of the 'TK448 Ch09 Cube Clustering' mining structure contains content that is not valid.
0 0
"
I am finding it hard to locate the content that is not valid. I've been trying to find a answer for this problem but can't seem to find anything. How can I locate the content that is not valid and change or delete it so that I can deploy this solution?
View 2 Replies
View Related
Jan 1, 2008
Hi,
I tried to create a lift chart with my custom plugin-algorithmn. The chart seems to be correct, but before it is drawn, an error occours:
Function ... Row 1 ... Column 43 ... cannot be used in this context.
(I've translated the key facts of this error message from german)
What did I do wrong?
Best wishes,
Manfred
View 12 Replies
View Related
Sep 27, 2004
Hi,
Iam trying to import data from a csv file into my table in SQL Server 2000. My table is called as temp_table and consists of 3 fields.
column datatype
-------- -----------
program nvarchar(20)
description nvarchar(50)
pId int
pId has been set to primary key with auto_increment.
My csv file has 2 columns of data and it looks like follows:
program, description
"prog1", "this is program1"
"prog2", "this is program2"
"prog3", "this is program3"
Now i use BULK INSERT like this
"BULK INSERT ord_programs FROM 'C:datafile.csv' WITH (FIELDTERMINATOR=',', ROWTERMINATOR='', FIRSTROW=2)"
to import data into my table in SQL server and it gives me this error
"Bulk insert data conversion error (type mismatch) for row 2, column 3 (pId)"
I guess i have to use fileformat or something since i dont have anything for pId field in the csv file to make it work...
Please help me out guys and please post a snippet of code if you have.
Thank You.
View 2 Replies
View Related
Jul 20, 2005
HelloMY SQL Server is causing me this problem :Microsoft VBScript runtime error '800a000d'Type mismatch: 'ident'[color=blue][color=green][color=darkred]>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>[/color][/color][/color]I am getting from the table datingnew the value of the ident field."select max(ident)as test from datingnew"ident = RS2("test")ident = ident + 1The ident value is passed over 2 sites by hidden form value. There I amsimpy trying to insert it again in the same table datingnew.[color=blue][color=green][color=darkred]>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>[/color][/color][/color]query = "INSERT INTO datingnew(ident,....,registerdate)"query = query & " VALUES ('" & ident & "', '" & .... & "', '" ®isterdate & "')"there the error message is comeing each time :[color=blue][color=green][color=darkred]>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>[/color][/color][/color]Microsoft VBScript runtime error '800a000d'Type mismatch: 'ident'[color=blue][color=green][color=darkred]>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>[/color][/color][/color]I have tried to change the the type of ident in the table datingnew tointeger , nvarchar, ....Tried to close the recordset each time with db.close, RS. close.Changed the ident field to standard, but also to with and withoutduplication, didnt help so far ...Need helpkind regards ArunMicrosoft VBScript runtime error '800a000d'Type mismatch: 'ident'
View 5 Replies
View Related
Oct 26, 2007
I am new to SQL.
I have the following SQL query.
Update TimeSheet SET TotalTime=TimeOut - TimeIn;
The data type for TotalTime required by me is (For example)
2 Days 3 Hrs.
So what should is Do?
At present i am getting output as 'Jan 1 1900 1:00AM' where as i want it to show as 0 days 1 hour.
View 9 Replies
View Related
Jul 23, 2005
I'm getting a type mismatch error on the mid(strRecord,1,1)="H" line. Iused to do this all of the time, but I haven't done any VBScript forawhile, so I'm sure I'm forgetting something.While not objResults.EOFstrRecord=String( 333 ,32 )IF TicketID<>objResults.Fields("ticket").Value thenMid(strRecord,1,1)="H"mid(strRecord,2,5)=objResults.Fields("cust").Value 'custmid(strRecord,7,30)=objResults.Fields("ship1").Value 'ship1mid(strRecord,37,30)=objResults.Fields("ship2").Value 'ship2mid(strRecord,67,30)=objResults.Fields("ship3").Value 'ship3elsemid(strRecord,1,1)="D"END IFobjStream.WriteLine(strRecord)TicketID=objResults.Fields("ticket").ValueobjResults.MovenextWend
View 2 Replies
View Related
May 11, 2006
Hi, myself palak.
I m working on event organizer website,its running ASP pages on windows 2003 server with SQL server 2000. I have upgraded SP2 for SQL server to SP4 in maintance process.
The problem accur with some ASP pages are
server_errors [server_Errors] GetErrorMessage [serverSERVER version 1.0.0] error '800a03eb' Type mismatch
/server/asp/cmfls/errorconfirmation.asp, line
There may be permission /security issues related with database.help me to troubleshoot my problem.
View 1 Replies
View Related
Oct 27, 2005
Hi,
Create Table tb_mismatch
(x int)
Create Procedure proc_mismatch
as
begin
insert into tb_mismatch values('s')
if @@error<>0
begin
print ' entered error loop'
end
print 'successfully exited'
end
exec proc_mismatch --executing the proc
Now, when i try to capture the above error its not getting trapped..its directly going to the final end statement.
I have even tried calling subprocedures so that it comes out of the inner procedure and by some means i can move forward in the outer proc,but even that failed.
The proc. is able to capture all the other errors like primary key violation,binary data truncated etc but not the datatype mismatch error (mainly int with varchar...)
any ideas are highly appreciated.
Thanks & regards,
Pavan.
View 8 Replies
View Related
Mar 5, 2007
Hi All,
I am moving some numerical data from SQL server to excel. After the data is moved, i am getting green flag in excel cell to which the data is moved. I have configured the excel column to accept only numbers, but still i am getting green flag in excel cells. When i click the cell i am getting this message "The number in the cell is formatted as text or preceded by a apostrophe"
Can anyone tell me how can i over come the issue.
Thanks
Anwar
View 4 Replies
View Related
Oct 8, 2007
I have a data flow that is updating an Access database using an OLD DB Command control. I am getting this error and have narrowed it down to a column the Access table called CreateDate. I don't think this is a reserved word, but even surrounding it in [] did not resolve the problem. The column from SQL Server is called order_date and is a datetime and the destination column createdate is a datetime in Access. When I remove this column fromt he insert command, it works fine but when included, it gives the data type mismatch on criteria error. Any ideas?
View 3 Replies
View Related
Apr 25, 2000
I am programatically loading a template DTS package that imports a text file to SQL Server. I change the properties (source, destination, ...), SaveAs to a new name, and then SaveToSQLServer. The package itself is good, I can programatically execute it and it works, but when it gets saved to SQL Server someting gets corrupted. When I try to open the package or manually execute it, I get a DTS Package error w/Description: Type mismatch. This problem is not constant. Sometimes dozens of packages can be programatically "Saved as" with not even one being corrupted. Currently, I am unable to get a single one to be successful.
This is a big problem for me because the package gets programatically scheduled to a Job in SQL Agent. I have placed the DTS "save as" creation into a loop that loads it and checks for an error. If the error occurs, it is removed from SQL Server and recreated. My loop is currently running forever instead of for seconds.
Help! What have I done wrong? What can I try?
View 1 Replies
View Related
Oct 13, 2005
I am getting a type mismatch error when I do a bulk insert.---Begin Error Msg---Server: Msg 4864, Level 16, State 1, Line 1Bulk insert data conversion error (type mismatch) for row 1, column 14(STDCOST).---End Error Msg---The STDCOST is set to decimal (28,14) and is a formatted in Access as anumber, single with 14 decimal. I don't know why I would be getting a TypeMismatch error.Any idea?Mike
View 4 Replies
View Related
Feb 20, 2005
Error in Explorer:
Data type mismatch in criteria expression.
Following codings:
Dim lowestPrice As Double
Dim highestPrice As Double
lowestPrice = FormatCurrency(txtLow.Text, 2)
highestPrice = FormatCurrency(txtHigh.Text, 2)
lblLabel.Text = lowestPrice
.
.
"UNION " & _
"SELECT p.ProductID, p.ProductTitle FROM Product p " & _
"WHERE (p.Price > '" & FormatCurrency(lowestPrice, 2) & "' AND p.Price < '" & FormatCurrency(highestPrice, 2) & "') " & _
"ORDER BY p.ProductTitle"
I don't know where the error goes wrong in here.. previously because of the union missing one spacing that resulted in syntax error, after i inserted a space to it.. it shows me Data type mismatch the criteria expression. Is it because in my sql coding i cant use FormatCurrency for ASP.net? please give me a hand.. thank you
Contact me at: ryuichi_ogata86@hotmail.com
ICQ me at: 18750757
View 1 Replies
View Related
Jun 20, 2007
Hi,
I need help in ASP for this error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/advice generation/testdateprint.asp, line 371
Code is as :
crtdt = #27/04/2007# ' date in DD/MM/YYYY format
and in database its date format is MM/DD/yyyy
set objrs=server.CreateObject("ADODB.Recordset")
set unitrs=server.CreateObject("ADODB.Recordset")
set userrs=server.CreateObject("ADODB.Recordset")
tsql = "SELECT * From advice_register WHERE "
tsql = tsql & " user_id ='" & Session("UserID") & "'"
tsql = tsql & " and fin_year ='" & CStr(Request.QueryString("fin_year")) & "' and "
tsql = tsql & "created_on ='" & (crtdt) &"'"
objrs.Open tsql,objconn, 1,3
View 7 Replies
View Related
May 7, 2008
I am trying to delete the row with the minimum date. First I read in the minimum date using:
OleDbCommand myCommand = new OleDbCommand("SELECT MIN(Date) FROM 30_Day_Data", myConnection);
myCommand.ExecuteNonQuery();
OleDbDataReader myReader = myCommand.ExecuteReader();
This then gives me a date in the format "1/2/2008 12:09:33 AM". Since that is the minimum date, I need that row deleted, so I use:
OleDbCommand myDeleteCommand = new OleDbCommand("DELETE FROM 30_Day_Data WHERE Date='" + "myReader().GetValue(0).ToString()" + "'", myConnection);
myDeleteCommand.ExecuteNonQuery();
This gives me an error saying "Data type mismatch in criteria expression". I have no idea how to format the date so that it can get deleted. I have tried nearly everything with no success. Any help is appriciated.
Thanks!
Ross
View 1 Replies
View Related
Mar 14, 2008
<% @codepage=950%>
<!-- #include virtual="common/adovbs.inc" -->
<%
sid = "1"
Dim Connect, RS, Query
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "81231888-katiga"
Set RS = Server.CreateObject("ADODB.Recordset")
Query = "SELECT * FROM lunch_other where LOid = '"& sid &"'"
response.write Query
RS.Open Query, Connect, adOpenDynamic, adLockOptimistic
'if rs.eof then
response.write "Testing OK!!"
'Else
response.write trim(rs("LOid"))
response.write trim(rs("LMenu"))
connect.close
end if
%>
Error Result
SELECT * FROM lunch_other where LOid = '1'
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/lunchset/test3.asp, line 16
View 4 Replies
View Related
Mar 6, 2006
I have SS on 64bit trying to do a lookup to an Oracle 10G db - I'm reading from a SS table and using a column to be part of the 'where' clause on my lookup against a table in oracle - I get Data Type mismatch even though both columns are strings (the input SS column is mapped to a string Derived column which is then mapped to the lookup). If I run on a 32bit machine it works fine. I have a task that can successfully update the Oracle DB table (on 64bit), I just can't get the lookup to work on 64 bit.
Anyone else seen this?
Thanks
View 2 Replies
View Related
Jan 1, 2008
Hi,
I want to create a Data Mining Plugin-Algorithmn that uses existing mining models in the current DB. Is there a way to get a AdomdConnection from within an (Managed) Plugin-Algorithmn? This Connection should point to the current SSAS-Database.
Regards,
Manfred
View 1 Replies
View Related
Nov 28, 2006
I would like to write a custom mining function, which takes a string, queries the database, and returns an answer based upon those queries. So the basic function is then:
[MiningFunction("Performs Foo")]
public string Foo(string param)
{
// process parameters
// query database
// calculate answer from query results
// return query results
}
And is executed from the client using:
SELECT Foo("X Y Z") FROM FooModel
This arrangement is so that resource-intensive calculations are performed server-side.
My question is: what is the preferrable method for executing the database query from within the custom mining function?
View 4 Replies
View Related
Oct 25, 2007
Hi all,
I am using Microsoft_Time_Series and have set HISTORIC_MODEL_GAP to various values (from 1 to 21). I always get this error:
Error (Data mining): The 'HISTORIC_MODEL_GAP' data mining parameter is not valid for the 'My Time Series' model.
In Algorithm Parameters window, this parameters is not there by default, so I have to add it.
Any tip will be greatly appreciated.
View 3 Replies
View Related
Apr 26, 2006
Hi, all here,
I am wondering where can I store my mining results in data mining engine? For example, I got mining results like accuracy chart, decision trees, and other formats of results based on different mining algorithms I used for my data mining, so where can I actually store the results for reporting service use later? Is it possible to do that in SQL Server 2005?
Thanks a lot for any help and guidance in advance.
View 4 Replies
View Related
Nov 28, 2005
I'm not sure why the numbers aren't being used as ints, all the examples I've found says this works...I appreciate any suggestions.products = trim(request.form("products")) response.Write("prods [" & products&"]") produces the output...prods [423,424,174] however, when i try and pass this to sql server 7 from asp, i get the following error (if i use query analyzer it works fine.)
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to int. cmd.Parameters.Append cmd.CreateParameter("@prods",adVarChar,adParamInput,255,products) conn.open cmd.ActiveConnection=conn cmd.Execute 'ERROR ON THIS LINE, SO HELPFUL!SP: @prods nvarchar(255) --paramSET @sql=@sql+' WHERE id in ('+@prods+')' --i've tried with the parens and without
View 2 Replies
View Related
Jul 10, 2007
Hi, all,
Why I got different results for the same attribute value displayed in my mining model? Any suggestions on what I may have missed for that?
In my case, the mining structure is with case table which is the fact table, within this mining structure, I dragged other attributes from its related dimensional tables as well. E.g The schema of the mining structure is as below:
.........................................................................................
Fact events key (key of the case fact table)
Agent type (attribute dragged from its related dimension table, which is not the key attribute of that dimension table)
Agent level (attribute dragged from its related dimension table, and it is not the key attribute of that dimension table as well)
......and other attributes dragged from its related dimension tables.
.......................................................................................
Then in my training model (using Microsoft Clustering algorithm), the content contained within the training model is very strange, e.g there are different results for the same value of attribute 'Agent Level' . Why did that happen and how can I figure it out? There should only one result for each value of each attribute within one mining model?
Please shed me some light on this issue and I am looking forward to hearing from you shortly for your kind advices and thanks a lot in advance.
With best regards,
Yours sincerely,
View 4 Replies
View Related
May 6, 2006
I have a problem using 3 tables. The first recordset is my own invention (that means a very simple one). It reads product features from a table:
Set Rsx = Server.CreateObject("ADODB.RecordSet")
sSQL= "SELECT * from prodfeatures"
Rsx.Open sSQL, sDSN, adOpenStatic, adLockReadOnly, adCmdText
'then I read the recordset into arrays like this:
While Not Rsx.eof
i=i+1
mte(i)=Rsx("id")
' every id has a corresponding featurename
mfnavn(mte(i))=Rsx("featurename")
Rsx.movenext
Wend
'this part works very well
Now comes the difficult part that the SQLTeam figured out (this combines an order base with an itemorder base):
Set Rs = Server.CreateObject("ADODB.RecordSet")
sSQL="select oitems.catalogid,oitems.features, sum(oitems.numitems) as SumOfItems from oitems Inner Join Orders On Orders.orderid = oitems.orderid Where Orders.oshippeddate =" & dDate & " AND Orders.orderid <> 1 group by oitems.catalogid,oitems.features"
Rs.Open sSQL, sDSN, adOpenStatic, adLockReadOnly, adCmdText
'Then I write the content of the products with product features - the complexity of the sql is due to a use of many other operations:
While Not Rs.eof
response.write Rs("catalogid") & "features:" & Rs("features") & "Name:" & mfnavn(rs("features"))
Rs.movenext
Wend
The query runs, and starts well, writing 3 lines:
239 features:221 Name:Standard bil max 5m lang og 1,9 m høy
240 features:270 Name:Liggestol (gratis)
240 features:271 Name:C1 Enkeltseng i delt lugar u. bildekk. Kun vask
but it is then aborted with this message:
Microsoft VBScript runtime error '800a000d' Type mismatch: 'Rs(...)'
I know that the problematic part is the array
mfnavn(rs("features"))
...anyone with experience in this?
View 6 Replies
View Related
Jul 23, 2005
Hi all,I have a table called PTRANS with few columns (see create script below).I have created a view on top that this table VwTransaction (See below)I can now run this query without a problem:select * from dbo.VwTransactionwhereAssetNumber = '101001' andTransactionDate <= '7/1/2003'But when I create an index on the PTRANS table using the command below:CREATE INDEX IDX_PTRANS_CHL# ON PTRANS(CHL#)The same query that ran fine before, fails with the error:Server: Msg 242, Level 16, State 3, Line 1The conversion of a char data type to a datetime data type resulted inan out-of-range datetime value.I can run the same query by commeting out the AssetNumber clause and itworks fine. I can also run the query commenting out the TransactionDatecolumn and it works fine. But when I have both the conditions in theWHERE clause, it gives me this error. Dropping the index solves theproblem.Can anyone tell me why an index would cause a query to fail?Thanks a lot in advance,AmirCREATE TABLE [PTRANS] ([CHL#] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[CHCENT] [numeric](2, 0) NOT NULL ,[CHYYMM] [numeric](4, 0) NOT NULL ,[CHDAY] [numeric](2, 0) NOT NULL ,[CHTC] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL) ON [PRIMARY]GOCREATE VIEW dbo.vwTransactionsASSELECT CONVERT(datetime, dbo.udf_AddDashes(REPLICATE('0', 2 -LEN(CHCENT)) + CONVERT(varchar, CHCENT) + REPLICATE('0', 4 -LEN(CHYYMM))+ CONVERT(varchar, CHYYMM) + REPLICATE('0', 2 -LEN(CHDAY)) + CONVERT(varchar, CHDAY)), 20) AS TransactionDate,CHL# AS AssetNumber,CHTC AS TransactionCodeFROM dbo.PTRANSWHERE (CHCENT <> 0) AND (CHTC <> 'RA')*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Nov 19, 2004
I am trying to declare a global variable in a DTS package for passing the recordset to the next stage Active Script . After declaration of the Global Variable and selecting datatype of the variable as OTHER ( Variant ) , when I try to save the DTS Package changes , it throws a Type Mismatch Error .
:confused: Please help me out .
Thanx
Arnie .
View 1 Replies
View Related
Dec 19, 2006
With the number of threads it is difficult to know if this has been posted. If I use the Mining Content Viewer for Linear Regression, under Node Distribution, there are values given for Attribute Name, Attribute Value, Support, Probability, Variance, and Value Type. The output is similar to what Joris supplied in his thread about Predict Probability in Decision Trees. My questions:
1. How should these fields be interpreted?
2. With Linear Regression, is it possible to get the coefficient values and tests of significance (t-tests?), if they are not part of the output I have pointed to?
Thanks for your help with this?
Sam
View 1 Replies
View Related
Jun 27, 2007
Hi all,
I am creating a customer data flow component for SSIS for use in a package. I've got some custom properties that I am exposing using the supplied advanced editor (no custom property editor here).
Some of my properties are enumerated types, and I have deciphered how to get those properties to show as dropdown lists of their respective enumerations. (For those of you who may be looking as hard as I did as to how to accomplish this, see the end of this post.)
I also have a few properties which request SSIS package variable names - such as an file name variable. However, I can't figure out how to tell the advanced editor that the property is looking for an SSIS variable, so that it can show a dropdown list of package variables, much like virtually any other Microsoft supplied Data Flow component can.
Is there a Type Converter I could specify for those custom properties? Is there another way to instruct SSIS that my custom property is expecting a variable? Or do I need to code a custom UI for editing my Data Flow Task?
To create a dropdown list of values for a custom property that represents an enum, do the following:
1. Create your enum definition, such as "public enum ThisIsMyEnum { one, two }"
2. Create a new class that inherits from TypeConverter, such as "public class MyEnumConverter : TypeConverter"
3. Override "CanConvertFrom", and return true if "sourceType == typeof(string)"
4. Override "CanConvertTo", and return true if "destinationType == typeof(string)"
5. Override "ConvertFrom", and return the enum value (such as "one" or "two" in my example) that corresponds to the string passed in the parameter "value"
6. Override "ConvertTo", and return a string that corresponds to the enum value passed in the parameter "value"
7. Override "GetStandardValuesSupported" and return true
8. Override "GetStandarValuesExclusive" and return true to indicate that ONLY the enum values should be accepted
9. Override "GetStandardValues", and return a new StandardValuesCollection constructed with Enum.GetValues() of your enum, such as "return new StandardValuesCollection(Enum.GetValues(typeof(ThisIsMyEnum)));"
10. Just above your "public enum" declaration, add a "TypeConverter" attribute to link your type converter to your enum, such as "[TypeConverter(typeof(MyEnumConverter))]"
11. In "ProvideComponentProperties", after you've created your custom property like this: "IDTSCustomProperty90 propEnum = ComponentMetaData.CustomPropertyCollection.New()", add another line to specify the TypeConverter property of the property to the full assembly name of your type converter, like so: "propEnum.TypeConverter = typeof(MyEnumConverter).AssemblyQualifiedName;"
View 11 Replies
View Related
Sep 29, 2015
I followed the tutorial posted at [URL] ...
Everything was ok until the last step where I had to process the mining structure which resulted in a warning
"Informational (Data mining): Decision Trees found no splits for model, Tbl Decision Tree Example."
What does this error mean? How do I resolve it? Also, I only see the first level in the Mining Model Viewer, I don't see the levels 2 and 3.
View 2 Replies
View Related
