Art of BI: Web Catalog Statistics – New SampleApp – Quick Peek

By | In 11g, Art of BI, OBIEE | May 30th, 2012

If you’ve been looking at Oracle BI’s progress over the last few years, you know that the Oracle BI development team has been making a concerted effort to provide guidance about the Oracle BI platform, its integration capabilities with other software, and some best practices via the Oracle BI Sample App. Oracle BI 11g brought a very comprehensive new look and feel to the SampleApp endeavor along with a packaged development virtual image for those previously not so inclined to develop their own environments.

The latest SampleApp VirtualBox virtual machine image is due for release very shortly and I was glad to get my hands on a beta version of what is aimed to be SampleApp v205. I’ll try to host a quick series of post on what I think are the most powerful features, not only of the compiled SampleApp distribution but also of Oracle BI (and patch releases for that minor version) over the next few weeks.

I’d first like to highlight a solution introduced in the SampleApp that many organizations have been yearning to have at their control, Web Catalog Statistics. This is a rather vetted solution developed by the Oracle BI development team, complete with PL/SQL ETL processes, a set of database tables added to the BIPLATFORM schema for storage, and several dashboards front-ending the solution in a rather meaningful way.


General Idea

So, how many times have you or a client needed to see what dashboards or reports were not being utilized in your Oracle BI implementation? Or, which presentation columns belong to which Answers reports? And, which of those Answers/Analysis reports/request are on which dashboards? You get the idea. The Web Statistics functionality now available thanks to the Oracle BI development team allows you to answer these questions. It also ties into the existing (now enhanced w/ Usage Tracking system. So this not only is a statistics tool but also a impact lineage tool for high to low discovery. BICG has a tool called IMPACT which is the only deep-level impact analysis tool that I’ve seen for Oracle BI at since it tracks lineage all the way to the ETL mappings for OBIA implementations as well as some other bells and whistles. However, the new web statistics is a good addition to the Oracle BI toolset.

The Front-End

The SampleApp has a dashboard, WebCatalog Statistics which is fairly comprehensive of the solution. The dashboard tabs/pages range from Overview and Dormant Objects to Columns to Analysis. There are enough prompts to give a high reflection of the web catalog and its current inventory to usage state. It has some nice graphs, and out-of-the-box general analysis that get you started but once you look at the subject area you can understand that much more in the way of intuitive analysis and KPIs could be derived.



The Back-End

SampleApp V205 (beta) has a really nice model set in the RPD back-end.  In regards to the Web Statistics, the model for the related subject area is just an extension of the Usage Tracking Business Model.  In fact the tables used for Web Catalog Statistics are stored in the BIPLATFORM RCU generated repository schema.  This makes modeling easy. Also, joined in to the sample usage tracking model is the new auditing functionality of BI Publisher.  We cover how to achieve the BI Publisher auditing functionality in the Oracle BI 11g Book; keeping it all under Usage Tracking the Subject Area is just brilliant.




As with a lot of quick-win solutions using a native solution works great.  So, I was actually delighted to see that only three scripts (sh / bat) exist to create the schema tables, extract/refresh the web catalog reports, and refresh to schema tables with metadata.  The code uses PL/SQL and SQL*Loader with a version for both core OSs (Windows / *Nix).  I’m going with the assumption that all code under the SampleApp is still open source so you could of course tweak it for your solution, or operationalize it as Oracle does with a lot of their usage of open source software (Apache to OHS – I still love that one).

General Consensus

This is definitely a winner.  I was a little thrown off by the use of “Web Catalog Statistics” instead of what I understand as the go-forward naming convention, which would make it “Presentation Catalog Statistics”, but that’s just me. Again, it is no BICG IMPACT and when I first looked through the solution, it gave me chills reminding me of some of the initial work that went into development iterations prior to the release of MDSearch version 1.0.  However, I believe that every Oracle BI implementation going forward should in fact incorporate this Web Statistics solution without a doubt.  And, now that you can view the Physical SQL sent through the Oracle BI Server, now stored in the Usage Tracking table,  S_NQ_ACCT, the new Usage Tracking system is going to save people time and aspirin.

Contact Us
Christian Screen
Christian is an innovator in analytics and data warehousing design, best practices, and delivery. With more than fifteenyears of decision support and data warehousing with key experiences at Office Depot HQ, Sierra-Cedar, and Capgemini, he oversees the Oracle Analytics Practice which includes the technical development and delivery of Oracle BI collaboration software, data warehouse solutions, Oracle BI/EPM projects, and packaged analytics solutions at Datavail.

Leave a Reply

Your email address will not be published.
Required fields are marked (*).

2 thoughts on “Art of BI: Web Catalog Statistics – New SampleApp – Quick Peek”
  1. Hi – I was kind of amazed at all of the things in V207 – I do get confused as to what is officially part of the product, part of the Exalytics version of OBI and its monthly releases and what things SampleApp has added. Do you have any idea on that?

    Jeff M.

    1. Jeff,

      Thanks for the comment and yes I’m still alive although my posts are infrequent this year, thus far.
      The V207 contains the Oracle BI 11g product at the BP1 release. It has quite a few dashboards that illustrate and demonstrate the capabilities of the default out of the box tool. The best part is the RPD in my opinion as there are several techniques applies there that you can reference that aren’t used in many standard Oracle BI implementations such as Federation with OLAP, database functions, fragmentation, etc.
      In regards to the dot releases, as of this week they are at (gearing to I hope), the Exalytics and OBIEE releases are basically aligned. There are some features that are only engaged when the Exalytics mode is switched on but for the most part al patch releases since BP1 seem to be primarily bug fixes no enhancements.
      At this point I’ve recommended for clients to implement no further than and wait for unless there is a specific patch release that fixes a show stopper issue with their implementation.