Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 364,321 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for the ‘Administration Tool’ Category

OBIEE Administration Tool

Posted by Santosh Kumar Gidadmani on November 15, 2010

 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.

– Santosh

Posted in Administration Tool, OBIEE 10g, OBIEE 10g RPD | Tagged: | Leave a Comment »

%d bloggers like this: