working on applications and technology

There 're many tools in the market that we could use to architect a business intelligence/data warehousing project, The key components for such project usually includes

• Business Intelligence tools
• Data storage and data modeling layer
• Data integration or ETL/ELT tools

This is an simple overview

 Read more

There is one scenario that will be talked about eventually no matter what kind of BI tools you might use.

It is the value comparison of the time dimension. Which we call the 'Time Series Data' in OBIEE,

Unlike essbase where we could use calculation script to control every cell value inside the cube, OBIEE comes with 'Ready to use' functions that will help us do this kind of calculation.

Example ScenarioRead more

It is interesting to see that OBIEE has some features which is very similiar with the Oracle database, So when your data source is an Oracle database, you might have to choose between them, to use OBIEE 's feature? or use Oracle database 's correspondant feature?

What is aggregation tables or materilized view techniqueRead more

Please read this article before reading this one.

Although We could build report easily for snow flake data model with OBIEE, We still lack the capability of a typical 'interactive' report which user could drill down or roll up along a dimension.Read more

'Snow flake' is an common data model in many data model design. Many transaction system use snow flake model to store the data effectivly.

But for business intelligence project, It is best that we use the star schema data model for various purpose, but It is also possible to use snowflake data model and we will explain how OBIEE use snowflake as datasource .Read more

Both BI Server and the data model of Oracle business intelligence is invisible to end user, All the visible components to end user is controlled by the BI Presentation Service.

BI Presentation Service is an addon of the web server that accept request from end user. If you 're familiar with Siebel CRM, you will notice that BI Presentation Service is very similiar with Siebel SWSE.

What does the presentation service do?Read more