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
book is available on Amazon & you can buy an e-book directly from the publisher by writing OLAPWorldPress@gmail.com.