Dylan's BI Study Notes

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

Archive for January, 2007

What does Forrester say about Oracle Data Integrator (Sunopsis)?

Posted by Dylan Wan on January 27, 2007

Sunopsis’ ability to connect a wide variety of data sources and targets will allow Oracle to address the heterogeneous data management environments its enterprise architect customers must contend with.

This acquisition could be a big win for the Siebel, PeopleSoft, and JD Edwards customers who, following the acquisitions by Oracle, find themselves smack in the middle of a perhaps unwanted Oracle-dominated ecosystem.

Please read the entire paper here: Read the rest of this entry »

Advertisements

Posted in BI, DAC, ETL, OBIEE, Oracle, Oracle BI Suite EE, Oracle Data Integrator, OWB, Siebel Analytics, Sunopsis | Leave a Comment »

Sales Performance Report in SAP

Posted by Dylan Wan on January 27, 2007

I studied a sales performance reports found in SAP Sales Information System.

This report analyzes the monthly sales performance of a number of sales reporting structure. Read the rest of this entry »

Posted in BI Application, Business Intelligence, Sales Intelligence, SAP | 1 Comment »

Install Siebel Analytics – Step by Step Installtion Screenshots

Posted by Dylan Wan on January 24, 2007

Note added on Jun 21, 2007:  The  Siebel Analytcis is now called Oracle BI Applications.  The latest version is 7.9.x which can be installed on top of Oracle BI EE10.1.3.2.   Please go to the following link from Oracle to get the step by step instruction:

Read the rest of this entry »

Posted in BI, Business Intelligence, Data Warehouse, OBIEE, Oracle, Oracle BI Suite EE, Siebel Analytics | 2 Comments »

What does Gartner say about Oracle Data Integrator (Sunopsis)?

Posted by Dylan Wan on January 20, 2007

Sunopsis fits into Oracle’s longtime strategy of building operating-system- and hardware independent tools. Fusion Middleware customers have heterogeneous IT environments, Sunopsis have a positive influence on Fusion Middleware.

See details: Read the rest of this entry »

Posted in BI, Business Intelligence, Data Warehouse, ETL, OBIEE, Oracle, Oracle BI Suite EE, Oracle Data Integrator, OWB, Sunopsis | Leave a Comment »

Download Oracle Data Integrator (Sunopsis) from Oracle Technology Network!

Posted by Dylan Wan on January 20, 2007

Sunopsis has now renamed as Oracle Data Integrator and the evaluation version of the software is available for download here: Read the rest of this entry »

Posted in BI, Business Intelligence, Data Warehouse, ETL, OBIEE, ODI, Oracle, Oracle BI Suite EE, Oracle Data Integrator, OWB, Sunopsis | 2 Comments »

What is a Conformed Dimension?

Posted by Dylan Wan on January 18, 2007

A simple answer is that a conformed dimension is a dimension that is shared across fact tables.

A conformed dimension is important because it allows queries to be executed across star schemas. This activity is also called Drill Across. When you drill across, you are adding more data from another fact table to the existing rows.

Examples of obvious conformed dimensions include Customer, Location, Organization, Time, and Product.

Posted in Business Intelligence, Data Warehouse | 2 Comments »

Learning ETL – Mapping

Posted by Dylan Wan on January 17, 2007

Column level mapping is to define the transformation rule that maps columns from the source datastore to on of the target datastore column.

Many ETL tool nowady can automatically map a column from the source to one in the target if they have the same name. Most of the ETL tool also allow you to drag and drop column from the source to the target to define the mapping.

Here are some types of mapping: Read the rest of this entry »

Posted in BI, ETL | Leave a Comment »

Learning ETL – Architecture

Posted by Dylan Wan on January 15, 2007

The central component of any ETL tool is the repository. It typically stores the metadta for all applications, including both source and target systems. It also contains the business logic about mapping and transforming the data from one to the other. Read the rest of this entry »

Posted in BI, Data Warehouse, ETL, OWB, Sunopsis | 1 Comment »

How does Oracle BI Enterprise Edition support Slowly Changing Dimensions (SCDs)?

Posted by Dylan Wan on January 15, 2007

