Oracle BI Solutions & Technology

Oracle BI offerings focuses on pre-built BI Solutions and the underlying BI/DW technology.

1. Oracle BI Solutions can be classified under the two major categories BI Applications and the Performance Management applications.

1.1 BI Applications (formerly Siebel Analytics) are pre-built Out-of-the-Box analytics application with data being fed from the the Oracle ERP suite such as E-Business suite, People soft, Siebel, and JD Edwards. It delivers intuitive and role-based intelligence for everyone in the organization.

- BI Apps are developed using the OBI technology
- ETL scripts, BI Report & Dashboards, Data Warehouse repository and the Metadata repositories are delivered using the OBI technology offerings (exception is ETL, it uses Informatica)

1.2 Performance Management (formerly Hyperion) are integrated applications that support the entire financial management cycle of goal-setting, modeling, planning, monitoring, analysis, and reporting.

2. Oracle BI technology includes the following Data Warehousing and BI Foundation & Tools

2.1 Data Warehousing tools includes ETL tool and the Oracle Database with Data mining, OLAP and database partitioning option.

2.2 Oracle BI Foundation & tools includes the comprehensive suite of enterprise BI products aka OBIEE Plus and Hyperion Essbase System 9 tools



I will elaborate on the Oracle BI solutions in my next post.

Define DW/BI ?

Two commonly used term in the BI world are, Data Warehousing (DW) and Business Intelligence (BI). Do they mean the same thing ? Both these terms are used interchangeably and intended to mean the same, but by definition they are not.

Data warehouse (DW) is the main repository of the organization's historical data. There are many reasons to build data warehouse, but the most important ones are

1. Reliable Reporting -The need for reliable, accurate and timely report based on data from disparate data sources


2. Better Performance - The critical factor leading to the use of a data warehouse is that a data analyst can perform complex queries and analysis on the information without slowing down the operational systems.


3. Intuitive - Keep the data model simple and intuitive for end users to build reports

Business intelligence (BI) is a business management term which refers to applications and technologies which are used to gather, provide access to, and analyze data and information stored about their company operations. Business intelligence software and applications includes range of tools.

1. Some BI applications are used to Analyze Performance, projects, or internal operations, such as Scorecarding; Business activity monitoring; Business Performance Management and Performance Measurement


2. User/End-user Query and Reporting


3. Enterprise Management systems; Executive Information Systems (EIS); Supply Chain Management; and Finance and Budgeting tools.


4. Other BI applications are used to store and analyze data, such as, Data mining; Forecasting; Document Management; Knowledge Management; and Dashboarding; Geographic Information Systems (GIS); Trend Analysis; Online Analytical Processing (OLAP) and multidimensional analysis; (based on the "hypercube" or "cube")

I will go into detail on the above mentioned BI applications in my future posts.