Thursday, April 8, 2010

Things to Know before You Start with hyperion Essbase

Two key concepts you should clearly bullet into your brains else you are always HAUNTED
1.Dense
2.Sparse
Dense: The name itself refers more concentrated speaking related to the content,where the more data or matter or details exist.

Sparse: It means less concentrated or speaking related to the content,where the data may exist may not exist at all or relatively very less compared to dense matter.Speaking more technically where the data is not uniformly or smoothly distributed.

Lets say you own a International Food Supply Business,now lets say you manufacture Bread,Noodles and Rice(Its an Assumption...ok)
lets Go little ahead
Now your RICE gets sold strictly only in INDIA
and your BREAD gets sold strictly only in UNITED STATES
and NOODLES strictly only in CHINA.

Now all the above products are not sold in every country ,that define your products RICE,BREAD and NOODLES as Sparse.

Secondly you are selling all the three products in their respected countries all round the YEAR since decades.Thats not enough still u have keep the track of the records,i mean ACCOUNTS for the products or each product,whether you are making good sales,are you making a profit or loss.By using the track of the these records you can make decisions whether to increase the production of the goods in a particular country if you are making a profit else reduce the production if you are at Loss and all other related stuff like expenses,revenues....etc,.

Finally your company sells al the 3 products dring all the months(time) of the YEAR and you got maintain the ACCOUNTS for the 3 products all the time.(Weekly,monthly Quartely,yearly).So the TIME and ACCOUNTS exists for all the PRODUCTS in each COUNTRY.
You can conclude that TIME AND ACCOUNTS as DENSE DIMENSIONS.

1 comment:

lakshmi said...

CORRECT ME IF THERE ARE ANY MISTAKES....