AGG (Dim Listing):It will calculate only sparse proportions, It will not consolidate the formulas.
AGG (Dim Listing):It will calculate only sparse dimensions, It is not going to consolidate the formulas.
Info duplicate: Facts will be copy to a person member to another member
Eg: Facts Copy Actual to Spending plan –It will copy data from genuine to Funds.
Take care of & Finish Resolve: using deal with statement we can prohibit the dimension members we can use additional than a person member in similar dimension every single member divided by comma we are unable to use calc dim in correct assertion. Repair statement must conclude with close resolve.
Eg: Fix (“FY17”, “Doing work”,”Program)
CALC DIM (“Divisions”, Interval”)
Stop Deal with
@Allocate: Allocates values from a member, from a cross-dimensional member, or from a benefit throughout a member record. The allocation is based mostly on a wide range of standards.
@ISMBR: Returns Accurate if the latest member matches any one of the specified users.
@XRANGE: Returns the assortment of users involving (and inclusive of) two specified single or cross-dimensional members at the very same stage.
For illustration, when you operate with the Time and Scenario proportions, you can use @XRANGE to return a member established mixture of Time and Situation alternatively of generating a dimension that combines the two (which produces lots of extra personal users than necessary).
@XREF: Enables a databases calculation to include values from an additional Essbase databases.
The subsequent terminology is employed to explain the @XREF operate:
• Info goal: the databases on which the existing calculation is operating (that is, the databases on which the @XREF contact originates).
• Knowledge resource: the database that is queried by the @XREF function. This databases may be remote (that is, on a different machine than the info target).
• Stage of watch: the member mix at this time becoming calculated on the facts target (that is, the member combination that identifies the remaining hand aspect of a calculation).
@SLN: Calculates the periodic amount that an asset in the current interval may possibly be depreciated, calculated throughout a array of periods. The depreciation system utilised is straight-line depreciation:
@PRIOR: Returns the nth previous cell member from mbrName, in the sequence XrangeList. All other dimensions suppose the exact same associates as the present-day member. @PRIOR is effective only within just the designated vary, and with degree members.
@Range: Returns a member list that crosses the specified member from just one dimension (mbrName) with the specified member array from an additional dimension (rangeList). @Range can be combined with non-range capabilities, these types of as @AVG, which replaces an present array operate, these as
@AVGRANGE
@RANK: Returns the rank of the specified users or the specified benefit among the the values in the specified data established. The rank of a price is equal to its situation (its rank) in the sorted facts established.
@RELATIVE: Returns all associates at the specified generation or degree that are earlier mentioned or below the specified member in the database outline.
@Round: Rounds expression to numDigits.