Introduction:    The core of Business Intelligence Applications is Data warehousing and the core of Data warehousing is Data Mining. If we are speaking the technical aspect, Data Mining is gathering knowledge from Data. So Knowledge of Data Discovery also part of the Data Mining.  So Data mining is the important subject to know, if we are working in data warehousing. Definition of  Data Mining: Data mining is the...

Introduction: The constant growth of Data Analysis and Business Intelligence Applications, understanding OLAP and OLTP having the important Place. The design of Data Warehouse and Online Analytical Processing (OLAP) cubes is basically different than OnLine Transactional Processing (OLTP).  OLTP: Source of Data: OLTP is original Source of data that maintains the Day by Day transactions and processes for every Business. Purpose of Data: To run and control the fundamental business...

Data Warehousing & Need of DW:   Commonly Data warehousing is used by the companies to analyze the trends over the Time. In other meaning, data warehousing is used to view day-to-day operations of Business for a company, but its primary function is facilitating best decision making process resulting from long-term data overviews. For example, Business Process & Models, Forecasts, Business Reports and Projections can be made. Because...

Before going to work with Administration Tool, We have to know How to create ODBC Connection for our database. Using this connection only, we are importing all the data sources into the physical layer of RPD in Administration Tool. OBIEE is supporting almost all the datasources like Oracle, DB2, MS SQL Server, MySQL, XML and etc., In the following example, We will discuss How to make a connection with Oracle Database. 1. Go To Control Panel ->...

In this discussion you will get the information about the component of OBIEE 10g and relationship between all the components. 1. Clients2. Oracle BI Presentation Services3. Oracle BI Server4. Oracle BI Repository5. Data sources A Simple Architecture: We will discuss all the components one by one. 1. Clients: It provides access to Business Intelligence information via a Web Browser.The Best of Client is Oracle BI Answers and Oracle BI Interactive...