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.

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.

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

My right mouse pop up no longer works in Excel?

When ESSBASE/Excel add-in is installed , the default behavior is for ESSBASE to "take over" your right mouse click.
This is because the Excel add-in provides for some additional ESSBASE functionality, the problem is that it is installed without your knowledge.
To regain the control of your right mouse pop up menu in Excel:

How fetch slice of data from one database to other database

We can fetch a slice of data from one database to other database using XREF function which intern using Location Aliases,

Here is small information how to use @XREF function in calculation script and Location Aliases in ESSBASE.

How to do variance reporting in ESSBASE

Variance reporting property determines how ESSBASE calculates the difference between Actual and Budget data members,
The dimension should be tagged as Account then only variance reporting property becomes visible.
The member formula to calculate the variance reporting between Actual and Budget should consists either of @VAR or @VARPER
There are two types of variances

•        Expense Reporting
•        Non Expense Reporting.

What is Time Balance property in ESSBASE

Time Balance property is one of the hidden property in ESSBASE which comes into picture when you tag any dimension as a Accounts.
If an account dimension member uses the time balance property,it affects how ESSBASE calculates the parent of the member in Time dimension.
ESSBASE has three kind of TB properties:

• TB First
• TB Last
• TB Average

Know more about each file in ESSBASE

As soon as an application created in Essbase, the Analytical Services will creates different files such as Page file(.PAG), Index file (.IND) etc and each files stands for some specific purpose.
All these files are available at $ARBORPATH/app/application/database folder
.otn file (Outline file) : The files consists compile code for the outline hierarchy, member formula, Attributes and Aliases and others.