@VAR

The @VAR calculation function for Essbase calculates the variance (difference) between two members.

The variance calculation recognizes the difference between accounts that are tagged in the database outline as expense and those that are non-expense (the default), and calculates the variance accordingly.

Syntax

@VAR (mbrName1, mbrName2)

Parameters

mbrName1 and mbrName2: Members from the same dimension whose variance results are to be calculated. The variance is derived by subtracting mbrName2 values from mbrName1, unless an account is tagged as expense, in which case mbrName1 values are subtracted from mbrName2.

Example

The following example is based on the Sample Basic database. The variance between Actual and Budget is calculated as follows:

Variance = @VAR(Actual,Budget);

Sales is non-expense, whereas COGS is expense. This example produces the following report:

                Year    Product    Market 
                   Sales      COGS      
                   =====      ====
Actual            400855     179336     
Budget            373080     158940     
Variance           27775    (20396)