Oracle Business Intelligence Essbase Cube Builder:
Oracle is focusing on improved consolidation of their BI applications offering within Oracle’s arsenal of BI apps will allow for enhanced integrations between the multi-dimensional and relational worlds of Essbase and OBIEE.
The new application is called Oracle Business Intelligence Essbase Cube Builder (OECB) previously referenced as Oracle Essbase Integrator (OEI) during beta testing and its purpose will help refine and make for more consistent binary integrations.
WHAT IS ORACLE ESSBASE CUBE BUILDER (OECB)?
Oracle Essbase Cube Builder will permit OBI apps to push metadata and data into Essbase cubes, a significant advancement for OBIEE users where leveraging in-depth ad hoc and what-if scenarios can be available.
OECB will bestow an integrated BI platform that supports OLAP capabilities and dashboards among others. OECB will also allow Essbase to leverage metadata and data from OBI and OBI apps. Other supports will include what-if scenarios, allocations, spreading, changing attributes, and multiple hierarchy comparisons.
WHERE IS THIS AVAILABLE?
All of this becomes available starting with version 11.1.2. Prior versions will also become available after the official release of OECB.
Essbase Cube Builder Business Processes:
The following process flow illustrates the Cube Builder business processes.
Essbase Cube Builder business process flow
Essbase Cube Builder Implementation
Essbase Cube Builder implementation can be divided into the following phases:
• Designing cube metadata.
• Defining connection definitions.
• Creating dimensions.
• Creating an outline.
• Building cubes.
Products / Options
HOW CAN I USE ESSBASE CUBE BUILDER?
From a user’s perspective, OECB will provide seamless authentication from OBI to Essbase which reduces maintenance and improves the user experience.
• Users can also feel confident that metadata and data will have the same context across platforms which mean users will see the same dimensions, members and measures between their OBI and Essbase apps.
• The environments will be synchronized as updated changes will be retained and applied with data values matching between the two apps.
• OBI dashboard metadata and data contents will be synchronized to Smart view.
• OBI physical/business model and mapping/presentation layers will be synchronized to Essbase & is also used for robust development.
No comments:
Post a Comment