Dylan's BI Study Notes

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

Use initialization block in OBIEE

Posted by Dylan Wan on October 21, 2015

I just add a post about using initialization block in OBIEE.

It is a feature I felt excited when I first see the tool.

See Page: Initialization Block

Before I worked on BI, I worked for EBS application development and was in charge of Multi-Org architecture for a period of time.  EBS Multi-Org is a feature that requires setting the user context and control the access via the context.

At first Oracle Discoverer did not have the feature and it took some efforts from the application development to work with the tool development to make the integration happen.

OBIEE, or Siebel Analytics, the name used at that time, understand the requirement, and the feature was there since day one when I started using it in eight year ago.

Here is a quick summary:

  • Consider using deferral mode, except the one absolutely required
  • Let BI server explicitly determine the dependency

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s