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
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 184.108.40.206.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 220.127.116.11.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. Read more ›