AGG (Dim Checklist):It will estimate only sparse dimensions, It will never consolidate the formulation.

AGG (Dim List):It will calculate only sparse dimensions, It won’t consolidate the formulas.

Knowledge copy: Info will be duplicate to a person member to another member

Eg: Information Duplicate Precise to Spending plan –It will copy facts from actual to Budget.

Take care of & Conclusion Repair: applying correct assertion we can limit the dimension customers we can use more than a person member in identical dimension every single member separated by comma we can not use calc dim in fix assertion. Repair statement must conclusion with conclusion resolve.

Eg: Resolve (“FY17”, “Working”,”Strategy)

CALC DIM (“Divisions”, Period of time”)

Close Deal with

@Allocate: Allocates values from a member, from a cross-dimensional member, or from a worth across a member listing. The allocation is dependent on a wide range of criteria.

@ISMBR: Returns Real if the current member matches any a single of the specified members.

@XRANGE: Returns the selection of users concerning (and inclusive of) two specified solitary or cross-dimensional members at the exact same stage.

For illustration, when you work with the Time and Scenario dimensions, you can use @XRANGE to return a member established blend of Time and State of affairs as a substitute of creating a dimension that brings together the two (which creates many extra specific associates than essential).

@XREF: Enables a databases calculation to incorporate values from yet another Essbase database.

The pursuing terminology is made use of to describe the @XREF functionality:

• Data target: the database on which the recent calculation is jogging (that is, the database on which the @XREF simply call originates).

• Knowledge resource: the database that is queried by the @XREF functionality. This database may possibly be distant (that is, on a distinct equipment than the details target).

• Position of perspective: the member combination at present being calculated on the info goal (that is, the member mixture that identifies the left hand aspect of a calculation).

@SLN: Calculates the periodic sum that an asset in the current time period may possibly be depreciated, calculated across a vary of periods. The depreciation strategy utilized is straight-line depreciation:

@PRIOR: Returns the nth earlier mobile member from mbrName, in the sequence XrangeList. All other proportions think the identical associates as the present-day member. @PRIOR functions only within the designated vary, and with stage customers.

@Range: Returns a member list that crosses the specified member from a person dimension (mbrName) with the specified member range from one more dimension (rangeList). @Assortment can be merged with non-range functions, this sort of as @AVG, which replaces an existing assortment functionality, these types of as


@RANK: Returns the rank of the specified users or the specified price among the values in the specified facts set. The rank of a benefit is equal to its place (its rank) in the sorted info established.

@RELATIVE: Returns all members at the specified generation or degree that are above or below the specified member in the databases define.

@Spherical: Rounds expression to numDigits.