The next step is to create one or more projects. As mentioned above in Scenario, the primary reason to create projects is to support multiuser development. Administrators can create projects so that developers and groups of developers can work on projects in their own area of responsibility.

To create a project, perform the following steps:

1 . For this tutorial, SampleApp_BI0009.rpd, will be modified in the MUDE. You can use the most current offline version of your repository.

In the Administration Tool, click File --> Open --> Offline (or you can select the repository from the recent repository list).


2 . Enter the repository password (for example, Admin123) and click OK.

3 . Click Manage > Projects to open the Project Manager.


The Project Manager dialog box appears. Two projects are evident in the right pane: Samp Essbase and Samp Relational. These projects were defined as metadata objects in the Sample App repository that is shipped with the Sample Application.


4 . Click Action > New Project.


The Project dialog box appears. The Project dialog box is composed of two panes—the available objects are contained in the left pane, whereas the selected items are contained in the right. You build the project by adding subject areas or logical fact tables to the project. Additionally, the Project dialog box consists of a name text box (required entry) and a description text box (optional) for documentation purposes.


You can group facts by subject area or by business model. You can also select one or more logical fact tables in the business model that are related to the subject area or you can select a subject area. The Add button is enabled once an object is selected in the left pane.

The Administration Tool adds all the logical fact tables automatically. Adding a subject area includes all fact tables and dependencies in the subject area. Adding a logical fact table includes the subject area containing the table. In both cases, logical dimension tables joined to the logical fact tables are implicitly included, even though they do not appear in the right pane.

5 . Enter Sample Apps Fact Table in the project name text box.


6 . Click the plus sign ( ) to expand Business Models, and then expand 1 - Sample App.


7 . Select F0 Revenue Base Measures in the left pane and click Add. The logical fact table appears in the right pane.


Desired to gain proficiency on OBIEE 11g ? 

Explore the blog post on OBIEE 11g training online to become a pro in OBIEE 11g.

8 . Click OK. Your new project appears.


9 . Add a second project. Click Action > New Project.

10 . Enter Sample Apps Presentation in the project name text box.

11 . Click the plus sign ( ) to expand Business Models.

12 . Select 1 - Sample App and click Add.


Note: You must have at least one fact table in a project.

13 . Collapse Business Models. Click the minus sign ( ) for Business Models to gain more space in the left pane.

14 . Click the plus sign for Presentation to expand the Presentation node in the left pane.


The Presentation node contains Presentation layer objects that are not automatically added to your project. You must explicitly include these objects in your project, if you want to work with them.

15 . Select A - Sample Sales in the left pane and then click Add. Presentation (A - Sample Sales) appears in the right pane.


16 . Expand Presentation, and then expand A - Sample Sales in the right pane and take some time to review the structure.


17 . Click OK to add the new project.


18 . Double-click the Sample Apps Presentation project in the right pane of Project Manager to edit the project.

19 . Expand Presentation > A - Sample Sales in the right pane.

20  . Remove all but the following tables from the right pane:




—Sales Person


—Cust Regions


—Ship To Regions

—Orders Dates

—Base Facts

—Calculated Facts

Select the table that you want to delete (for example, Alternate Calendars) from the right pane, and then click Remove. Hint: You can press Ctrl-click to select multiple tables.

Your project selection should look like this:


21 . Click OK.

22 Click File > Save to save your changes to the repository. When prompted to check global. consistency, click No.


23 . Click File > Close to close the repository.

24  . Minimize the Administration Tool.

For indepth understanding of OBIEE click on