Oracle Business Intelligence 11g Developers Guide and over 2 million other books are available for Amazon Kindle . Learn more
£54.99
FREE Delivery in the UK.
Only 10 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Quantity:1
Trade in your item
Get a £11.25
Gift Card.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Oracle Business Intelligence 11g Developers Guide Paperback – 1 Nov 2012


See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£54.99
£23.50 £24.00

Frequently Bought Together

Oracle Business Intelligence 11g Developers Guide + Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial + Star Schema The Complete Reference
Price For All Three: £137.97

Buy the selected items together


Trade In this Item for up to £11.25
Trade in Oracle Business Intelligence 11g Developers Guide for an Amazon Gift Card of up to £11.25, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 1088 pages
  • Publisher: McGraw-Hill Osborne (1 Nov 2012)
  • Language: English
  • ISBN-10: 0071798749
  • ISBN-13: 978-0071798747
  • Product Dimensions: 18.8 x 5.3 x 23.4 cm
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: 274,902 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

About the Author

Mark Rittman, Oracle ACE Director, is Technical Director and co-founder of Rittman Mead, specializing in BI, DW and EPM solutions using Oracle Business Intelligence, Oracle Database, Oracle Data Integrator and Oracle Essbase. Mark is a strong supporter of Oracle user groups around the world, was previously an executive board member of ODTUG and speaks regularly at conferences in the UK, Europe, USA and around the world. Mark also writes for the Rittman Mead blog (http://www.rittmanmead.com/blog) and contributes a regular column on business intelligence for Oracle Magazine.


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

4.5 out of 5 stars
5 star
2
4 star
2
3 star
0
2 star
0
1 star
0
See all 4 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

2 of 2 people found the following review helpful By Alexander Hansal on 8 Oct 2012
Format: Kindle Edition
To put it straight: Many years will pass before we will witness another masterpiece like this. This book is epic and a total MUST for anyone who works with OBIEE 11g.

So what more can I say? Let's have a quick tour around the book.

If you're expecting getting spoon-fed with droplets of wisdom, forget about it. Did I mention, the tome is more than 1000 pages heavy? But somehow Mark managed to compress - yes, compress - the obscene amount of information and functionality in and around OBIEE 11g into not more than 12 chapters. That alone is an accomplishment in itself.

Chapters 1 and 2 give a architectural background and installation guide. Mark of course doesn't miss any details.

Chapter 3, Modeling Repositories is probably the pivotal chapter of the book. If you have only time to read one chapter, then read this one. I was especially intrigued by the detailed information Mark shares with us on advanced modeling techniques.

After a chapter on multi-dimensional sources such as Oracle Essbase, Mark shifts gears and goes into BI Server Configuration.

Chapters 6 and 7 deal with the front end matter and again, Mark stands up to his reputation with stunning insight on everything you can do with analyses, dashboards, KPIs, agents and the action framework.

Chapter 8 talks about OBIEE security and it's good to see that Mark goes the extra mile to explain in depth how to set up row based security and MS Active Directory integration (apart from all other goodness of course).

In chapter 9, it's BI Publisher time. Chapter 10 gives us all the information we ever need on Systems Management.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 4 people found the following review helpful By Abhinav Agarwal on 6 Dec 2012
Format: Paperback
Writing a book on the Oracle Business Intelligence suite is a tall order. At more than a thousand pages, this book measures up to the task, literally, and as you will read this book - figuratively also.

So, have I read the entire book? No. I have not. It is close to 1100 pages long, and I have read parts of it, and skimmed through much of the remainder. Why am I writing this review before I have read the entire book then, eh? Well, to be honest, reading the entire book is going to take longer than I thought. I have had this electronic version of the book for several weeks now, and I was starting to feel like I should put something out lest I let the year end and a new year begin. For what it's worth, I do hope to keep adding new posts as I read through the unread portions of the book. So take this as a caveat. Anything else? Yes, one more, though more of a disclosure.

Disclaimer: I received a free e-book version of this book, courtesy Mc-Graw Hill, and thanks to Mark Rittman. I also, separately, and later, obtained access to an online version of this book via a subscription to Safari Books Online [...].
Also note that I am reviewing this book in my personal capacity, and not representing Oracle in any way.

Anything else? Yes, one more disclosure. I am a product manager with the Oracle Business Intelligence group, and have worked to bring some of the products and features covered in this book. That is guaranteed to bias my review, in what ways I don't know. Read and let me know.

So who is this book aimed at? Everyone. No, really. Everyone working with Oracle's BI toolset, to be sure. This includes people who have worked with the 10g version and expect to, if haven't already, moved to 11g.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
By Jordi Miquel on 17 Dec 2012
Format: Paperback
- I chose this rating since this book is a reference for the most important topics in OBIEE 11g
- The target of this book are: obiee developers, consultants and project managers.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
By MoggerhangerMark on 27 Sep 2014
Format: Paperback Verified Purchase
Excellent book
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 30 reviews
10 of 12 people found the following review helpful
Your One-Stop Guide to Oracle BI 11g 6 Dec 2012
By Abhinav Agarwal - Published on Amazon.com
Format: Kindle Edition
Writing a book on the Oracle Business Intelligence suite is a tall order. At more than a thousand pages, this book measures up to the task, literally, and as you will read this book - figuratively also.

So, have I read the entire book? No. I have not. It is close to 1100 pages long, and I have read parts of it, and skimmed through much of the remainder. Why am I writing this review before I have read the entire book then, eh? Well, to be honest, reading the entire book is going to take longer than I thought. I have had this electronic version of the book for several weeks now, and I was starting to feel like I should put something out lest I let the year end and a new year begin. For what it's worth, I do hope to keep adding new posts as I read through the unread portions of the book. So take this as a caveat. Anything else? Yes, one more, though more of a disclosure.

Disclaimer: I received a free e-book version of this book, courtesy Mc-Graw Hill, and thanks to Mark Rittman. I also, separately, and later, obtained access to an online version of this book via a subscription to Safari Books Online [...].
Also note that I am reviewing this book in my personal capacity, and not representing Oracle in any way.

Anything else? Yes, one more disclosure. I am a product manager with the Oracle Business Intelligence group, and have worked to bring some of the products and features covered in this book. That is guaranteed to bias my review, in what ways I don't know. Read and let me know.

So who is this book aimed at? Everyone. No, really. Everyone working with Oracle's BI toolset, to be sure. This includes people who have worked with the 10g version and expect to, if haven't already, moved to 11g. It includes people with such roles as administrators, metadata modellers, report authors, dashboard authors, and more. This is basically the big kahuna.

This book adopts a bottom-up approach, which is quite the sensible thing to do when organizing a book for the business intelligence developer. While talking about and presenting to an audience, I have found it useful to adopt a top-down approach, since it makes the audience understand how something they see has being built, that approach is likely to confuse and frustrate the developer. So, the book literally starts with the installation pre-requisites - yes, what you need to install before you install the Oracle BI software. The first hundred pages of the book are spent in covering the basics of business intelligence, how the product came into being, what it is composed of, and the installation.

Each subsequent chapter can be looked at both thematically and from a product perspective. So, for example, Chapter 3, "Modeling Repositories Using Relational, File, and XML Sources", and Chapter 4, "Creating Repositories from Oracle Essbase and Other OLAP Data Sources" cover how to model the metadata repository - as a theme. As a product, these two chapters are focused much on the "Admin Tool". Chapter 6, "Creating Analyses, Dashboards, KPIs and Scorecards", is all about creating the analytic content that end-users will work with, and it covers the Answers, Interactive Dashboards, and the Scorecard and Strategy Management (OSSM) products.

1 Oracle Business Intelligence Overview and Architecture
2 Installation and Upgrading Oracle Business Intelligence
3 Modeling Repositories Using Relational, File, and XML Sources
4 Creating Repositories from Oracle Essbase and Other OLAP Data Sources
5 Configuring and Maintaining the Oracle BI Server
6 Creating Analyses, Dashboards, KPIs and Scorecards
7 Actionable Intelligence
8 Security
9 Creating Published Reports
10 Systems Management
11 Managing Change
12 Oracle Exalytics In-Memory Machine

The 11g release of Oracle BI EE was a big, major, big upgrade from the previous 10g version. Several "things" got added, several things got changed, many pieces in the plumbing changed, and in general, it fulfilled all requirements of being a big release. The install procedure changed. The underlying middleware changed. The way security worked changed. New products got added to the suite. New capabilities. New products integrated with the suite. A new charting engine for instance. It is therefore heartening to see that the section titled, "Upgrading the 10g Repository (RPD) and 10g Web Catalog (Presentation Catalog)", covers this topic in detail, while also describing "What Happens During the RPD and Catalog Upgrade?", and listing some of the more common error messages and suggested resolutions.

So it comes to pass that Chapter 3, "Modeling Repositories Using Relational, File, and XML", starts at page 101. This is really the chapter that many will actually want to start with straightaway. Within this chapter, there is an example that is worked through, "Example: Creating the Oracle BI Repository", which should make it simple for users to follow through and try on their own. Apart from the expected, introductory material, you will also find coverage of the Aggregate Persistence feature, which is one of the key enablers of Exalytics, of "Advanced Repository Modeling Concepts", which describes how to create skip-level as well as ragged hiearchies, federation (cross-database modelling). For those wanting details on mulit-dimensional data modeling, fear not, worry not, because Chapter 4, "Creating Repositories from Oracle Essbase and Other OLAP Data Sources", is exactly what the data doctor ordered. In case you didn't know, Oracle BI supports four different OLAP data sources, including Oracle Essbase, Oracle Database OLAP Option, SAP BW, and Analysis Services. While some years ago, OLAP was a sine-qua-non for achieving high-performance querying on large datasets, advances like in-memory databases (like Times Ten), massive amounts of memory (think terabytes of RAM, not gigabytes), engineered systems (like Oracle Exalytics and Oracle Exadata), as well as continuing improvements to data warehousing technologies have meant that ever-faster performance can be achieved on ever-larger databases. In this chapter, I think the most space is devoted to Essbase. The last chapter in this section is chapter 5, "Configuring and Maintaining the Oracle BI Server", which, as you would expect, treads the areas like the configuration settings (the NQSConfig.INI file) - some that are manually maintained while others can be managed via Enterprise Manager. Also along for the ride are topics like managing the Query Cache, Usage Tracking (important topic, as you would expect), Aggregate Persistence - also an important topic.

If you are an Oracle BI developer who works more on the front-end, i.e., develop reports and Dashboards, then Chapter 6, "Creating Analyses, Dashboards, KPIs and Scorecards", is the one for you. It's a long chapter, as it needs to be, since you cover the Answers, Interactive Dashboards, and the Scorecard and Strategy Management products. This chapter is a long one, as it needs to be, and starts out with the Answers product, and goes through the basics of creating analyses, from the criteria tab, editing formulae, creating views - like graphs, tables, etc... On the subject of graphs, one trick that I think Mark missed out is that the images and screenshots in the ebook version - I don't know about the physical book - are in grayscale, and not distinguishable from each other. Colors with different brightness levels would have worked better. Yeah, you can tell, can't you, I work with data visualizations.

A bane of writing books for software applications is that often a new product comes out by the time the book goes to market, and thus some things are already out of date. Mark has done a tremendous job of keeping up with the various releases of Oracle BI EE as he wrote his book, but in some cases a few things fell through the cracks, I think. Like with spatial data visualizations, or Map Views, as they are called in the Oracle BI suite. First, some of the interaction designs were cleaned up in Map Views, so they look much cleaner. The screenshot for a map view I spotted was from an older release:

Secondly, the 11.1.1.6.0 release introduced support for "feature themes" in Map Views. Feature themes are simply spatial themes, imported into the BI metadata, but which do not have any keys that can be mapped to BI columns from your repository. I will write a detailed post on Feature Themes later, but it is a useful feature if you plan on using Map Views in your application.
Thirdly, the 11.1.1.6.2BP1 release also introduced support for line geometries - a third type of spatial geometry, the other two being polygons and points. Then there are some minor but useful enhancements like the ability to specify a transparency level for color fills. Small things that are easy enough to miss in all the releases and updates that happen in the world of Oracle BI. Perhaps Mark would consider an ebook update sometime in 2013 to his book?

You may think, as you go over Chapter 6, that the area of the "Action Framework", a major new feature in the 11g release, has been given short shrift. Far from it - there is an entire chapter devoted to it - Chapter 7, "Actionable Intelligence". And for good reason - there is much to be covered in Actions, that can be created and configured to do simple things like navigate to a URL, or open content from your BI catalog, but also very powerful things like invoke a web service, a Java method, a server script, an HTTP request, and so on. The premise of the Action Framework is to help close the Insight-to-Action loop, i.e. from a Dashboard, where insight is gained, allow the analyst to take action based on this insight by invoking the appropriate Action.

How security works in the 11g release of Oracle BI underwent a major revamp. It is very important, if you are working with building the appropriate access privileges and configuring security in Oracle BI that you read Chapter 8, "Security", very carefully. Pay careful attention to the section, "Understanding Oracle Business Intelligence Security Infrastructure, Application Roles, and Application Policies", as well as the sections that follow.

Chapter 9, "Creating Published Reports", is all about Oracle BI Publisher. Another chapter to read carefully if you work with or have worked with the tool in its 10g release. This is another product in the suite that has undergone several major enhancements - whether it is how you construct the data model, or the Online Layout Editor (a replacement for the Template Builder for Microsoft Word plug-in), or even the enhanced level of integration with Oracle BI, especially in how BI Publisher reports can be embedded inside Dashboards.

If you are a serious Oracle BI developer, then at some point in your BI implementations you will need to deal with issues like change management, how to implement multi-user development (also referred to by the singularly glamorous acronym of MUD), how to move your metadata from one instance to another, and how to use version control tools with your Oracle BI metadata. Chapter 11, "Managing Change" (though this chapter title could also work just as well for the title of some management guru's book), is the chapter for you.

Chapter 12, "Oracle Exalytics In-Memory Machine", serves as an introduction to Oracle Exalytics, the latest addition to Oracle's family of engineered systems. At the time this book went to press, a final decision had not been taken, or communicated, as to which of these features would finally make it to the release. Hence a disclaimer in the chapter. So there is only a mention in passing on multi-panel visualizations, Trellis views - both the Simple and Advanced Trellis, as well as a visualization available within the Trellis View - microcharts, available as SparkLines, SparkBars, and SparkAreas. And on "go-less" prompts, and "autocomplete" prompts. As things stand, all of these features are available with the Oracle BI EE 11.1.1.6.2BP release - both as "software-only" and on Exalytics.

You should have gathered this much, if nothing else from my review so far, that this book is not meant for the casual user of Oracle Business Intelligence. You will be better served by perusing the several useful blogs that dot the interwebs. This book is meant for the serious BI developer, who needs to know the nuts and bolts of the Oracle Business Intelligence suite.

So all is good and exciting? Yes. Mostly. Mostly? So what did I not like about this book?
Well, let's get one thing right - this is an excellent book, and I daresay every Oracle BI consultant out there will end up buying, borrowing, or sharing a copy of this book. On the other hand, I can get crotchety and nitpicky at times. So let's continue the cribfest.

Firstly, I did spot a few errors; minor ones. For instance, on page 13, Mark writes that "Oracle announced in 2005 that what was previously called Siebel Analytics would now be adopted by Oracle Corporation as their strategic business intelligence platform..." The product name was actually "Siebel Business Analytics", and the decision was actually taken in early 2006, and communicated, first, to the business intelligence development teams, and then to other groups within Oracle. In December 2005, if memory serves me right, a technical evaluation of the Siebel Business Analytics stack had begun in earnest, and a recommendation was formulated. The external communication of this decision was sometime in March 2006, at an event held in New York. Or that "the core of the product itself can be traced back to groundbreaking work done by the nQuire team back in the mid-1990's." - nQuire started in 1999, and released their first version in 2001, and were acquired by Siebel in 2002/2003.
These are minor quibbles, and the precise dates of how nQuire and Siebel Business Analytics came to be Oracle BI are at best of historical interest at this point.
Or when the text says, "Oracle BI Office Oracle Business Intelligence comes with a plug-in to Microsoft Office 2003, 2007, and Oracle Office..." - there is actually a separate plug-in for Oracle Office. The Oracle BI Office Add-in cannot install on Oracle Office, nor does it work with Oracle Office. The paragraph also left out mention of the Smart View plug-in that comes with the ability to connect to the Oracle BI Server - it is admittedly basic functionality, and it is not part of the Oracle BI EE suite, so it may be ok to leave its mention out.

You will find almost no coverage of the Oracle BI Office Add-in, the Microsoft Office plug-in for Oracle BI EE, available for Microsoft Excel and PowerPoint. Nor of Smart View. While Oracle has communicated that its long-term strategy is to build out the analysis and integration capabilities of Smart View to access Oracle BI EE content, the Oracle BI Office Add-in continues to provide support for embedding and analyzing Oracle BI content.

The Oracle BI Mobile product also finds little mention. The 11.1.1.5.0 release of the Oracle BI Mobile product is covered, but the more substantive, and more functional release came with the release of the Oracle BI Mobile HD app for Apple iPad, which introduced much greater support for touch-based interactions, location intelligence support, true-fidelity rendering of Scorecard views as HTML5 components, and much more. Again, this is more a limitation of deadlines - the book, I gather, had to go to print by the time the 11.1.1.6.2BP1 release was going out the door.
Perhaps Mark will consider doing an ebook or online update to this book and include these topics.

The other issue, and perhaps the more substantive one, is that while the book is a veritable goldmine of information once you know Oracle BI, for the completely newcomer, it's a bit daunting. Perhaps some sort of a visual layout of how the book is organized - color coded perhaps - and an indicator at the beginning of each chapter or major section showing which part of the suite and functionality it covered would have eased the job of the newbie. It's a subjective opinion, but hey - as long as we're being negative, let's go the whole hog.

In closing, and after having spent a few hours with the book, I can say it's a mammoth effort that brings, perhaps for the first time in one complete book, all the resources that an Oracle BI developer could want. In short, an indispensable guide for the business intelligence developer.
5 of 6 people found the following review helpful
The DBA Handbook....but for Oracle BI 13 Oct 2012
By Antony Heljula - Published on Amazon.com
Format: Paperback
There are probably some who waited a long time for this book to be published but I don't think anyone who pre-ordered would be disappointed. The first thing that hits you is the amount of content - over 1000 pages and it is high-quality publishing.

It is not easy explaining technical aspects of Oracle BI in plain English (just try to read RPD consistency errors and you'll know what I mean!) but the author manages to articulate clearly in a way that all developers should understand.

Being very technical in nature and with so many wide ranging topics, you should not feel you have to sit and read this book from cover-to-cover, instead you should be comfortable with having it on your desk just like DBAs have their handbooks. When you need to learn about new concepts such as merging RPDs or modelling an Essbase cube then you have the information to hand when you need it. And there is a sample data set that can be downloaded for you to practice with whenever the time comes.

Although it is applicable to all developers, the people who would benefit most from this book are 1) developers who new or relatively new to Oracle BI 2) developers who are are experienced with 10g and are looking to upgrade to 11g and 3) developers experienced in one or two areas (such as dashboards) and are now looking to expand their knowledge. It would also be useful to team members such as Tech Team Leads, Solution Architects and Operations staff who are not full-time Oracle BI developers but who still need to understand the concepts and "lingo".

