AGG (Dim List): will calculate sparse dimensions only, will not consolidate formulas.
AGG (Dim List): will calculate only sparse dimensions, will not consolidate formulas.
Copy of data: data will be copied from one member to another member
For example: COPY DATA Actual to Budget; –Copy the data from actual to budgeted.
FIX & END FIX: By using the fix statement, we can restrict the members of the dimension. We can use more than one member in the same dimension, each member separated by a comma. We can’t use calc dim in the fix statement. The fix statement must end with end fix.
For example: FIX (“FY17”, “Working”,”Plan)
CALC DIM(“Divisions”, Period”);
END REVIEW
@Allocate – Allocates values from a member, an interdimensional member, or a value in a list of members. Allocation is based on a variety of criteria.
@ISMBR: Returns TRUE if the current member matches any of the specified members.
@XRANGE: Returns the range of members between (and inclusive of) two specified members of one or more dimensions at the same level.
For example, when working with the Time and Scenario dimensions, you can use @XRANGE to return a set combination of Time and Scenario members instead of creating a dimension that combines the two (which creates many more individual members than necessary). .
@XREF – Allows a database calculation to incorporate values from another Essbase database.
The following terminology is used to describe the @XREF function:
• Data Destination: The database in which the current calculation is executed (ie, the database in which the @XREF call originates).
• Data source: the database queried by the @XREF function. This database can be remote (that is, on a different machine than the data destination).
• Viewpoint—The member combination that is currently calculated in the data target (that is, the member combination that identifies the left side of a calculation).
@SLN: Calculates the periodic amount by which an asset can be depreciated in the current period, calculated over a range of periods. The depreciation method used is straight-line depreciation:
@PRIOR: Returns the nth previous cell member of mbrName, in the XrangeList sequence. 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 list of members that crosses the specified member of one dimension (mbrName) with the specified range of members of 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 ordered data set.
@RELATIVE: Returns all members of the specified generation or level that are above or below the specified member in the database schema.
@ROUND: Rounds the expression to numDigits.
