Showing posts with label products. Show all posts
Showing posts with label products. 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.

Tuesday, March 20, 2012

Can I connect without server?

Hi,
I have a customers program on my system - Omin 7 as at
http://www.omnis.net/products/omnis7/ - so I can pull the data into an
Access Database. I'd like to do this work at my place not theirs!
Is there anyway I can set up an ODBC connection so that I can read the
files. The .dsn file reads:
[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=salesteam
WSID=JERRY
APP=Microsoft(R) Windows(R) Operating System
SERVER=NTSERVER
if that helps at all.
I'm running Windows XP Pro. I guess the problem is that I don't have a
server '
Any help would be greatly appreciated, thank you.
JonAre you saying you are running SQL Server on XP? Then it should work
provided you've got file and printer sharing enabled.
If this is not the case, please elaborate on what you are attempting?
Steve
"Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
news:btk6qv$t3f$1@.hercules.btinternet.com...
quote:

> Hi,
> I have a customers program on my system - Omin 7 as at
> http://www.omnis.net/products/omnis7/ - so I can pull the data into an
> Access Database. I'd like to do this work at my place not theirs!
> Is there anyway I can set up an ODBC connection so that I can read the
> files. The .dsn file reads:
> [ODBC]
> DRIVER=SQL Server
> UID=sa
> DATABASE=salesteam
> WSID=JERRY
> APP=Microsoft(R) Windows(R) Operating System
> SERVER=NTSERVER
> if that helps at all.
> I'm running Windows XP Pro. I guess the problem is that I don't have a
> server '
> Any help would be greatly appreciated, thank you.
> Jon
>
|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.odbc:41677
Steve,
I have NOT got sql server running, just XP PRo with IIS.
Is there any way around this - without installing sql server?
Thanks
Jon
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:uNlSD3u1DHA.2184@.TK2MSFTNGP12.phx.gbl...
quote:

> Are you saying you are running SQL Server on XP? Then it should work
> provided you've got file and printer sharing enabled.
> If this is not the case, please elaborate on what you are attempting?
> Steve
> "Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
> news:btk6qv$t3f$1@.hercules.btinternet.com...
>
|||"Jon" <jon@.SPAM_OFFtheexperts.co.uk> wrote in message
news:btpipc$mtu$1@.hercules.btinternet.com...
quote:

> I have NOT got sql server running, just XP PRo with IIS.

It's still not clear to me what you are attempting, I asked you to elaborate
and I'm only getting little tidbits.
quote:

> Is there any way around this - without installing sql server?

Is the source data you need in SQL Server? You can get the SQL Server 2000
developers edition for $49 USD.
I wish I could provide a better answer, however lack of detail is not
helping...
Steve
quote:

> "Steve Thompson" <SteveThompson@.nomail.please> wrote in message
> news:uNlSD3u1DHA.2184@.TK2MSFTNGP12.phx.gbl...
a[QUOTE]
>