AGG (Dim Listing):It will determine only sparse proportions, It will never consolidate the formulas.
AGG (Dim Record):It will determine only sparse dimensions, It is not going to consolidate the formulation.
Information copy: Facts will be copy to a single member to yet another member
Eg: Information Copy Actual to Funds –It will copy knowledge from genuine to Funds.
Resolve & Conclusion Correct: utilizing take care of statement we can prohibit the dimension members we can use more than one particular member in similar dimension each and every member divided by comma we can not use calc dim in resolve statement. Repair assertion must conclude with stop repair.
Eg: Resolve (“FY17”, “Doing work”,”Prepare)
CALC DIM (“Divisions”, Interval”)
Close Take care of
@Allocate: Allocates values from a member, from a cross-dimensional member, or from a value across a member listing. The allocation is centered on a variety of requirements.
@ISMBR: Returns Genuine if the present-day member matches any one particular of the specified customers.
@XRANGE: Returns the variety of associates among (and inclusive of) two specified solitary or cross-dimensional customers at the similar level.
For case in point, when you do the job with the Time and Situation proportions, you can use @XRANGE to return a member established blend of Time and Scenario in its place of building a dimension that brings together the two (which results in several far more unique users than vital).
@XREF: Enables a databases calculation to incorporate values from another Essbase database.
The adhering to terminology is applied to explain the @XREF perform:
• Info concentrate on: the databases on which the present-day calculation is managing (that is, the database on which the @XREF simply call originates).
• Information resource: the databases that is queried by the @XREF operate. This database may possibly be remote (that is, on a distinct equipment than the knowledge focus on).
• Issue of look at: the member combination at the moment staying calculated on the knowledge concentrate on (that is, the member mixture that identifies the still left hand facet of a calculation).
@SLN: Calculates the periodic amount that an asset in the present-day period of time may perhaps be depreciated, calculated throughout a variety of durations. The depreciation strategy utilised is straight-line depreciation:
@PRIOR: Returns the nth prior cell member from mbrName, in the sequence XrangeList. All other proportions believe the very same members as the present-day member. @PRIOR works only in the specified array, and with degree members.
@Array: Returns a member checklist that crosses the specified member from a single dimension (mbrName) with the specified member array from yet another dimension (rangeList). @Variety can be merged with non-assortment capabilities, such as @AVG, which replaces an current variety function, this kind of as
@AVGRANGE
@RANK: Returns the rank of the specified members or the specified value amid the values in the specified details set. The rank of a benefit is equivalent to its situation (its rank) in the sorted information set.
@RELATIVE: Returns all customers at the specified era or level that are earlier mentioned or underneath the specified member in the database define.
@Spherical: Rounds expression to numDigits.
