Syndicate
Monthly archive
- June 2009 (4)
- July 2009 (14)
- August 2009 (36)
- September 2009 (13)
- December 2009 (1)
- January 2010 (2)
September 2009
Essbase - understand storage for dense dimension and sparse dimension
In Essbase we could tag a dimension either 'dense dimension' or 'sparse dimension'. The definition of dense dimension is that the account dimension value must exist for almost every 'dense dimension' member. While for sparse dimension, there shouldn't be many value for 'sparse dimension' member.
Well this is easy to understand but you will not fully understand these two concept unless you 'r aware of how essbase use different storage machenism for these two dimension type.
It is all about storage efficiency!Read more
Install Essbase 11 on Windows - Configuration fail with Oracle XE database as repository
It is very popular to install Oracle database Express edition on one's laptop , XE is a small and light footprint of Oracle database which is very good to serve as a repository database for many products.
I have been using XE on my laptop for a long time and when I install Hyperion Essbase 11 today, I use XE as the hyperion repository natrually and I realize that the default parameters of XE is really small and we have to change it to bigger value for the installation to be sucessful.
Installation of EssbaseRead more
How to download and install essbase 11
Which files to download ?
Installation process of essbase version 11 is different from the previous version 9.x. But each component is still a separate file. In order to install Essbase 11, you should first download the following file:Read more
The general architecture for Oracle Business Intelligence
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
OBIEE - time comparison using time series function 'AGO'
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
OBIEE's similiar feature with Oracle database - aggregation tables VS materialized view
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
OBIEE - simple report with snowflake data model
'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
OBIEE - BI presentation service
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
OBIEE - BI Server and repository file
When we build data model in OBIEE, We actually use OBIEE administration tools. A client tools that we could define physical layer, logical layer(Business layer) and each field 's label appearance in presentation layer.
The output of these definitions is a file call BI repository file (.rpd) which contain the following data model definition :