Introduction to OLAP CUBES

Hi,

I was wondering if I could get some help in how to get started with designing OLAP CUBES. I have done many other reports using matrix also. I wanted to use this technology in one of my reports so that my users can drag and drop data the way they want it, just like a pivot table in excel. Thanks,

-Rohit

Hi rogupta,

What you need is Analysis Services. I suggest you get familiar with terms like fact tables and dimension tables. Building a cube isn't that hard to learn but you need to do some excercises. Also get familiar with denormalizing tables, the way you build the tables is important for drilling down in the cube.

The following provides some samples if you're using SQL Server 2005: http://www.microsoft.com/downloads/details.aspx?FamilyID=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

Also have a look at http://www.microsoft.com/sql/solutions/bi/bianalysis.mspx for SQL Server 2000

Good luck!

Worf

Introduction to Data Types?

Does anyone know of a good place to get an introduction to the Data Types in SQL Server? I come from and Access background, so I'm used to auto-number, text, etc. I just need to figure out which types I need to be using for my data....
Any help is appreciated.

The best thing to start from is BOL.

Look at ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a54f7373-b247-4d61-8fb8-7f2ec7a8d0a4.htm

|||I don't know if it matters, but I'm using SQL 2005 Express Edition, and I couldn't use that link either in Internet explorer or in the MSDN Help Browser.... Is there somewhere online I can find that?
|||

Do you already have the Documentation and Samples for SQL 2005 Express installed? If not, try downloading from here:

http://www.microsoft.com/downloads/details.aspx?familyid=9697AAAA-AD4B-416E-87A4-A8B154F92787&displaylang=en

jeff.

|||I guess that link is from books online.|||

If you're looking for Books On Line itself, it can be downloaded from here:
http://www.microsoft.com/downloads/details.aspx?familyid=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

/Kenneth

|||Alright, I got it. Thanks everyone.