For those developers who are experienced, don't be disappointed if the book does not tell you how to model every type of complexity you might get in a relational data-model - it would be near-impossible. The same goes for reports/dashboards - there is no room for tonnes of pages showing every possible way to build a dashboard. But there should be enough other content to keep you happy though e.g. Security, Deployment, Exalytics, Action Framework.

In summary: This book is highly recommended. It is like a good speech.....it contains something for everyone.
5 of 6 people found the following review helpful
This is a Must Have for Anyone using OBIEE 11g! 27 Sep 2012
By Chris Claterbos - Published on Amazon.com
Format: Paperback
It has has taken a long time for a good OBIEE 11 book to come out, but well worth the wait. This is not just a "warmed over" documentation book, this book has "Meat" and is a must buy for all OBIEE 11g developers. This is one book that covers it all. Not only installation of all the various configurations but also covers all the features of the software with a focus on developers. Mark does a very good job telling how to do things, but also describes what is actually happening under the covers. The most recent version of the software, 11.1.1.6.2 BP1, is also covered along with a separate chapter on Oracle Exalytics. The book is large, over 1000 pages, and should be included in everyone's tookit.

Chris Claterbos
Technical Director
Vlamis Software Solutions
2 of 2 people found the following review helpful
Excellent Book 7 Jan 2014
By Dan Hotka - Published on Amazon.com
Format: Paperback
I found this book to be an excellent reference guide for the OBIEE product.

