My Oracle Support Banner

Federating Essbase and Relational Data in Oracle Business Intelligence Enterprise Edition (Doc ID 1633146.1)

Last updated on SEPTEMBER 19, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.

Goal

 In this tutorial, you learn how to federate Oracle Essbase (Essbase) multidimensional sources with relational data sources supported in Oracle Business Intelligence Enterprise Edition (Oracle BI EE).

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Overview
 Prerequisites
 Building a Business Model to Provide Horizontal Federation
 Creating a Business Model from an Essbase Data Source
 Adding Relational Measures
 Creating Logical Joins in the Business Model: Products Dimension
 Creating a Subject Area and Saving the Repository
 Verifying your Work in Oracle BI EE
 Building a Business Model to Provide Vertical Federation
 Adding Relational-level Detail to the Months Logical Table
 Modifying the Months Hierarchy for Vertical Federation
 Mapping Facts to Multiple Sources and Setting Logical Levels
 Checking Vertical Federation in Oracle BI EE
 Summary
 Resources


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.