You need to handle the SCD in your data warehouse schema design. The technique you use will probably affect your ETL process startegy. It will also affect how the BI tool querying your data.

OBIEE is not a ETL tool. It provides the tool, DAC – Data Warehouse Administation Console for managing and monitoring the ETL processes, but its focus is really on the logical data modeling and data access. You need to define how a fact table and a dimension table are joined in OBIEE. Read the rest of this entry »

Posted in BI, Business Intelligence, Data Warehouse, ETL, OBIEE, OLAP, Oracle, SCD | Leave a Comment »

How to handle Slowly Changing Dimensions (SCDs) in data model design?

Posted by Dylan Wan on January 13, 2007

There are multiple methods to handle the slowly changing dimensions. Which technique to use depends on your business requirements. The choice among these three methods are not a technical design decision since their behaviors are different.

Type One: Overwite the old data with new data

Using this method, you do not store the histoy. For example, that say each customer can Read the rest of this entry »

Posted in BI, Data Warehouse, OBIEE, Oracle BI Suite EE, SCD, Siebel Analytics | 1 Comment »

What are slowly changing dimensions?

Posted by Dylan Wan on January 11, 2007

Slowly changing dimensions are used to describe the date effectivity of the data. It describe the dimensions whose attribute value vary over time.

This term is commonly used in the Data Warehousing world. However, the problem exists in the OLTP, relational data modeling as well.

Example:

The sales representative assigned to a customer may change over time. Linda was the salesrep for ABC, inc. before March last year. Kathy later becomes the representative for this account.

You may want to track the data “as is”, “as was”, or both. If you show the year total sales, you can either report as the sales are all generated by Kathy, or actually break the number down between Linda and Kathy.

Posted in BI, Business Intelligence, Data Warehouse, SCD | Leave a Comment »

Where can I get the Oracle BI Enterprise Edition for evaulation?

Posted by Dylan Wan on January 9, 2007

Oracle have made its Oracle Business Intelligence Enterprise Edition (OBIEE) available for evaluation. I just followed the following steps to install it on my laptop.

Read the rest of this entry »

Posted in BI, Business Intelligence, OBIEE, Oracle, Oracle BI Suite EE | 1 Comment »

Why do I need to use DAC from Oracle BI?

Posted by Dylan Wan on January 8, 2007

Data Warehouse Application Console (DAC) works together with Informatica to acomplish the ETL for pre-packaged BI applications.

Here are what happen behind the scene: Read the rest of this entry »

Posted in BI Application, Business Intelligence, DAC, Data Warehouse, ETL, OBIEE, Oracle, Oracle BI Suite EE, Siebel Analytics | 1 Comment »

History of Data Warehouse

Posted by Dylan Wan on January 6, 2007

In the early stages only two vendors within the IT industry foresee what was happening later become data warehouse.  One was Teradata Corporation, which originated the database machine that could handle a terabye of data.  It was the first industry -hardened massively parallel computer. Teradata became at least for five years in succession one of the fast growing company at that time.

The second vendor was IBM which published “Information Warehouse” framework as early as 1987.

Data Warehousing then became the key trend in corporate computing in the 1990s.  Data warehousing is not really a technology trend per se.  It was primarily driven by the business envirobment.

Posted in BI, Business Intelligence, Data Warehouse | 2 Comments »

Learning ETL – ETL Process

Posted by Dylan Wan on January 6, 2007

ETL Process

Here is the typical ETL Process:

  • Specify metadata for sources, such as tables in an operational system
  • Specify metadata for targets—the tables and other data stores in a data warehouse
  • Specify how data is extracted, transformed, and loaded from sources to targets
  • Schedule and execute the processes
  • Monitor the execution

A ETL tool thus involves the following components:

  • A design tool for building the mapping and the process flows
  • A monitor tool for executing and monitoring the process

The process flows are sequences of steps for the extraction, transformation, and loading of data. The data is extracted from sources (inputs to an operation) and loaded into a set of targets (outputs of an operation) that make up a data warehouse or a data mart.

Read the rest of this entry »

Posted in Business Intelligence, Data Warehouse, ETL | Leave a Comment »