Above given information is really helpful especially for newbies who wants to retrieve the multidimensional data from sql 2005.
I would also recommend a book on OLAP and believe me its pretty informative.
The [ame=http://www.amazon.com/Multidimensional-Data-Modeling-Toolkit-Intelligence/dp/0981775306]book is available on Amazon [/ame] & you can buy an e-book directly from the publisher by writing [email protected].