I am describing how data security works in Oracle BI Apps.
Archive for the ‘Siebel Analytics’ Category
Posted by Dylan Wan on July 15, 2008
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.
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?
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.
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.
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 by Dylan Wan on July 7, 2007
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 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 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 by Dylan Wan on February 4, 2007
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 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:
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 by Dylan Wan on January 8, 2007
Here are what happen behind the scene: Read the rest of this entry »
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: