Examining the ongoing challenges of delivering high-quality, value-added ERP services in Higher Education.

Wednesday, July 24, 2013

SmartView and OBIEE Integration At Last

With OBIEE we finally see the long-awaited integration of Hyperion Smart View with the Oracle Business Intelligence RPD and Web Catalog. For many users at my institution, SmartView has become an essential tool for ad hoc analysis of budget data in Excel. I have personally always thought there was tremendous (underutilized) promise in the other forms of Office integration -- embedding charts/reports in PowerPoint and refreshing executive presentations at the push of a button... It sells well in demonstrations, at least!

The advantages of SmartView go beyond Office integration in and of itself; from the standpoint of an internal service provider, I am thrilled about the opportunity to put a single ad hoc query tool in the hands of my end users. Standardizing on SmartView -- distant as that may be -- could be a game-changer for the more casual data analysts in my organization.

This long-awaited first release is not without its foibles (I've identified a dozen bugs or unexpected features in just an hour or two of experimentation). Still, there is a lot to be excited about. I want to highlight a couple of features, most notably publishing an ad hoc view created in Excel back into the OBIEE Web Catalog.

Embedding Existing Content
As you can see below, after connecting to an OBIEE instance you browse the Web Catalog as a tree. The lowest level for a single BI Analysis report shows the specific views within that Analysis -- the compound view plus each component.
You are presented with different options based on the node you select in the tree:
  • Compound View > Insert All views
  • Title > Insert
  • Chart > Insert or Insert as Image
  • Table > Insert or Insert as Excel Table
  • Pivot Table > Insert or Insert as Excel Pivot
The last two are very interesting; the "plain" insert basically dumps the raw data into Excel while the Excel Table/Pivot options give you a much richer experience within Excel. As shown below, the Excel table is formatted with auto-filters, saving the user a couple of steps.
I have been having some trouble importing charts and have to experiment more with the options around Prompt / POV manipulation, so look for another blog on that in the next few weeks.

Creating (and Publishing) Ad Hoc Analyes
The really important feature in this release is the View Designer. This interface allows the user to browse the RPD (Subject Areas) build a brand-new report. Various report formats are available (although I'm having trouble with most chart types; need to open SRs!)
Below see my ad hoc analysis rendered as an Excel table; note the default formatting and auto-filters.
If I like this view, I can publish the analysis back to the catalog by pressing the "Publish View" button in the ribbon; the system will ask me to designate a destination folder and file name.
The new report now displays in the tree on the right as a Compound View, Title, and Table.
And if I look at this report directly in OBIEE, you'd never know that it was created in Excel.
More analysis is required to fully understand what Excel changes "stick" when publishing, and I'm sure the functionality will evolve rapidly as Oracle keeps pouring R&D into OBIEE. But this release is certainly a step in the right direction!


At September 1, 2013 at 11:52 PM, Anonymous Seth said...

Smartview integration for OBIEE can be really handy. Thanks a lot for sharing.


<< Home