Showing posts with label product. Show all posts
Showing posts with label product. Show all posts

Sunday, March 25, 2012

Can I filter the data on mining structure, mining model?

I perform data mining on all products and a specific product category.
Do I need to create 2 data source views, one for all products and the other one for the specific product category?
Afterward, I run the Data Mining Wizard 2 times to create 2 mining structures.
I also need to add the same mining model (e.g. Bayes, Cluster) to each of these mining structures.
Is there any simple way to do it?

Thanks.
Joe.

Yes you'd need to use two data sources. However instead of going through the wizard twice and recreating all the contained models, you could use SQL Mgmt Studio to script the mining structure and its contained models, modify the name in the generated script and then run t. To do this, right-click on the mining structure in SQL Mgmt Studio and select "Script Mining Structure As"-> CREATE TO.

|||Thanks Raman.

Can I download SQL Server User Interface for free?

I have a purchased product that contains a SQL Server database. I was hoping to access the database with a SQL Server front-end, however I don't have a separate licensed copy of SQL Server. Is there a way I can obtain a free copy of the user interface for
a SQL Server DB?
I am guessing that you are running on MSDE. Perhaps you will find MSDE =
manager useful:
http://www.whitebearconsulting.com/Utilities.htm
--=20
Keith
"AFG" <anonymous@.discussions.microsoft.com> wrote in message =
news:42647C63-C881-4F78-B7E4-1017DE296CEA@.microsoft.com...
> I have a purchased product that contains a SQL Server database. I was =
hoping to access the database with a SQL Server front-end, however I =
don't have a separate licensed copy of SQL Server. Is there a way I can =
obtain a free copy of the user interface for a SQL Server DB?
|||You can use Visual Studio .Net to see the UI. I think you can use Enterprise Manager to see the MSDE, too.
|||If you do not have a licensed version of SQL Server you cannot legally use
teh utilities that come with SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||look into "Toad For MS SQL Server"
http://www.toadsoft.com/toadss.html
not a bad tool and it's free
Greg Jackson
PDX, Oregon

Can I download SQL Server User Interface for free?

I have a purchased product that contains a SQL Server database. I was hoping
to access the database with a SQL Server front-end, however I don't have a
separate licensed copy of SQL Server. Is there a way I can obtain a free cop
y of the user interface for
a SQL Server DB?I am guessing that you are running on MSDE. Perhaps you will find MSDE =
manager useful:
http://www.whitebearconsulting.com/Utilities.htm
--=20
Keith
"AFG" <anonymous@.discussions.microsoft.com> wrote in message =
news:42647C63-C881-4F78-B7E4-1017DE296CEA@.microsoft.com...
> I have a purchased product that contains a SQL Server database. I was =
hoping to access the database with a SQL Server front-end, however I =
don't have a separate licensed copy of SQL Server. Is there a way I can =
obtain a free copy of the user interface for a SQL Server DB?|||You can use Visual Studio .Net to see the UI. I think you can use Enterprise
Manager to see the MSDE, too.|||If you do not have a licensed version of SQL Server you cannot legally use
teh utilities that come with SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||look into "Toad For MS SQL Server"
http://www.toadsoft.com/toadss.html
not a bad tool and it's free
Greg Jackson
PDX, Oregon

Can I download SQL Server User Interface for free?

I have a purchased product that contains a SQL Server database. I was hoping to access the database with a SQL Server front-end, however I don't have a separate licensed copy of SQL Server. Is there a way I can obtain a free copy of the user interface for a SQL Server DB?I am guessing that you are running on MSDE. Perhaps you will find MSDE =manager useful:
http://www.whitebearconsulting.com/Utilities.htm
-- Keith
"AFG" <anonymous@.discussions.microsoft.com> wrote in message =news:42647C63-C881-4F78-B7E4-1017DE296CEA@.microsoft.com...
> I have a purchased product that contains a SQL Server database. I was =hoping to access the database with a SQL Server front-end, however I =don't have a separate licensed copy of SQL Server. Is there a way I can =obtain a free copy of the user interface for a SQL Server DB?|||You can use Visual Studio .Net to see the UI. I think you can use Enterprise Manager to see the MSDE, too.|||If you do not have a licensed version of SQL Server you cannot legally use
teh utilities that come with SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||look into "Toad For MS SQL Server"
http://www.toadsoft.com/toadss.html
not a bad tool and it's free
Greg Jackson
PDX, Oregon