The OBIEE Administration tool is the main engine to develop RPDs and manage major OBIEE configurations. It provides a graphical representation of the three layers of a repository namely;
1 Physical Layer
2 Business Model and Mapping layer and
3 Presentation Layer
1. Physical Layer
The Physical layer contains information about the physical data sources to which Oracle BI Server submits queries. There can be one or more data sources in the Physical layer. It consists of Connection pool, Schema folder, Tables, Columns keys.
2. Business Model and Mapping Layer (BMM)
The BMM layer is used to simply and reorganizes the data to present a meaningful data model to form the basis for presentation layer. All the major calculations are made in this layer as per the customer requirements. This layer contains more business models to support the organization strategic goals. It consists of Business models, dimensional hierarchies, logical dimension tables, logical fact tables, logical table source, logical columns, and logical measures. The dimensional modeling star schemas are built using dimensions and facts. BMM layer objects map to source data objects in the Physical layer. Business models may map to multiple data sources, Logical tables may map to multiple physical tables, Logical columns may map to multiple physical columns etc. Some of the Major configurations like, time series, level based measures, MUDE, additional calculations, aggregations, fragmentations and partitions are made here.
3. Presentation Layer.
Presentations layer provides customized view of a business model to users. The columns are more meaningful in this layer as these are represented to end users for ad hoc reporting. Presentation layer objects map to objects in the BMM layer. A Model in the presentation layer is called presentation catalog and same model in the answers is called subject area. A presentation catalog can map to only a single business model. However, multiple presentation catalogs can reference the same business model. It consists of presentation catalog, presentation folder, and presentation columns.
Posts
