Search This Blog

Saturday, September 15, 2012

Integrating Oracle Essbase 11.1.2.1 with Oracle Business Intelligence 11g


Integrating Oracle Essbase 11.1.2.1 with Oracle Business Intelligence 11g

Purpose

In this tutorial, you learn how to integrate Oracle Essbase (Essbase) with Oracle Business Intelligence Enterprise Edition (Oracle BI EE ).

Time to Complete

Approximately 45 minutes.

Overview

In this OBE, you learn how to connect to the Administration Tool, import the Essbase BISAMPLE cube into the Physical layer of the repository, build the Business Model and the Subject area, and create analyses from the objects in the Subject area.

Prerequisites

Before starting this tutorial, you should:
1.Have access to or have Installed Oracle BI Suite EE 11.1.1.5
2.Have access to or have Installed Oracle Essbase 11.1.2.1
3.Have access to or have installed the Oracle Sample Application for Oracle BI EE.
Note: This tutorial uses the Essbase BISAMPLE cube from the Sample Application for Oracle BI EE

Importing a Multidimensional Data Source into a Repository

In this topic, you import the Essbase BISAMPLE cube into the repository, create a business model and subject area, and verify the results in Analysis Editor. This topic describes how to use the Administration Tool, import cubes, and create the Business Model and Mapping and Presentation layers.

Starting Essbase Server


1.Select Start > Programs > Oracle EPM System > Essbase > Essbase Server > Start Essbase.
The Start Essbase command window is displayed.
2.Wait for processing to complete and for the command window to close.

3.Right-click the desktop taskbar and select Task Manager to open the Windows Task Manager.
4.Click the Processes tab.
5.Verify that an ESSBASE.exe process is visible.
Screenshot for Step
6.Select File > Exit Task Manager to close Windows Task Manager.

Importing an Essbase cube into the repository.


1.Select Start > Programs > Oracle Business Intelligence > BI Administration.
Screenshot for Step
The Oracle BI Administration Tool window is displayed.
2.From the toolbar, click the Open Online (Open Online) button.
Screenshot for Step
The Open Online coreapplication_OH601898404 dialog box is displayed.
Note: The name of the dialog box will differ depending on your installation.

3.Enter Admin123 into the Repository Password field and a valid username and password to access BI Server, and click Open.
Screenshot for Step
The BI Repository layers are displayed.
4.Select File > Import Metadata.
Screenshot for Step
The Select Data Source page of the Import Metadata wizard is displayed.
Screenshot for Step
5.From the Connection Type list, select Essbase.
Screenshot for Step
The page displays the Essbase connection fields.
Screenshot for Step
6.Enter the name of the Essbase server, a valid user name and password for the data source, and click Next.
Screenshot for Step
7.In the Data source view section, expand the data source node and select BISAMPLE.
Screenshot for Step
8.Click the Import selected (Import Selected) button.
Screenshot for Step
The BISAMPLE data source is added to the Repository View section.

9.Optional: In the Repository View section, expand the BISAMPLE data source to verify that all its metadata objects are added.
Screenshot for Step

10.Click Finish.
Screenshot for Step
The data source is added to the repository.

11.Optional: In the Physical layer, expand the added Essbase data source and verify that the BISAMPLE metadata objects are added.
Screenshot for Step

Exploring the multidimensional schema in the Physical layer


1.In the Physical layer, right-click the added Essbase data source and select Rename.
Screenshot for Step
2.Rename the data source to Essbase - BISAMPLE.
Screenshot for Step

3.Right-click BISAMPLE and select Expand All.
Screenshot for Step
Note: When you import metadata from Essbase data sources, the cube metadata is mapped to the Physical layer in a way that supports the Oracle Business Intelligence logical model. Metadata that applies to all members of the dimension, such as aliases, are modeled as dimension properties by default. Level-based properties, such as outline sort / memnor information, are mapped as separate physical cube columns in the dimension. Column types such as Outline Sort, Ancestor Ref, Member Key, Leaf, Root, and Parent Reference are used internally by the system and should not be changed.

Converting the Measure dimension to flat measures

By default, measures are imported as measure hierarchies. The cube contains a single measure column that represents all the measures. Alternatively, you can choose to flatten the measure hierarchy to view each measure as an individual column.

1.Right-click the BISAMPLE cube object and select Convert measure dimension to flat measures.
Screenshot for Step
All measures are now displayed under the BISAMPLE cube table as columns.
Screenshot for Step
2.From the BI Administration Tool toolbar, click the Check In Changes (Import Selected) button.
Screenshot for Step
The changes to the Physical layer are saved to the repository.