This book seems to cover the entire OBIEE product...from the repository work, querying data, through to publishing reports!

Important features is the complete coverage of creating repositories, including how to do this from various data sources. Mark has a complete section on configuration and maintenance of the OBIEE environment, then there is the reporting/dashboard/publishing side. Mark has tons of tips and techniques...parts of the product I need to know and he has working examples of.

I typically use the examples in the book as a learning curve for the feature I'm interested in.

I like the 'walk thru' approach Mark took to this book.

I teach classes on both the OBIEE Administration and End User sides...I use this book as a course guide for both classes because it is so complete.
2 of 2 people found the following review helpful
Very Good Book 13 Mar 2014
By CK - Published on Amazon.com
Format: Kindle Edition Verified Purchase
This is a very good book if you want to learn about OBIEE 11g. It covers all the basics and most of the advanced concepts of OBIEE. I certainly believe that this book will serve as a reference guide for many months to come whenever I have questions at work/job. One of the things I liked is that the author provides explanation of how things work behind the scenes in many places which enhances your knowledge. I know folks that worked in this technology for many years and still may not know the intricacies of the inner workings, this book would cover that gap.

I bought the kindle version of the book. Pictures could have been better as I couldn't zoom in/enlarge the pictures/figures in the laptop (atleast I couldn't). I had to use my iPad to zoom the picture and see the details. Overall, I benefited a lot from this book.
Were these reviews helpful? Let us know


Feedback