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.