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 ‘BMM Layer Objects’ Category

BBM Layer – Logical Table & LTS

Posted by Santosh Kumar Gidadmani on February 21, 2011

Logical Tables

· Logical tables exist in the BMM layer and represent fact or dimension data.

· Logical fact tables have a yellow icon and logical dimension tables have a white icon.

Logical Table: Properties

· Bridge table is checked to resolve many to many relations between the tables.

· Sources tab contains the LTS, keys tab contains primary key and foreign keys tab contain foreign keys.

· You can re-order the columns in the table.

· The logical schema defined in each business model needs to contain at least two logical tables and you need to define relationships between them.

· You can create the logical tables either by dragging the physical table or manually creating it on the BMM layer.

· When you drag physical tables (with key and foreign key relationships defined) to a business model, logical keys and joins are created that mirror the keys and joins in the physical layer.

Logical Table Sources (LTS)

· Logical table sources define the mappings from a logical table to a physical table. A logical table’s Sources folder contains the logical table sources.

· Logical table source can have more than one sources from the physical layer. For example, revenue information may come from multiple data sources in a business. So, you can add these three sources to one LTS with joins. Another example could be to combine detailed level data and aggregated data, the OBI server will fetch the best source when queried on the reports.

· When you create logical tables and columns by dragging from the Physical layer, the logical table sources are generated automatically.

Logical Table Source (LTS): Properties

· Double click on the LTS to open the LTS properties screen.

· The general tab contains name other sources with join relations.

· Use the Column Mapping tab of the Logical Table Source dialog box to build, view, or modify logical to physical column mappings.

· A mapping can also be used to specify transformations that occur between the Physical layer and the Business Model and Mapping layer (Example: changing an integer data type to a character type or find a percentage of sales per unit of population.

· The Content tab is used to describe the aggregation levels (logical level or by column), to mention the fragmentation content, filter data by using where clause section and also to select distinct values.

– Santosh

Posted in BMM Layer Objects, OBIEE 10g, OBIEE 10g RPD | 1 Comment »

BBM Layer Objects

Posted by Santosh Kumar Gidadmani on February 21, 2011

The Business Model and Mapping layer is where physical schemas are simplified and reorganized to form the basis of the users’ view of the data. It contains the business model definitions and the mappings from logical to physical tables. The main purpose of the business model is to capture how users think about their business using their own vocabulary.

BMM Layer Objects

· There can be multiple business models in this layer.

· The business model object is the highest-level object, and it contains logical tables, logical table sources, logical columns, logical keys etc.

· Logical tables also have a Sources folder that contains one or more logical table sources. These logical table sources define the mappings between the logical table and the physical tables where the data is actually stored.

· In the Business Model and Mapping layer, data is separated and simplified into facts and dimensions.

· Business Model and Mapping layer objects map to source data objects in the Physical layer.

· Use the naming convention to re structure the model for easy understanding.

– Santosh

Posted in BMM Layer Objects, OBIEE 10g, OBIEE 10g RPD | Leave a Comment »

%d bloggers like this: