Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Archive for the ‘DBI’ Category


Posted by Dylan Wan on October 5, 2011

Several people are curious about what are OTBI and OBIA, and what are the differences between OTBI and OBIA.  I will discuss these in this article.

OTBI stands for Oracle Transactional Buisness Intelligence. 

OBIA stands for Oracle Business Intelligence Applications.

Let’s start with OBIA.  OBIA is the pre-packaged BI Apps that Oracle has provided for several years.  It is the data warehouse based solution.  It is based on the universal data warehouse design with different prebuilt adapters that can connect to various source application to bring the data into the data warehouse.  It allows you to conslidate the data from various sources and bring them together.  It provides a library of metrics that help you measure your business. It also provides a set of predefined reports and dashboards.  OBIA works for multiple sources, including E-Business Suite, PeopleSoft, JDE, SAP, and Fusion Applications.

OTBI is different.  First of all, it is a real time BI.  There is no data warehouse or ETL process for OTBI.  Second, it is for Fusion Apps only.   OTBI is leveraging the advanced technologies from both BI platform and ADF to enable the online BI queries agains the Fusion Applications database directly.  In addition, in some area, such as Financial, you can also connect to the Essbase cubes.  Unlike OBIA, OTBI does not have a lot of prebuilt dashboards and reports.  The reason is that for some advanced analysis, the data need to be prepared.  You cannot get eveything you can get from the OBIA data warehouse in OTBI. 

Both OTBI and OBIA are available from the same metadata repository.  Some of the repository objects are shared between OTBI and OBIA.  It was designed to allow you have the following configurations:

  • OTBI Only
  • OBIA only
  • OTBI and OBIA coexist

If you implement Fusion Apps, you can enable OTBI.  You can use the BI EE Answer to access the prebuild metadata and metrics those are built against the Fusion Apps.  You may not get the full powerful prebuild dashboard and repost and prebuilt navigation workflow.  However, you can start experiencing what the BI EE based reports look like.  You can start bring the data out from your OLTP system.  You can provide training to the users to get familar with the subject areas, some of which are shared with OBIA. 

If you enjoy OTBI and want to further get OBIA with a data warehouse based solution.  You can implement OBIA later.  Some of the OTBI reports maybe switched to run against OBIA.  Some of OTBI reports can continue connecting to Fusion Apps directly.  They can coexist in a single BI server and a single BI answer client.

Both OTBI and OBIA are accessing Fusion Apps via the ADF.   This is a more advanced topic. 





Posted in BI, BI Application, BI Links, Business Intelligence, Data Warehouse, DBI, essbase, ETL, Infomatica, OBIA, OBIEE, Oracle, Oracle BI Suite EE, OTBI | 1 Comment »

BI Applications and Embedded BI, Part 2

Posted by Dylan Wan on December 5, 2007

This is a topic I wrote in six month ago. In the Part I of this series of articles, I mentioned that a warehouse like architecture is required in a heterogeneous environment. I want to elaborate more about this. In the future posts, I will also describe the integration technology I learned for supporting the embedded BI.

Read the rest of this entry »

Posted in BI, BI Work, Business Intelligence, Data Warehouse, DBI, hyperion, Oracle, PeopleSoft, Siebel Analytics | Tagged: , , | Leave a Comment »

Aggregation for Data Warehouse, Part 4

Posted by Dylan Wan on May 30, 2007

I have briefly mentioned the various approaches of providing aggregation for data warehouse. This post describes the third approach of using the Materialized View (Oracle) or Automated Summary Table (AST, DB2) from the database system.  I will describe the Pro’s and Con’s of using this approach.

A materialized view, like a table or a view, is a database object. A materialized view can contain the results of a query. It enables you to have a very efficient data access to the pre-aggregated data. It also helps you to maintain such aggregated data by simply defining the query, like creating a database view. Read the rest of this entry »

Posted in BI, BI Work, Business Intelligence, Data Warehouse, DBI, Oracle | 1 Comment »

What is a BI analytical application ?

Posted by Dylan Wan on February 28, 2007

A BI analytical application provides the following four key components:

  1. Pre-built ETL to extract data from the operational tables in the transaction system  and load to the data warehouse
  2. Denormalized Star schema which is optimized for BI queries
  3. Best practice metric and calculation libraries that are created based on the data warehouse and operational sources.
  4. Pre-built graphics, reports, dashboards, and alerts that designed for specific roles and business processes

It is actually a very lengthly process to build an BI analytical application.  That is why people now buy the pre-built BI analytical applications.

Posted in BI, BI Application, Business Intelligence, Data Warehouse, DBI, ETL, Oracle | Leave a Comment »

Bookings Analysis

Posted by Dylan Wan on February 18, 2007

Bookings Analysis is to help managers to manage the demand. Although the data may come from Order Management, Contract Administration, or Project Accounting systems, the primary interest in the booking analysis is from sales and marketing perspectives.

The analytics application should provide the bookings analysis to help demand managers understand the pattern of booked orders or work and the future revenue trends for the business, enabling the evaulation of current status against the expecation and the actions to increase sales, the deal size, volume of future pipeline.

Booking can be measured by quantities or dollars. Read the rest of this entry »

Posted in BI, BI Application, Business Intelligence, DBI, Oracle, Project Intelligence, Sales Intelligence, Service Intelligence | Leave a Comment »

The 4-4-5 Calendar

Posted by Dylan Wan on February 5, 2007

Some organizations use the 4-4-5 calendar for managing their accounting periods. it is a common calendar structure for some industries, such as retail.

The 4-4-5 calendar divides a year into 4 quarters. Each quarter has 13 weeks which are grouped into two 4-weeks “months” and and one 5-week “month”. The grouping of 13 weeks may be set up as 5-4-4 weeks or 4-5-4 weeks, but the 4-4-5 seems to be the most common arrangement.

When a 4-4-5 calendar is in use, reports with period by period comparison or trend over periods do not make much sense. You can still do the comparison of a period over the same period in the prior year. You can also have the week by week data comparison.

See also: The 13 period calendar

Posted in Business Intelligence, Data Warehouse, DBI | 4 Comments »

Oracle DBI vs. SAP BW from Edison Group, Inc.

Posted by Dylan Wan on December 11, 2006

I found a good white paper on a comparison of Oracle DBI and SAP BW:


Posted in BI, Business Intelligence, DBI, Oracle | Leave a Comment »

Building Oracle Daily Business Intelligence with Oracle BI Enterprise Edition

Posted by Dylan Wan on December 9, 2006

This is a white paper about how to build dashboard on top of Oracle Daily Business Intelligence summary tables using Oracle BI Enterprise Edition.


This is very helpful for all current Oracle E-Business Suite DBI users who want to add custom contents to their reports or dashboard. The most important content from this white paper is the list of all DBI physical tables.

Posted in DBI, OBIEE, Oracle, Oracle BI Suite EE, Siebel Analytics | 1 Comment »