Best configuration for Analysis Services

I am looking for opinions on what server configuration is best for Analysis
Services 2000.
Should we emphasize CPU speed/multiple CPUS, RAM?
We have a SAN attached via a Gigabit LAN.
Thanks.See if this helps
http://www.microsoft.com/technet/tr...ze/ANSvcsPG.asp
There is a section on hardware resources, as Tom Chester has quoted multiple
places, Analysis Services is very heavy on RAM and SQL2K AS can only use
3gb.
Ray Higdon MCSE, MCDBA, CCNA
--
"Bruce Lester" <bruce_lester@.email.com> wrote in message
news:wDy_b.391402$na.741449@.attbi_s04...
> I am looking for opinions on what server configuration is best for
Analysis
> Services 2000.
> Should we emphasize CPU speed/multiple CPUS, RAM?
> We have a SAN attached via a Gigabit LAN.
> Thanks.
>

Beginner's question

I just installed SQL Server 2005, Office 2007, and the add-in, but when I check services.msc, I don't see the SQL Server Analysis Services. Does anyone know how I can get this to load? Also, when I run the server configuration utility in the DM add-in folder, do you know what I should put in the server name to get it to run off my hard disk and not a server? local host doesn't seem to work. Thanks in advance!

Which edition of SQL Server 2005 did you install? If you installed the express edition, Analysis Services is not included in that edition. To access Data Mining features, you can install an eval edition of SQL Server 2005 from http://technet.microsoft.com/en-us/sqlserver/bb462637.aspx

The DM Addins needs Analysis Server to run and cannot run off a local file from your hard drive. You'll need Analysis Server installed to use the addins from Office.

|||I have the evaluation version, but don't know how to set it up to have my hard drive as the server. Do you know how I can get the SQL analysis services to run so that it will appear in services.msc?
|||While installing the evaluation edition, did you select Analysis Services as as installation option? You can go to Add/Remove Programs, find Microsoft SQL Server 2005, select Modify and check the list of products installed. Analysis Services should be one of the options.|||Thanks a lot for you help. If I had 50 products and 60,000 different customers with different assortments of products per customers (basket), do you know how microsoft's associate function can help determine the association rules that have the highest probability of occurring? Thanks again.
|||Are you referring to the PredictAssociation function? Or just how to setup the mining model to do a market-basket analysis?|||Market-basket analysis would be great. Is there any way to get it to give the probabilities of Product C given that Product A and B are also sold, or will it just be able to do the probability of product B given that A is sold? Thanks
|||

It does both. The Association Rules algorithm uses all rules that "fire" for the input set. For example if you had rules such as

A->C

A,B->C

A,D->C

and you had A,B, and D in your input, all three rules would "fire". The resultant probability is based on the probability of the rules, and may not match any one in particular.

|||So would I just select the 50,000 clients and 50 products and then run the associate function? Do you know how long it would take for the associate or clustering feature to run with this amount of data on a local hard drive?
|||

The amount of time to perform such an operation is not long. However, reading your original question - "the association rules with the highest probability of occurring", the answer is simply those rules whose LHS itemsets have the highest support. Take for example you have rules

A -> C

A,B -> D

A,B -> C

A, B, C -> E

Say you have 50,000 cases and you have support(A)=5,000, support (A,B) = 2,000, support(A,B,C) = 1000.

The probability given any input case of each rule firing would then be

10% A->C

4% A,B->D

4% A,B->C

2% A,B,C->E

beginner Analysis Services question

I'm looking into learning how to use Analysis Services- the problem , (for
learning purposes) I have set up is 1,000,000 rercords , which are made up
of opinions about various topics . It is one column , with up to 1000
length.
Does Analysis Services posess algorithms that will estimate , for example
Male or Female? Or does a developer have to build in the rules ?
--
Jack Vamvasyour table contains only 1 column which is a 1000 characters length?
When you say "estimate male or female" what do you mean by estimate? do you
talk about datamining?
"what is the probability of having male for a set of cases?"
"Jack Vamvas" <delete_this_bit_jack@.ciquery.com_delete> wrote in message
news:bOednQHceO9eqs_ZRVnyjg@.bt.com...
> I'm looking into learning how to use Analysis Services- the problem , (for
> learning purposes) I have set up is 1,000,000 rercords , which are made
> up
> of opinions about various topics . It is one column , with up to 1000
> length.
> Does Analysis Services posess algorithms that will estimate , for example
> Male or Female? Or does a developer have to build in the rules ?
>
> --
> --
> Jack Vamvas
>|||Correct, it's just a recordset of opinions on a certain topic.
By estimate, I mean "would the comment most likely be made by a female or
male?"
--
Jack Vamvas
"Jeje" <willgart@.hotmail.com> wrote in message
news:#dJt7v5aGHA.4060@.TK2MSFTNGP02.phx.gbl...
> your table contains only 1 column which is a 1000 characters length?
> When you say "estimate male or female" what do you mean by estimate? do
you
> talk about datamining?
> "what is the probability of having male for a set of cases?"
> "Jack Vamvas" <delete_this_bit_jack@.ciquery.com_delete> wrote in message
> news:bOednQHceO9eqs_ZRVnyjg@.bt.com...
(for[vbcol=seagreen]
example[vbcol=seagreen]
>|||a recordset of opinion... but is it 1 column only? how do you identify male
/ female on it?
By the way, you looking for a text mining tool, not an OLAP tool.
SSIS could extract terms from your sentence and generates a table of terms.
Or a recommand to use a survey tool.
these tools can do a lot of things and statistics with a minimum work.
"Jack Vamvas" <delete_this_bit_jack@.ciquery.com_delete> wrote in message
news:BoidnT7nxe1uC8nZnZ2dnUVZ8s6dnZ2d@.bt
.com...
> Correct, it's just a recordset of opinions on a certain topic.
> By estimate, I mean "would the comment most likely be made by a female or
> male?"
> --
> --
> Jack Vamvas
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:#dJt7v5aGHA.4060@.TK2MSFTNGP02.phx.gbl...
> you
> (for
> example
>