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 February, 2011

Consistency Check

Posted by Santosh Kumar Gidadmani on February 23, 2011

Consistency check is one of the process to check whether a repository is yielding proper results in Answer reports. It checks whether;
All logical columns are mapped correctly to physical columns.
All logical dimension tables have a logical key.
There are at least two logical tables in the business model; one is a logical fact table, the other is logical dimension table with join condition.
There are no circular logical join relationships.
A presentation catalog exists for the business model.

Consistency Check
You can check consistency for the entire repository or for a single objects.

Global Consistency Check (Entire Repository)
Navigate to File menu -> Check Global Consistency. This will open the Consistency Check Manager which checks for the entire repository.

The Consistency Check Manager identifies message type, the object type, and the object, and provides a detailed description of the message

Check for Single Model
Select any object and Navigate to tools -> Show Consistency Checker or Right click on any objects (Physical or BMM or Presentation model) and click on Check Consistency

This will check individual objects and not the entire repository.

Types of Checks
There are mainly three types of checks performed
1. Errors: Must be fixed to make the repository consistent.
2. Warnings: Condition that may or may not be an error.
3. Best Practice: Does not indicate an inconsistency.

Disable or Enable Consistency Check
Navigate to File menu -> Check Global Consistency > Option Tab.
Select any object in the list type of check and click on enable or disable.

– Santosh

Posted in Consistency Check, OBIEE 10g, OBIEE 10g RPD | Leave a Comment »

Presentation Layer Objects

Posted by Santosh Kumar Gidadmani on February 22, 2011

Presentation Layer

– The Presentation layer is built after the Physical layer and the Business Model and Mapping layer.
– The Presentation layer provides a means to further simplify or customize the Business Model and Mapping layer for end users.
– You can create Presentation layer objects by dragging objects from the Business Model and Mapping layer.

Presentation catalogs
– Presentation catalogs allow you to show different views of a business model to different sets of users.
– Presentation catalogs have to be populated with contents from a single business model.
– Multiple presentation catalogs can refer to the same business model.
– Presentation Catalogs can be created manually or by dragging the required from the BMM layer to presentation layer.
– Changes to the Presentation layer do not impact corresponding objects in the BMM layer.
– Presentation catalogs in the Presentation layer are seen as subject areas by Oracle BI Answers users.
Presentation Table
– Use presentation tables to organize columns into categories that make sense to the user community.
– A presentation table can contain columns from one or more logical tables. The names and object properties of the presentation tables are independent of the logical table properties.
– Presentation Tables can be created manually or by dragging the required from the BMM layer to presentation layer.
– Presentation tables contain presentation columns. Use the Columns tab in the Presentation Table properties dialog box to reorder, sort, or delete Presentation layer columns.
– To create a nested presentation table, prefix the name of the presentation folder to be nested with a hyphen and a space and place it after the folder in which it nests. When Answers displays the folder, it omits the hyphen and space from the folder name. It is possible to nest multiple folders under a single folder, however, only one level of nesting is possible.
Presentation Columns
– Presentation columns define the columns used to build queries in the Oracle BI user interface.
– Presentation columns can be created manually or by dragging the required from the BMM layer to presentation layer.
Presentation Alias
– An Alias tab appears on the Presentation Catalog, Presentation Table, and Presentation Column property dialog boxes. If you modify a Presentation layer object, this tab keeps track of any prior names.
– Aliases are used to maintain compatibility with previously written queries after an object has been modified.

– Santosh

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

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 »

%d bloggers like this: