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.