Dylan's BI Study Notes

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

Archive for the ‘Siebel Analytics’ Category

Data Security in Oracle BI Apps

Posted by Dylan Wan on July 15, 2008

I am describing how data security works in Oracle BI Apps.

Read the rest of this entry »

Advertisements

Posted in BI, BI Application, BI Work, Business Intelligence, OBIA, OBIEE, Oracle, Oracle BI Suite EE, Siebel Analytics | Tagged: | 1 Comment »

Oracle BI Applications 7.9.5 is out

Posted by Dylan Wan on May 30, 2008

Oracle BI Applications 7.9.5 is released early this month. Here is a quick summary of the features introduced in this release and where you can get more information about it.

Read the rest of this entry »

Posted in BI, BI Application, BI Work, Business Intelligence, Data Warehouse, ETL, Infomatica, OBIA, OBIEE, Oracle, Oracle BI Suite EE, PeopleSoft, Siebel Analytics | Tagged: | 3 Comments »

A good OBIEE web demo from New York City’s City Wide Performance Reporting

Posted by Dylan Wan on February 15, 2008

New York City now enables the public to monitor the city’s performance by making the OBIEE based dashboard and report online.

Here is the link to their CPR (City Wide Performance Reporting) site : http://www.nyc.gov/html/ops/cpr/html/home/home.shtml

Read the rest of this entry »

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

Bitmap Index – when to use it?

Posted by Dylan Wan on February 1, 2008

I will cover how Bitmap index work, when to use it and how to use it in this article.

How does it work?

The bitmap index stores the column values in bits. Each bit represents a single value. For example, the gender column has two possible values: Male and Female. three bit will be used in the bitmap to capture the index on the gender column. A good example can be seen in reference 1. So the more distinct value is, the more space is required to store the bitmap.

