OBIEE - Projects

Obi Edition


A project consists of a discretely-defined subset of the metadata. Projects can consist of Presentation layer catalogs (subject areas) and their associated business model logical facts, dimensions, groups, users, variables, and initialization blocks. The Oracle BI Administrator creates projects so that developers and groups of developers can work on projects in their area of responsibility.

Obiee Repository Project Menu

To see this option, the repository must be open in offline mode.


The following is a list of some of the reasons you might wish to create projects:

  • Multiuser development. During the development process, you want to split up the work (metadata) between different teams within your company. You accomplish this by extracting the metadata into projects so that each project group can access a different part of the metadata.
  • Licensing. Prior to releasing a new software version, you want to make sure that only the metadata that is relevant to the licensed application is in a project and that everything is consistent and complete. You accomplish this by adding only the fact tables that are relevant to the application.

Obiee Server Project

Target levels, list catalogs, and presentation catalogs cannot be added to or removed from projects.

Although, in the left pane, it appears that you can add a presentation catalog, you are actually adding only the underlying fact tables. The presentation catalogs appear as choices only to make it easier for you to add the elements you want in your project. If you select a presentation catalog to add to your project, underlying fact tables of other Presentation catalogs will be automatically be added if needed to make the extract consistent.

Project are logical fact table centric

Project are logical fact table centric. This makes sure that project extracts are consistent and makes licensing much easier to manage.

How to extract a subset of a project ?

To perform an extraction of a project in a sub repository, you must install a Multi User Environnment and perform a check-out.

Discover More
Bi Server Architecture With Client
OBIEE - Fact table (of logical fact table)

Dimension tables are expected to store columns that cannot be aggregated whereas fact tables are expected to store measure columns that can be aggregated. As a general rule: don’t include...
Obiee Repository Options Mud
OBIEE - MultiUser Development Environment (MUDE - Projects)

By default, the Oracle BI repository development environment is not set up for multiple users. However, online editing makes it possible for multiple developers to work simultaneously, though this may...
Obiee Online Offline
OBIEE 10G/11G - Repository (RPD file)

The repository is the file that contain all metadata of the BI Server and is managed through the administration tool. It stores all the informations the application environment: the security, data...
Obiee 11g Project Uid
OBIEE 11g - extractprojects utility

This utility is used to extract projects from a given repository (B for base) to another repository (O for output). You can choose the project by name of by uid. where: Repository Options ...

Share this page:
Follow us:
Task Runner