AGG (Dim List):It will calculate only sparse dimensions, It won’t consolidate the formulas.
AGG (Dim List):It will calculate only sparse dimensions, It won’t consolidate the formulas.
Data copy: Data will be copy to one member to another member
Eg: DATA COPY Actual to Budget; –It will copy data from actual to Budget.
FIX & END FIX: using fix statement we can restrict the dimension members we can use more than one member in same dimension each member separated by comma we can’t use calc dim in fix statement. Fix statement must end with end fix.
Eg: FIX (“FY17”, “Working”,”Plan)
CALC DIM (“Divisions”, Period”);
END FIX
@Allocate: Allocates values from a member, from a cross-dimensional member, or from a value across a member list. The allocation is based on a variety of criteria.
@ISMBR: Returns TRUE if the current member matches any one of the specified members.
@XRANGE: Returns the range of members between (and inclusive of) two specified single or cross-dimensional members at the same level.
For example, when you work with the Time and Scenario dimensions, you can use @XRANGE to return a member set combination of Time and Scenario instead of creating a dimension that combines the two (which creates many more individual members than necessary).
@XREF: Enables a database calculation to incorporate values from another Essbase database.
The following terminology is used to describe the @XREF function:
• Data target: the database on which the current calculation is running (that is, the database on which the @XREF call originates).
• Data source: the database that is queried by the @XREF function. This database may be remote (that is, on a different machine than the data target).
• Point of view: the member combination currently being calculated on the data target (that is, the member combination that identifies the left hand side of a calculation).
@SLN: Calculates the periodic amount that an asset in the current period may be depreciated, calculated across a range of periods. The depreciation method used is straight-line depreciation:
@PRIOR: Returns the nth previous cell member from mbrName, in the sequence XrangeList. All other dimensions assume the same members as the current member. @PRIOR works only within the designated range, and with level 0 members.
@RANGE: Returns a member list that crosses the specified member from one dimension (mbrName) with the specified member range from another dimension (rangeList). @RANGE can be combined with non-range functions, such as @AVG, which replaces an existing range function, such as
@AVGRANGE
@RANK: Returns the rank of the specified members or the specified value among the values in the specified data set. The rank of a value is equivalent to its position (its rank) in the sorted data set.
@RELATIVE: Returns all members at the specified generation or level that are above or below the specified member in the database outline.
@ROUND: Rounds expression to numDigits.