Tuesday, June 26, 2012

How to load the data using rule file in Essbase

In Essbase data can loaded into database in two ways:
                 Excel Lock & Sends.
                 Rule files.
Through Lock & Sends in excel data can be update/insert to the perticular combination of members.
Through rule file you can load the data file which consists bulk data.

Sunday, June 24, 2012

How build members in outline using rule file

Essbase outline is the hierarchical representation of the business system.
Outline has dimensions, members and attributes and many more.
Members, Attributes can be build using rule files even you can build the dimensions on the fly using rule file but this post covers how to build the members alone under the dimensions.

Friday, June 22, 2012

How to create an Outline in Essbase

In simple terms Essbase outline is hierarchical representation of the entire Business system.
It consists of Dimensions which are again categorized into two forms:
           Standard Dimension
           Attribute Dimension
Let's start simple journey to create the default outline

Tuesday, June 12, 2012

Small bug in Windows OS

I read one article in Computer Era Telugu edition last month about bugs in Windows OS.
This bug really caught my attention completely.

1) Open calculator application in the Windows OS.
2) Find the square root for 4 ( result will be 2)
3) Subtract the result from 2.
now check the result it will not be as you expected but it will be some other number.

Similarly check for the square root of 9 and subtract the result from 3 and check the result it will be some other value but not zero.