What is a good book or other resource to understand and learn how to use
multidimensional data?
I am familiar with RDBMS but when it gets to cubes, I don't know how to
choose the
right dimensions of my dataset, design the cubes, how to store and query
them ?

What I think I need is a tutorial to take me through all the steps of
building a
solution using a multidimensional data model.

What do you guys recommend ?

Many people would recommend books/articles by Kimball. Here is a post on
this group from the SQL Server team:

http://groups.google.com/groups?q=ki...roup:microsoft.
public.sqlserver.olap&hl=en&lr=&ie=UTF-8&oe=UTF-8&group=microsoft.public
.sqlserver.olap&selm=eMAjFfYvCHA.2124%40TK2MSFTNGP 12&rnum=9
Subject: Re: Where to Start? - Need Advice
This is the only article in this thread
View: Original Format
Newsgroups: microsoft.public.sqlserver.olap
Date: 2003-01-16 10:13:18 PST

There are a number of publications I can recommend covering a wide range
of
data warehousing and Analysis Services topics:

» Data Warehousing Design
The Data Warehouse Toolkit: The Complete Guide to Dimensional
Modeling
(Second Edition)
by Ralph Kimball and Margy Ross
The Data Warehouse Lifecycle Toolkit : Expert Methods for Designing,
Developing, and Deploying Data Warehouses
by Ralph Kimball, Laura Reeves, Margy Ross, and Warren
Thornthwaite

» Learning to use Analysis Services
Microsoft® SQL ServerT 2000 Analysis Services Step by Step
by Reed Jacobson
MDX Solutions
by George Spofford
...

Links to many of the Kimball articles can be found here:

http://www.ralphkimball.com/html/articles.html



- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!