Why is Sunopsis so different?

On October 9, 2006, Oracle announced that they acquire Sunopsis.

I read the white paper from Sunopsis. I learned that the key is in their “E-LT” concept.

Typical Business Intelligence Applications

This arcticles examines the major business drivers of business intelligence and the typical business intelligence applications. Some BI applications are common for all types of enterprise, others are specific to some industries.

• Marketing Intelligence
• Sales Intelligence
• Customer Intelligence
• Service Intelligence
• Financial Intelligence
• Project Intelligence
• Procurement Intelligence
• Human Resource Intelligence

Why Oracle BI EE?

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

When to use Oracle OLAP Option

You may find that this Oracle OLAP Option white paper is useful.

http://www.oracle.com/technology/products/bi/olap/1450_olap10g_enhance_content_performance.pdf

A tip of using value-based hierarchy in AW

A value-based hierarchy is currently supported only in AW, the Oracle OLAP option.

I heard that OBIEE may support it in a later release after it supports the data source from AW.

A value-based hierarchy can be used to model the management reporting hierarchy, in which you do not have the specific “level” concept in the hierarchy.

If you have sales are rolled up to their manager, and sales managers are also selling products, you should craete dummy node as a child record of every sales manager so the sales data can be associated with the sales manager.

Oracle DBI vs. SAP BW from Edison Group, Inc.

I found a good white paper on a comparison of Oracle DBI and SAP BW:

http://zones1.computerworld.com/oracle/downloads/Edison_Group_Report.pdf

Building Oracle Daily Business Intelligence with Oracle BI Enterprise Edition

This is a white paper about how to build dashboard on top of Oracle Daily Business Intelligence summary tables using Oracle BI Enterprise Edition.

http://www.oracle.com/solutions/business_intelligence/docs/obiee-dbi-whitepaper.pdf

This is very helpful for all current Oracle E-Business Suite DBI users who want to add custom contents to their reports or dashboard. The most important content from this white paper is the list of all DBI physical tables.