by Sridhar Kasthuri

Converting Hyperion Interactive Reporting (Brio) to OBIEE

What is Hyperion Interactive Reporting (Brio)?

Interactive Reporting was originally developed by Brio Software and distributed under several names including Brio Query, Explorer, Insight and finally Intelligence. In 2003 Hyperion acquired Brio and the product became part of the Hyperion Performance Suite. The Brio software adds an intuitive user interface that supports query, reporting, and alerting capabilities that were lacking in earlier versions of the Hyperion Performance Suite.

Why Migrate to OBIEE?

Enterprise and Comprehensive BI Functionality:

OBIEE is built on a unified infrastructure and architecturally designed for enterprise-level reporting with access to multiple data sources on a shareable enterprise data model.  By contrast, Hyperion IR/Brio had ambitions to be enterprise reporting tool but never succeeded because when you design reports in Hyperion IR each single report has it unique data module and provides no ability to do shared secure data caching between users.  It also failed to support query rewrites or aggregate navigation without writing a TON of custom JavaScript code.

Enterprise Performance Management (EPM):

For the future, Oracle is planning to integrate their enterprise BI tool (OBIEE) into the EPM cycle.  All the reporting features are going to be delivered by OBIEE.

Powerful User Experience:

Increase user adoption with a powerful, task-oriented navigation framework.  Features such as rich visualization, interactive dashboards, a vast range of animated charting options, OLAP style interactions, and innovative search and actionable collaboration capabilities deliver an unrivaled end-user experience.

Best-in-Class Scalability, Reliability and Performance:

Optimize performance while simplifying systems configuration and lifecycle management. An integrated systems management console provides superior scalability, high availability, and security benefits, while making upgrades and systems management effortless.

Hyperion Interactive Reporting (Brio) to OBIEE Conversion Process

Oracle has developed a migration utility that converts Hyperion BQYs to OBIEE Answers requests.  This can help facilitate a move to a standard OBIEE platform that is less time consuming and less costly.  Oracle Hyperion Interactive Reporting Translation Workbench is a utility that merges information about database schemas (the Physical Layer found in an RPD) with the Query Request model and reporting information found in BQY files to create Business and Presentation Models for an OBIEE Repository (RPD file) plus the requests and views that implement broadly equivalent BQY reports using Answers.

The utility can sometimes give undesirable results but logs are provided and modifications can be made accordingly. The diagram above shows the high level process of conversion from Oracle Hyperion Interactive Reporting (Brio) to OBIEE

1. Generate OBIEE Physical Layer from data sources - physical tables, columns etc.

2. Accumulate BQY DM dimensions (Stars/Snowflakes) and extend OBIEE physical layer.

3. Tune stars schemas, edit standard names and presentation folders.

4. Regenerate BI Repository(i.e. with BMM and Presentation Layer) that supports BQY reports

5. Generate OBIEE user interface objects like- filters, prompts, pivots and charts. Validate the results and edit partly translated reports constructs.

Below are the various Hyperion Interactive Reporting metadata objects and how the utility handles the translation process.

Sridhar Kasthuri is a Principal Consultant at KPI Partners who specializes in Oracle Business Intelligence Enterprise Edition (OBIEE) and the Oracle BI Applications. He is considered an expert in the area of business intelligence tool migrations.  His resume includes MicroStrategy to OBIEE migrations, Brio to OBIEE migrations, and the world's largest conversion of Business Objects to OBIEE.   Check out Sridhar's blog at KPIPartners.com.