Analysis Services + MDX Book recommendations

Can anyone recommend any books on analysis services and/or MDX.
We're a pretty tech savvy bunch of developers who need some kick start
books on using 2005 analysis services, warehousing principles, writing
MDX queries, designing cubes etc
Any ideas welcomed
db
http://www.osix.net
the Open Source institute
home of the geek programming challengesI recommand you the Wrox: Professional SQL Server Analysis Service 2005 with
MDX
enjoy.
Patrick
<barnseenio@.gmail.com> wrote in message
news:1149776441.711318.175980@.g10g2000cwb.googlegroups.com...
> Can anyone recommend any books on analysis services and/or MDX.
> We're a pretty tech savvy bunch of developers who need some kick start
> books on using 2005 analysis services, warehousing principles, writing
> MDX queries, designing cubes etc
> Any ideas welcomed
>
> db
>
> --
> http://www.osix.net
> the Open Source institute
> home of the geek programming challenges
>

Analysis Services & Default Value

Is it possible to define a default value for each a parameter also in a dataset?

I have a dataset with a parameter from the dimension Time. I would like to change the default value from the parameter. I tried to create a dataset to get the current year unique name, but if I set it in the parameter dialog it does not recognize the value.

I have a dataset in a report with the parameter Year from the dimension Time.

In the dataset I have to select a default value for the parameter. There is no other option.

In the reports parameters list I can specify a default value. This is not recognized, if it does not mach previous one.

Is it possible to set the default value of such a parameter to the current year value?

Analysis Services - Step by Step: Errors related to feature availability and configuration

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

Errors related to feature availability and configuration: The 'Measure expressions' feature is not included in the 'Standard Edition' SKU.

Is it because of my Standard Edition? If it is, could I change the 'Measure expressions' some how to get by this msg and go on with the book?

Yes, you are running into this situation because you working against Standard edition of SQL Server Analysis Services.

You can install free trial edition from http://www.microsoft.com/sql/downloads/trial-software.mspx. It has full set of features for you to comlete any tutorial.

As for the steps described in the book, or how to work around them. You should point your questions to the authors of the book.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward. I'll try with the trial edition.

I was also trying to post the question to the authors, but I could not find the link to it.

|||

Hi mate

I have the same problem. Could you tell me how to fix this issue please. I'm using SQL 2005 standand version. Does it cause the problem? Please tell me as soon as possible.

thank you in adv

Wen Ou

|||I have the same problem. I am also interested in a fix, not the trial version. Could someone please let me know how to change the configuration of the cube.sql

Analysis Services - Step by Step: Errors related to feature availability and configuration

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

Errors related to feature availability and configuration: The 'Measure expressions' feature is not included in the 'Standard Edition' SKU.

Is it because of my Standard Edition? If it is, could I change the 'Measure expressions' some how to get by this msg and go on with the book?

Yes, you are running into this situation because you working against Standard edition of SQL Server Analysis Services.

You can install free trial edition from http://www.microsoft.com/sql/downloads/trial-software.mspx. It has full set of features for you to comlete any tutorial.

As for the steps described in the book, or how to work around them. You should point your questions to the authors of the book.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward. I'll try with the trial edition.

I was also trying to post the question to the authors, but I could not find the link to it.

|||

Hi mate

I have the same problem. Could you tell me how to fix this issue please. I'm using SQL 2005 standand version. Does it cause the problem? Please tell me as soon as possible.

thank you in adv

Wen Ou

|||I have the same problem. I am also interested in a fix, not the trial version. Could someone please let me know how to change the configuration of the cube.

Analysis Services - Provider cannot be found

I've got a big problem with the Analysis Services.
I have a SQL Server 2000 SP3 and the Analysis Services SP3 running. The SQL Server has no problems.
When I try to browse the Data of any cube, the following error message occurs:
"Provider cannot be found. It may not be properly installed." When I try to browse other cubes after this, the error message "unknown error" occurs.
The databases, on which the cubes are based are both Access2k and SQL Server 2k. The error even appears at the test cubes from Microsoft, so it cannot be simply a problem of the database.

Much thx for your answers.Try to restart the services on the machine.|||That would be an easy solution. I tried it at first. :-)
It didn't change anything.|||Are you trying to browse from WINXP? If so, you'll need to install sp3 for analysis services on the client.|||I could solve the problem. I had an error when installing sp3 for analysis services on the server. I didn't take notice of it. Later I checked the Version number and recognized, that sp3 was not installed. I installed sp3 again and then it works.

greets,
Stefan

analysis services

Hello.....

Anyone could help me? I found a difficulties to view the mining result(tree) from analysis services 2000 in my vb 6 application form. I've tried to view the tree by using DMbrowser in vb6 so please help me with some code lines.

Thanx a lot

Take a look at the included source code in this download for the DMSample app (it's written in VB and it launches the viewers from the app): http://www.sqlserverdatamining.com/DMCommunity/Downloads/Links_LinkRedirector.aspx?id=85

Note that the AS2000 license does not give you the ability to redistributable the viewers as part of your application.

Analysis services

I am doing a data mining project using the census bureau data set. The data set is a pdf, so I saved it as a text file, I imported as a flat source file and am trying to create my data source? But am having trouble with this? Please help?

Can you post details of the errors you're seeing? This might be a question for the Integration Services forum.|||i fixed the error. but thanks. Perhaps, you could help me with Analysis services, Data source views. Under the Data source views tab select tables and views, if I only have one file of data with columns and rows, is it possible to data mine this one file. or should i be incorporating more files?|||

There are no specific restrictions on the number of tables you need to use to perform data mining. You can certainly mine data in a single file/table if that contains the attributes you're interesting in mining.

For example, you could have a single customer table with demographic information like age, income and so forth and you could apply several of the available algorithms to it to derive interesting patterns - clustering to group together similar customers, decision trees to classify them based on how they behave with respect to a predictable attribute or naive-bayes to explore dependencies and differences between attributes for customers.

|||

How would you implement the MS Time series algorithm to predict population patterns? or would you suggest I use MS decision trees?

Thanks

|||Create a table with date and columns for each series you want to analyze