Hyperion Computation Requires

AGG (Dim List): It’s going to analyze just sparse proportions, It will not unite that treatments.

AGG (Dim List): It’s going to analyze just sparse proportions, It will not unite that treatments.

Info imitate: Info are going to be imitate one new member even to another new member

For example: INFO IMITATE Real to help Spending plan; –It might imitate info with real to help Spending plan.

REPAIR & TERMINATE REPAIR: applying repair proclamation we could prohibit that width people we could employ a few new member with exact same width just about every new member lost just by comma people aren’t able to employ calc gray with repair proclamation. Repair proclamation ought to terminate using terminate repair.

For example: REPAIR (“FY17”, “Working”, “Plan)

CALC GRAY (“Divisions”, Period”);


@Allocate: Allocates principles with a new member, with a cross-dimensional new member, and with a benefits all over an associate checklist. That portion is dependent on several factors.

@ISMBR: Dividends THE CASE in the event the up-to-date new member suits any sort of among the list of certain people.

@XRANGE: Dividends the number with people concerning (and comprehensive of) a few certain sole and cross-dimensional people in the exact same stage.

For instance, as soon as you help plenty of time together with Circumstances proportions, feel free to use @XRANGE to go back an associate arranged blend of Time period together with Circumstances rather then preparing a width that will unites the 2 main (which brings about a good many more person people as compared to necessary).

@XREF: Will allow some sort of data source computation to include principles with an additional Essbase data source.

These words is utilized to explain that @XREF purpose:

• Info aim for: that data source which the present computation is usually functioning (that is usually, that data source which that @XREF telephone originates).

• Databases: that data source that’s queried by way of the @XREF purpose. The following data source may very well be rural (that is usually, for a several product in comparison to the info target).

• Mindset: that new member blend becoming estimated relating to the info aim for (that is usually, that new member blend that will pinpoints that departed give aspect on the calculation).

@SLN: Figures that recurrent level make fish an utility in the present span may very well be depreciated, estimated all over several cycles. That devaluation process implemented is usually straight-line devaluation:

@PRIOR: Dividends that nth old mobile or portable new member with mbrName, inside line XrangeList. All the proportions imagine the identical people as being the up-to-date new member. @PRIOR will work just inside noticeable selection, with stage 0 people.

@RANGE: Dividends an associate checklist that will last longer than that certain new member collected from one of width (mbrName) along with the certain new member range between an additional width (rangeList). @RANGE may be joined with non-range options, which include @AVG, which often replaces a current selection purpose, which include


@RANK: Dividends that show up in the certain people and that certain benefits among the list of principles inside certain info arranged. That show up on the benefits is the same as it’s job (its rank) inside looked after info arranged.

@RELATIVE: Dividends just about all people in the certain age bracket and stage which were previously mentioned and following that certain new member inside data source description.

@ROUND: Units phrase to help numDigits.