Internally, the database engine, like Oracle, uses a map function to converts the bit location to the distinct value. (See reference #2) Many bitmap indexes can be used together since database can merge it, so this can improve the response time. (See Reference #3 for the example of merging the index on Marital Status and Region)

When to use it?

Read the rest of this entry »

Posted in BI, Business Intelligence, Data Warehouse, Oracle, Siebel Analytics | 5 Comments »

BI Applications and Embedded BI, Part 4

Posted by Dylan Wan on January 29, 2008

This is my 4th post about the embedded BI. The key is that a OBIEE and OBIA warehouse based solution is embeddable to the OLTP system as long as the OLTP system can provide the basic support.

In this article, I will discuss one of the key enabling technology – integrated authentication.

Read the rest of this entry »

Posted in BI, BI Application, BI Work, Business Intelligence, EBS, OBIA, OBIEE, Oracle, Oracle BI Suite EE, Siebel Analytics | 2 Comments »

Your questions about OBIEE or OBIA

Posted by Dylan Wan on January 24, 2008

Some people left me messages in my MeeboMe. If you have questions about Oracle BI Suite Enterprise Edition and Oracle BI Applictions. Here are the links to the public discussion forums:

Oracle BI Suite Enterprise Edition

Oracle BI Applications

Posted in BI, BI Application, BI Links, Business Intelligence, Data Warehouse, OBIEE, Oracle, Oracle BI Suite EE, Siebel Analytics | Leave a 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 »

UDML in Oracle BI Server

Posted by Dylan Wan on October 22, 2007

I recently learned a way to retrieve and manipulate the Oracle BI repository file without using the Admin Tool. Although they are not officially documented and supported, they are extensively used by many savvy users. You can see the following screen shot to get the idea on how to retrieve the repository definition in a text format.

Read the rest of this entry »

Posted in BI Application, OBIEE, Oracle, Oracle BI Suite EE, Siebel Analytics | 5 Comments »

Oracle BI Applications version 7.9.3 is now available on OTN

Posted by Dylan Wan on August 20, 2007

It is great to hear that Oracle BI Applications version 7.9.3 is now available on Oracle Technology Network for download. – Oracle Business Intelligence (10.1.3.X) download web site.

The technical note 676: Summary of Enhancements and New Features in Oracle Business Intelligence Applications Version 7.9.3 is also available on supportweb.siebel.com. The highlights of the key features introduced in this release are as follows: Read the rest of this entry »

Posted in BI, BI Application, BI Work, Business Intelligence, OBIEE, Oracle, Oracle BI Suite EE, Siebel Analytics | Leave a Comment »

BI Applications and Embedded BI, Part 1

Posted by Dylan Wan on July 7, 2007

I now also create my blog entries on blogs.oracle.com/dylanwan. This is actually the first entry in my blog in the blogs.oracle.com. I want to choose a topic related to what I learned lately.

Oracle BI Applications is build on top of the platform from the Oracle BI Enterprise Edition. The dashboard and report components can be seamlessly embedded into Oracle Applications, like how it is integrated with Siebel application. However, it is also a very typical data warehouse architecture.
Read the rest of this entry »

Posted in BI, BI Application, BI Work, Business Intelligence, Data Warehouse, OBIEE, Oracle, Oracle BI Suite EE, Siebel Analytics | Leave a Comment »

An evaluation of Oracle BI Enterprise Edition from Intelligent Enterprise

Posted by Dylan Wan on April 24, 2007

A good article from Intelligent Enterprise about the Oracle BI Enterprise Edition – Put to the test: Oracle BI Enterprise Edition.

Here is the part I feel worth highlight: Read the rest of this entry »

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

Oracle Business Intelligence EE 10.1.3.2 (MAUI) Tutorial

Posted by Dylan Wan on March 21, 2007

Oracle.com provides a very good tutorial for Oracle Business Intelligence Enterprise Edition 10g: Read the rest of this entry »

Posted in AW, BI, OBIEE, OLAP, Oracle, Oracle BI Suite EE, Siebel Analytics | 3 Comments »

Oracle Business Intelligence EE 10.1.3.2 (MAUI) Documentation Library

Posted by Dylan Wan on March 2, 2007

This is the link to public available Business Intelligence Suite Enterprise Edition Version 10.1.3.2 Documentation Library. Read the rest of this entry »

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

Aging Reports and DSO (Daily Sales Outstanding)

Posted by Dylan Wan on February 27, 2007

Account Receivables aging report and Daily Sales Outstanding are two metrics commonly seen in the Financial Analytics for measuring the performance of the Account Receivables, Credit Management, and Collection departments. Here are how they are calculated, who the users are, and how they may affect the business decisions. Read the rest of this entry »

Posted in BI, BI Application, Business Intelligence, Financial Intelligence, Siebel Analytics | 7 Comments »

Oracle Business Intelligence EE 10.1.3.2 (MAUI) Available in eDelivery

Posted by Dylan Wan on February 4, 2007

Oracle Business Intelligence Enterprise Edition 10.1.3.2 (the Maui release) is now available in edelivery.oracle.com for downloading for evaluation purpose. Read the rest of this entry »

Posted in BI, Business Intelligence, OBIEE, Oracle, Oracle BI Suite EE, Siebel Analytics | Leave a Comment »

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 »

Posted in BI, DAC, ETL, OBIEE, Oracle, Oracle BI Suite EE, Oracle Data Integrator, OWB, Siebel Analytics, Sunopsis | Leave a 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 »

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 »

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 »

Why Oracle BI EE?

Posted by Dylan Wan on December 20, 2006

Oracle BI Enterprise Edition is a product Oracle acquired along with its Siebel acquisition. This 2003 press release told the background that it comes from an earlier acquisition of nQuire by Siebel. It explains why you should use Oracle BI Enterprise Edition…

…it could aggregate data from multiple sources without requiring middleware.

Another interesting eWeek article – Siebel makes BI Platform Move:

http://www.findarticles.com/p/articles/mi_zdewk/is_200310/ai_ziff109233

Posted in BI, Business Intelligence, OBIEE, Oracle, Oracle BI Suite EE, Siebel Analytics | Leave a Comment »