Hyperion Calculation Commands

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


@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.