Reporting with OBIEE & Essbase
Oracle Hyperion's Essbase is a fast and flexible multidimensional database and has been widely used for this reason. Similarly, reporting against Essbase has been in top demand because of the speed and efficiency of Essbase. However, there has been no single front-end reporting application that is integrated with Essbase to the extent of the Oracle Business Intelligence Enterprise Edition – OBIEE (BI Answers, BI Interactive BI Dashboard, BI Scheduler, and BI Publisher components). This combination may be the answer for many users who have seen this disparity in reporting.
Traditionally, those users who have worked with reporting tools realize that their complete need for reporting can’t be handled with a single application. Users either develop multiple front-end reporting applications to integrate into their business decision making or opt to go with less reporting. The trade off of doing more with different applications cost time and money while doing less doesn't give them fully utilized analysis of their data nor do they get a full return on their investment. In the Hyperion world, users are asked to create reporting views on a Hyperion Reports application for mid-level managers – a group who understands detailed data where they can pivot dimensions and see alternate views. But for senior management or C-level executives, a Web Analysis canned reporting view is a must because they are less familiar with the detailed data. While it has been acceptable and necessary to create reporting views of the same data on different applications in the past, OBIEE may solve this issue for the future.
OBIEE is a powerful reporting application that can also be utilized as a middleware tool to manage Essbase data and provide the same or similar reporting capabilities like Web Analysis, Reports, Interactive Reporting, and Crystal Reports all rolled into a single package. Within OBIEE, reports can be created for different types of users where data can be presented in many different layers for viewing but managed within a single application.
Options within OBIEE provide more robust capabilities that weren't possible before. Users find that they spend their development time creating a work around more often than not because their application can’t do this or is limited to that. This diminishes reporting empowerment for the user and also limits their full use of relevant data.
Oracle has managed to find a way to merge different technologies from different companies that make sense of reporting development while adhering to the demands and needs of users. The sooner users leverage these hybrid offerings, the sooner their data and their return on investment can be fully realized.
I'm open to your comments. Look for the next OBIEE article on how this integration between Oracle BI Enterprise Edition and Essbase is accomplished.
Michael Duong, Lead Consultant
Hyperion Essbase Certified
Ranzal & Associates