Error: Decision Trees found no splits for model

Hi,

I am trying to run one of the mining models from the book "Delivering BI using SQl Server 2005" but I am running into "Decision Trees found no splits for model". The mining structure has 4 columns, the fourth one being marked as "Predict Only". My Cube slice for the model has sufficient data in the cube. I am lost.. Help!!

Regards

I'm not familiar with the DM section of that book. Could you give more descriptions of the data and the problem? What does the root node of the tree look like? Are you predicting a continuous or discrete value? Etc.

If you want to see the data the data mining is using, turn Drillthrough on for the model and then do

SELECT * FROM <model name>.CASES

To see the cases that were used for training the model. If this shows anything odd, you may see what's wrong.

|||

The mining model was created using Customer Dimension and Sales Fact. Following are the details of the mining model

Data Mining Technique: Microsoft Decision Trees
Dimension: Customer
Case Key: Customer.CustomerName
Attributes Used: Gender, Num Of Cars Owned, Num of Childer at home
Mining Model Column Usage: All the above columns except Num of Childeren at Home are Input and Num of Childeren at Home is defined as Predicatble only
Content and Data Type: All the above three columns are defined as discrete and text

Please note that I am new to DM stuff and I might have missed something obvoious. From what I see, when I try to explore the mining model viewer in BI studio, I see only 2 levels and histogram only shows two values, "Missing" and the "", the later having all the values. Ideally, it should have the customer in the root, then split to Gender and then to Num Of Cars Owned. "The num of children at home" should have come fromthe mining prediction.

Thanks for your reply.

|||

When you create the mining model, select the Allow Drillthrough option on the final page of the data mining wizard. When you view the model, right click on the root node and select "Drillthrough". This will show you the data that was used to train the model. It seems that the data that is being used for your model likely isn't the same as was in the book. I am unfamiliar with the book, but if you browse the data and see that maybe Num Children doesn't have the values you expect, it may show you why the model doesn't look like the book's.

You may try e-mailing the book's author as well.

HTH

sql

Error: Data Mining message

This may well be embarrasingly simple but....

I get this massage from Management Studion when I try to run any MDX

Error (Data mining): Either the user, LEONARD\Will Riley, does not have permission to access the referenced mining model, Contribution_Interest, or the object does not exist.

Is there something really simple I have missed?

Most likely you made syntax error in your MDX up tp a degree that it actually looks more like DMX than MDX, so AS tries to find mining model instead of cube. If you will paste your MDX statement, the forum should be able to help and fix it.|||

Yep, you got it

Once I plugged in what I knew to be some correctly structured MDX, the issue went away.

Cheers, Will

Error while trying to load the mining model in the mining model viewer

I get the following error when I try to load the mining model in the mining model viewer

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[NeuralNet].[GetAttributeValues]' function does not exist.

I get a similar error when I try to load the Load Mining Accuracy Chart

Failed to execute the query due to the following error:

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[AllOther].[GenerateLiftTableUsingDatasource]' function does not exist.

I have OWC 11 installed. What am I missing here?

Thanks

These are Analysis Services stored procedures that are suppposed to be installed with your server. Would you please start Management Studio and coonect to the Analysis Services instance you are using? After you connected, click the Assemblies in the object Explorer, you should be able to find System listed there. Right click system, and select properties. You will have a list of properties of this the system assembly.

At first, please verify your assemly exisits. The location of the assembly is list under general->Source. And it looks something like this:

C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\bin\msmdspdm.dll

Please verify this file is not deleted by accident

Second, please check Security Settings. Usually, it should work fine for the following settings:

Impersonation Info ImpersonateServiceAccount

Permission Set Unrestricted.

Good luck,

|||

I installed SQL Server and SSAS in D drive. For some reason, the System assembly source property still points to the C drive. I can't change it either from the property screen or rerun the XMLA script. I also copied the folder from D: to C:. It does not work either.

Do you know how to resolve it?

Thanks a lot.

|||

On possible solution (if you don't have any sensitive data in Analysis Services): stop the service, rename your Data folder to something like Data.bak (%ProgramFiles%\Microsoft SQL Server\MSSQL.2\OLAP\Data), then restart the service. This might fix the incorrect path issue.

Error while trying to load the mining model in the mining model viewer

I get the following error when I try to load the mining model in the mining model viewer

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[NeuralNet].[GetAttributeValues]' function does not exist.

I get a similar error when I try to load the Load Mining Accuracy Chart

Failed to execute the query due to the following error:

Query (1, 6) The '[System].[Microsoft].[AnalysisServices].[System].[DataMining].[AllOther].[GenerateLiftTableUsingDatasource]' function does not exist.

I have OWC 11 installed. What am I missing here?

Thanks

These are Analysis Services stored procedures that are suppposed to be installed with your server. Would you please start Management Studio and coonect to the Analysis Services instance you are using? After you connected, click the Assemblies in the object Explorer, you should be able to find System listed there. Right click system, and select properties. You will have a list of properties of this the system assembly.

At first, please verify your assemly exisits. The location of the assembly is list under general->Source. And it looks something like this:

C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\bin\msmdspdm.dll

Please verify this file is not deleted by accident

Second, please check Security Settings. Usually, it should work fine for the following settings:

Impersonation Info ImpersonateServiceAccount

Permission Set Unrestricted.

Good luck,

|||

I installed SQL Server and SSAS in D drive. For some reason, the System assembly source property still points to the C drive. I can't change it either from the property screen or rerun the XMLA script. I also copied the folder from D: to C:. It does not work either.

Do you know how to resolve it?

Thanks a lot.

|||

On possible solution (if you don't have any sensitive data in Analysis Services): stop the service, rename your Data folder to something like Data.bak (%ProgramFiles%\Microsoft SQL Server\MSSQL.2\OLAP\Data), then restart the service. This might fix the incorrect path issue.