David Beckham kisses son Romeo at Invictus Games - see adorable photo

Hyperion Computation Commands
AGG (Dark Listing) : This will determine just sporadic measurements, This won't combine the solutions.

AGG (Dark Listing) : This will determine just sporadic measurements, This won't combine the solutions.

Information duplicate : Information will be duplicate to one participant to one more member

Eg : DATA COPY Real to Budget plan ; --It will duplicate information from real to Budget plan.

FIX & END FIX : utilizing repair declaration we can limit the measurement participants we can usage greater than one participant in exact same measurement each participant divided by comma we can't usage calc dark in repair declaration. Repair declaration should finish with finish repair.

Eg : FIX (" FY17 ", " Functioning ", " Prepare)

CALC DIM (" Departments ", Duration ") ;

END FIX

@Allocate : Allocates worths from a participant, from a cross-dimensional participant, or from a worth throughout a participant listing. The allotment is based upon a range from requirements.

@ISMBR : Returns TRUE if the present participant suits any among the defined participants.

@XRANGE : Returns the variety of participants in between (and comprehensive from) 2 defined solitary or cross-dimensional participants at the exact same degree.

For instance, when you deal with the Time and Situation measurements, you can usage @XRANGE to return a participant established mix from Time and Situation rather than producing a measurement that integrates both (which produces a lot more private participants compared to required).

@XREF : Allows a data source computation to integrate worths from one more Essbase data source.

The complying with terms is utilized to explain the @XREF feature :

• Information target : the data source on which the present computation is operating (that‘s, the data source on which the @XREF phone call stems).

• Information resource : the data source that‘s inquired by the @XREF feature. This data source might be remote (that‘s, on a various device compared to the information target).

• Viewpoint : the participant mix presently being determined on the information target (that‘s, the participant mix that determines the left hand side from a computation).

@SLN : Determines the regular quantity that a possession in the present duration might be depreciated, determined throughout a variety of durations. The devaluation technique utilized is straight-line devaluation :

@PRIOR : Returns the nth previous cell participant from mbrName, in the series XrangeList. All various other measurements presume the exact same participants as the present participant. @PRIOR functions just within the assigned variety, and with degree 0 participants.

@RANGE : Returns a participant listing that goes across the defined participant from one measurement (mbrName) with the defined participant variety from one more measurement (rangeList). @RANGE can be integrated with non-range works, such as @AVG, which changes an current variety feature, such as

@AVGRANGE

@RANK : Returns the place from the defined participants or the defined worth amongst the worths in the defined information established. The place from a worth is comparable to its setting (its place) in the sorted information established.

@RELATIVE : Returns all participants at the defined generation or degree that are over or listed below the defined participant in the data source overview.

@ROUND : Rounds expression to numDigits.



Short article Resource : http :// EzineArticles. com/9714123