BI Applications and Embedded BI, Part 4

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.

BI Applications and Embedded BI, Part 3

I would like to go over some of the embedded BI related technologies you can use to make the data from BI Apps embedded in the OLTP systems.

In this post I will describe the Micro ETL feature from DAC.

Cost Center Hierarchy and Performance Management

Cost Center Hierarchy is an important dimension is the Performance Management system. The cost center concept is described in many Managerial Accounting books. I think that going back to where it was originated help us to understand how it should be designed and used in a Business Analytics Data Warehouse.

A cost center is described as an essential element used in the responsibility accounting reporting system. Here are the major concepts about the responsibility accounting and cost center described in the managerial accounting field.

Your questions about OBIEE or OBIA

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

A white paper on leveraging the power of UNSPSC for BI

I found a white paper on www.UNSPSC.org site about the same topic I wrote last week:

Here are what I learned about UNSPSC:

• It has a 4 level hierarchical structure. It can be used for drill down and roll up data.
• It is very useful for spend analysis.
• It can also be used in sourcing to identify the suppliers. It can be use to measure the supplier’s performance by grouping the supplier and establish the benchmark.
• It was an effort of merging United Nation’s code and D&B’s SPSC.
• It can be extended. The custom codes can be defined as the further breakdown of the standard code
• It supports multiple languages.

Use the Industry Standard Code in Data Warehouse

Several well-developed industry standard code schemes can help you to capture the information. Here are advantages for you to adopt the industry standard codes in your information system:

• Save the time to develop the coding scheme by yourselves
• Apply the best practice from the industry
• Ease the exchange data between trading partners (B2B)
• Facilitate the data and application integration (A2A)
• Consolidate your information into a data warehouse cross multiple internal/legacy systems

Here are some of the well-known industrial standard codes I am aware of or have been involved in the past:

EBS R12 Legal Entity Model

One of the new enhancement we did to Oracle BI Apps version 7.9.4 is to supports the EBS R12 Legal Entity Model.  Here are some pointers to the resources to understand the E-Business Suite Legal Entity concept:

8 Things - Orablog Tag

I was tagged by David Haime as part of the game of tag.  Here is the 8 things about me people might not know:

Oracle BI Applications 7.9.4 is available on OTN

The latest version of Oracle Applications is now available in Oracle Technology Network.

http://www.oracle.com/technology/software/products/ias/htdocs/101320bi.html

Here is the direct link to software.

Here are some of the new features of this releases:

Oracle VPD and Oracle BI EE (Part 1)

Oracle database allows you secure the access to the table rows using the virtual private database feature.  It is one of the enabler for the EBS organization based security.

Oracle BI EE also provide the data security in the BI server based on repository setup.  However, can we also use the database feature together with our BI deployment?