OBIEE Tutorial

OBIEE 12c Repository : Introduction

OBIEE 12c Repository: Introduction

In this tutorial, you will read about the basics of OBIEE 12c Repository.

What is Repository?

The repository is the file that contain all metadata of the BI Server and is managed through the Administration tool.

The OBIEE repository database, known as a RPD file because of its file extension.

It stores all the information about the application environment:

  • Data modeling
  • Aggregate Navigation
  • Caching
  • Connectivity Information
  • Security
  • Metadata
  • SQL used by an OBIEE application

Physical Layer

  • This layer defines the objects and relationships that the Oracle BI Server needs to write native queries against each physical data source.
  • You create this layer by importing tables, cubes, and flat files from your data sources.
  • It also contains the connection definition to that database, or data source.
  • It has join definitions including primary and foreign keys.

Business Model & Mapping Layer

  • Represents the logical structure of the information in the repository.
  • The business models contain logical columns arranged in logical tables, logical joins, and dimensional hierarchy definitions.
  • This layer also contains the mappings from the logical columns to the source data in the Physical layer.

Presentation Layer

  • Presents the tables and columns to end users.
  • There is no additional logic, other than security rules, being applied at this layer.
  • The main purpose of the presentation layer is to organize content for users in a way that is most meaningful.
  • It also gives the OBI developer an easy way to see how the output will look without having to toggle between the RPD and the OBI user interface.

Features of Repository

  • Support for Unbalanced (Ragged) ,Skip-Level, Parent-Child Hierarchies
  • Creating Subject Areas for Logical Stars and Snowflakes
  • Multicurrency Support
  • Enhancements for Multiuser Development and Repository
  • Metadata Repository File Encryption
  • Metadata Repository File Compression
  • Embedded Database Functions
  • SQL Functions for Time Series Calculations and Level-Based Measures
  • Support for Calculated Members
  • Access to Essbase Data Sources

Steps to create a  Repository

To create repository in OBIEE, you need Administration tool of Oracle Business Intelligence Client.

For accessing BI Administrator Tool go to

Start-> All programs-> Oracle Business Intelligence Client-> Administration

Administration Tool is used for creating repository, open repository in online or offline mode.

In online mode, the administrator edits a live repository that the server has in memory; that is, users can still access the repository while changes are being made. Changes to the repository are immediately applied to the server when they are checked in.

In offline mode, the administrator can edit any repository and save the changes. The changes are applied when the BI Server next starts and loads the repository into memory.

Step1: Open the Administration Tool.

Step2: Select File > New Repository.

Step3: Select the Binary method

Step4: Enter a name for the repository

Step5: Leave the default location as is. It points to the default repository directory.

Step6: Leave Import Metadata set to Yes.

Step7: Enter and retype a password for the repository.

Step8: Click Next.

Hence you successfully created the repository. In next tutorial you will learn about building the physical layer of the repository.

One Reply to “OBIEE 12c Repository : Introduction”

Leave a Reply