Creating a Project in OBIEE 11g

Create a Project in OBIEE

The next step is to create one or more projects. As mentioned above in the 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 areas 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).

 

 

Desired to gain proficiency on OBIEE Training? Explore the blog post on OBIEE  training to become a pro in "OBIEE Training Online"

 

 

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 the 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.

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 the 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: —Time —Products —Offices —Sales Person —Customers —Cust Regions —Orders —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.