Oracle® Business Intelligence Server Administration Guide > Planning and Creating an Oracle BI Repository > Process of Oracle BI Repository Planning and Design >

About Repository Planning and Design


This topic is part of the Process of Oracle BI Repository Planning and Design.

Before you create a repository or modify the repository that was shipped with Oracle Business Intelligence, you need to plan your business model and develop a design for the repository.

An Oracle BI repository has the following layers:

  • Repository Physical layer. You create this layer (schema) first from the tables in your physical databases.

    CAUTION:  Before you create the physical layer of your repository, you must thoroughly analyze and understand your business requirements, business data model, and your users so that you can set up the physical layer correctly. For more information, refer to Planning Your Business Model.

  • Repository Business Model and Mapping layer. After you set up the Physical layer, you can create the Business Model and Mapping layer by dragging and dropping the Physical layer onto the Business Model and Mapping layer. This preserves the mapping that you established in the Physical layer.
  • Repository Presentation layer. After you set up the Business Model and Mapping layer, you can create the Presentation layer by dragging and dropping the Business Model and Mapping layer onto the Presentation layer. This layer provides the objects that the end user will access through an application such as Oracle's Siebel Marketing.

Customization involves modifying the Physical, Business Model and Mapping, and Presentation layers. This is a sensitive task and should be done very carefully. It is recommended that you use the information in this chapter when designing and customizing your Oracle BI repository.

Oracle® Business Intelligence Server Administration Guide Copyright © 2007, Oracle. All rights reserved.