Free Downloads
Oracle Essbase & Oracle OLAP: The Guide To Oracle's Multidimensional Solution (Oracle Press)

The only book to cover and compare Oracle's online analytic processing productsWith the acquisition of Hyperion Systems in 2007, Oracle finds itself owning the two most capable OLAP products on the market--Essbase and the OLAP Option to the Oracle Database. Written by the most knowledgeable experts on both Essbase and Oracle OLAP, this Oracle Press guide explains how these products are similar and how they differ. Oracle Essbase & Oracle OLAP will help you architect the Oracle OLAP product that is most appropriate for your application, and build, tune, and maintain OLAP solutions. 

Series: Oracle Press

Paperback: 524 pages

Publisher: McGraw-Hill Education; 1 edition (October 28, 2009)

Language: English

ISBN-10: 0071621822

ISBN-13: 978-0071621823

Product Dimensions: 7.4 x 0.9 x 9.1 inches

Shipping Weight: 1.8 pounds (View shipping rates and policies)

Average Customer Review: 4.4 out of 5 stars  See all reviews (5 customer reviews)

Best Sellers Rank: #1,057,712 in Books (See Top 100 in Books) #256 in Books > Computers & Technology > Databases & Big Data > Oracle #288 in Books > Computers & Technology > Software > Databases #334 in Books > Computers & Technology > Databases & Big Data > Data Warehousing

This is a very good guide for a Business Intelligence specialist. Olap technology concepts help you for the best comprehension of the multidimensional environment (Essbase). This manual speaks about the Hyperion Essbase product history and contains many screenshots to illustrate the use of the principle application such as Smart View or Essbase Server. The architecural schemas are very clear and simple and help you to understand the complexity of the structure.

Clear, well-written and fully explanatory, assumes almost blank slate. Logically organized.Can gain both theorectical insight and key concepts and understanding of how to use. How to's are step by step, with good screen shots.Much better than other books on Essbase available to get a good grasp of Essbase as well as Oracle OLAP.What I like about this book is that it is a no-nonsense book; there is no silly humor like the "Look Smarter Than You Are..." books on Essbase/Hyperion. This really covers the subject well, and is an easy read.

I found this book to give a good compare and contrast between the 2 Oracle OLAP products currently on the market. I was looking for a reference that articulated the both functional and technical differences/similarities and this book fits the bill pretty well. Definitely helps to have some OLAP background, but this is a well written technical manual and I found it straight-forward to find both high and lower level information.

First this book covers both Oracle Essbase and Oracle OLAP applications so you basically are reading half a book it you are only interested in one of the applications. The author introduces interesting topics such as slowly changing dimensions, effective dating, attributes but doesn't show you how to actually set them up in Essbase. There are pages showing discussion how to load dimensions and data but nothing about how to delete data. There is nothing about database security. The last quarter of the book is a waste of time where it discusses various reporting applications (mostly from Oracle) that don't even come with Essbase. The chapter that shows how to build a cube using Essbase Studio from a relational database does nothing to show you what Essbase is doing behind the scenes as it automates the build. Virtually no information on using the administrator console to build a cube such as how to implement a time dimension type. Also throughout the book there is a lot of fluff on getting information from users and gathering requirements which offer nothing from a technical aspect. After reading this book I have more questions than answers. This book shows that there are no shortcuts to reading the actual product manuals.

Once again, Mike Schrader and his co authors provide valuable insights and guidance that helps those with lesser proficiency to elevate their capabilities, to get it right the first time as well as to address historic issues. Thanks to all.

Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Oracle Press) Look Smarter Than You Are with Smart View and Essbase 11: An End User's Guide Multidimensional Digital Signal Processing (Prentice-Hall Signal Processing Series) The Multidimensional Traveler: Finding Togetherness or How I Learned to Break the Rules of Physics and Sojourn Across Dimensions and Time OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 (Oracle Press) OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) Oracle Procure-to-Pay Guide (Oracle Press) Oracle Database 11g & MySQL 5.6 Developer Handbook (Oracle Press) Oracle Database 12c The Complete Reference (Oracle Press) Oracle Database 12c DBA Handbook (Oracle Press) Effective Oracle by Design (Osborne ORACLE Press Series) Oracle Big Data Handbook (Oracle Press) Oracle E-Business Suite Development & Extensibility Handbook (Oracle Press) Oracle Solaris 11.2 System Administration Handbook (Oracle Press) Oracle Database 12c Install, Configure & Maintain Like a Professional (Oracle Press) Oracle Database 11g SQL (Oracle Press) Oracle Database 11g New Features (Oracle Press) ORACLE PL/SQL 101 (Oracle Press) Oracle RMAN 11g Backup and Recovery (Oracle Press) Oracle Database Ajax & PHP Web Application Development (Oracle Press)