Rating: 
Summary: A must for OLAP users and those who want to become one
Review: A "10" book, because there's no other on that subject. The book is comprehensiv - very detailed and the software is excellent. The only fault: the author is to often concerned to explain was has been written chapters before and what will be written the chapter that follow insteed to write on the current subject.
My rating is
a 10 for necessity a 10 for the software
a 3 for style of writin
Rating:
Summary: A must read for anybody involved in Olap design
Review: A book which gives you a comprehensive theoretical foundation together with useful, pratical techniques to design Olap solutions.
In the first half of the book the author explains you all you need to think clearly in N dimensions, in the second half he guides you through the design of a rather complex application, stepping into the purchasing process, the material inventory analysis, sales & marketing, and activity-based management. He teaches you using maieutics, Socrates' way of teaching, via a dialogue between two designers. This way, a lot of questions that usually arise during real-life development are examined and solved.
Whilst the examples in the first edition of this book were based on TM1, in this second edition they are written using a vendor-independent language, called LC (Located contents), which provides you with a solid, logically based foundation to multidimensional design.
The vendor languages, like those used by Microsoft Analysis Services (MDX), Applix TM1, Oracle Express and Hyperion Essbase, are kind of Plato's shadows in the cavern of this ideal language (which is sort of a tautology for MS Plato...), so if you start thinking in LC, you'll be able to work with all of these products.
Ideal complements to this book, if you use Microsoft Analysis Server, are "MDX Solutions" by George Spofford, and "Microsoft Olap Solutions", by Thomsen (again!), Spofford and Chase.
Rating: 
Summary: OLAP is finaly easy
Review: A good book on a subject which is finaly not so complex. If your are a good user of OLAP tool you will find many interesting explanation and modelisation which will help you to improve your skill. According to me Diamond of SPSS is not really an OLAP tool but a data representation tool. Finaly according to me OLAP tool are descriptive engine of trends in data.
Rating:
Summary: Excellent Book
Review: An excellent book for the OLAP tool implementor.
Be forwarned that the version of TM/1 which is included with the CD-ROM doesn't seem to work (at least not with Excel 97)
Rating:
Summary: Great job - the olapmessageboard highly recommends this
Review: As some one who makes a living doing OLAP development, I thought the Author does a great job explaining the similarities and differences between OLAP and relational analysis. It is important to note that OLAP analysis does not replace relational analysis - it enhances it.
Rating:
Summary: Very fundamental. A must have for an OLAP prefessional
Review: Even though I had been familiar with OLAP concepts before I bought this book, I enjoyed reading it and recommend it to anyone seriously interested in OLAP. You will learn the history of OLAP and why traditional tools like SQL and spreadsheets are not very well suited for analysis that multidimensional tools are capable of performing. There are two comprehensive chapters on basic multidimensional features like dimensions, hierarchies, attributes and so on for those who are not familiar with them yet. There are more chapters describing some advanced features like joining cubes, visualization, formulas. Sparsity problems are taken into consideration as well as storage options for multidimensional data. There are several business cases for OLAP application, but, unfortunately, as other reviewers have already noticed the software which goes with the book does not work properly, so I just skimmed throuth the chapters where the use of the software was described. For me it was not the main part because I had already had some experience with OLAP tools before. The author destinguishes clearly between data warehousing and OLAP which some people sometimes fail to do. I liked also the last chapter where the author gives some guidelines on how to evaliate OLAP tools, which may be very helpful for those who have not made their minds yet about what tool to use in their project. Although there is some outdated material in the book, it without a doubt deserves its five stars.
Rating:
Summary: Even Better the Second Time Around
Review: I loved the original OLAP Solutions, and this edition is even better. The added chapters on combining OLAP with data warehousing, data analysis, and decision support tools were very helpful in terms of finding new solutions to problems. And the new product-neutral language case studies are great. A definite must for those who have read the first edition and those who haven't.
Rating:
Summary: Fundamental Olap principles
Review: I was impressed by the quality of this book; this is probably the most complete book on OLAP theory and is a fundamental reading for professionals involved in the design of olap systems. In most cases it gives all the details and information needed to master this technology. It also contains some practical examples that are very useful to see how the theory can be applied in the real world.
I didn't read the first edition, but the second edition contains new sections and many updates, like a description of SQL-99 OLAP extensions.
The author chose to be vendor-independent, so all practical examples are based on a multidimensional language that he created, called Located Contents (LC). However, when I read it I had already used a couple of OLAP tools (Microsoft Analysis Services and Microstrategy), and I think that this helped me understand many of the concepts contained in the book.
Rating:
Summary: Please contact me.
Review: I would like to contact the author by email (see email address below). My company is a consulting/traning company with OLAP experience and looking for technology courseware on this subject.
Rating:
Summary: if you're not doing MSOLAP...
Review: If you're not doing MSOLAP, then this is pretty much (as of the date of this writing) the only practical choice for an OLAP book. It's a good book, very clear explanations of some concepts I was having trouble with (ie, difference between 'generation' and 'level' when every vendor treats these words differently). The descriptions of multi-dimensionalism and how to train your brain to think non-two-dimensionally were just what I needed. I did not install the software in the back of the book, so I can't comment on that.
|