Verifying the connection to the Essbase data source


1.Expand the Customers physical dimension to select the Customer Segment level..
Screenshot for Step
2.Right-click Customer Segment and select View Members.
Screenshot for Step
The members of the Customer Segment level are displayed in a new window..
Screenshot for Step
3.Click Close.

Creating the business model


1.Drag the Essbase - BISAMPLE physical cube to the Business Model and Mapping layer.
Screenshot for Step
The business model and all its objects are created for you, including dimension hierarchies, logical dimension tables, logical fact tables, logical columns, logical joins, and so forth. Notice that the BISAMPLE logical table has a hash sign, indicating that it is the fact table in the logical schema.
2.Right-click the BISAMPLE logical table and select Rename. Rename the table as Fact-BISAMPLE.
Screenshot for Step

Creating the subject area


1.Drag the Essbase - BISAMPLE business model to the Presentation layer.
Screenshot for Step
2.Optional: Expand the Essbase - BISAMPLE subject area to verify its presentation tables.
Screenshot for Step
3.From the BI Administration Tool toolbar, click the Check In Changes (Import Selected) button.
A message prompting you to check for global consistency is displayed.
Note: 
BI Repository metadata must pass a consistency check before you can make the BI Repository available for queries.
Screenshot for Step
4.Click Yes.
A confirmation message stating that the business model is consistent is displayed. The message also prompts you whether to mark the model available for queries.
Screenshot for Step
5.Click Yes.
The Consistency Check Manager dialog box is displayed showing that no errors were found.
Screenshot for Step
6.Click Close.
7.From the BI Administration Tool toolbar, click the Save (Import Selected) button.
Screenshot for Step
The BI Repository is now ready for queries.

Performing Ad Hoc Analysis on the Imported Data Source


This topic shows you how to create ad hoc queries from the Essbase BISAMPLE subject area.

Creating a simple query


This subtopic shows you how to create an analysis. Analyses allows you to explore and interact with information, and present and visualize information using charts, pivot tables, and reports. You can save, organize, and share the results.
Requests that you create can be saved in the Presentation Catalog and integrated with any Oracle BI home page or dashboard. Results can be enhanced through charting, result layout, calculation, and drill down features.
1.In the browser, enter the following URL to access Oracle BI:

http://<server_name>:7001/analytics
Screenshot for Step
The Oracle Business Intelligence Sign In window is displayed.
2.Enter your user ID and password to sign in to Oracle BI.
Screenshot for Step
The Oracle BI Home page is displayed.

3.Click Analysis to select a subject area.
Screenshot for Step
4.Click Essbase - BISAMPLE.
Screenshot for Step
5.Expand Fiscal and double-click Gen3,Fiscal.
Screenshot for Step
Gen3,Fiscal is added to the Selected Columns pane.
6.Expand Products and double-click Brands.
Screenshot for Step
Brands is added to the Selected Columns pane.
7.Expand Fact - BISAMPLE and double-click Gross Revenue and Gross Margin..
Screenshot for Step
Gross Revenue and Gross Margin are added to the Selected Columns pane.
8.Click the Results tab.
Screenshot for Step
By default the query results are displayed in the Compound Layout format that includes Title and Table sections.
9.Click the Edit View (Edit View ) icon in the Title pane. In the Title text entry box, enter Revenue and Margin Report by Brand. Deselect the check box forDisplay Saved Name. Click Done.
Screenshot for Step
Your title is added to the report.
Screenshot for Step

Creating a simple chart


1.Click the New View (Edit View ) button and select Graph > Bar > Horizontal.
Screenshot for Step
The horizontal bar chart is displayed below the table.
Screenshot for Step
2.Click the Save Analysis (Edit View ) button to save your report.
Screenshot for Step

3.In the Name field enter Revenue and Margin Report by Brand and click OK.

Summary

In this tutorial, you have learned how to:
  • Import an Essbase data source into a BI repository
  • Perform an ad hoc analysis on an Essbase data source

Resources

  • To learn more about OBI EE and Essbase, refer to additional OBEs in the OLL Web site.

3 comments:

  1. Dear Zafar,
    Its Good Article,but can you share one PPT For Fusion Beginner.

    Thanks
    Vikas Rai

    ReplyDelete
  2. Please refer my latest Post.... vikas

    ReplyDelete
  3. OBIA online training Evanta technologies provide you the best OBIA online training with step by step procedure for installing, customizing and configuring of OBIA.

    ReplyDelete