working on applications and technology

After building our essbase analytic model and importing the data, the next big thing is to keep our essbase data refreshed with each coming day's new data . And it might be necessary to  add  new dimension member to the outline sometimes (e.g. we might have to add today's date to the date dimension before loading today 's sales data)Read more

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

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

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

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