Special functions
Function |
Description |
||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Evaluates the passed expression with the specified filter. For example: filter('M_MEASURE > 100') { L_ID_COUNT } |
||||||||||||||||||||||||
|
Returns the aggregated value of the embedded expression. The aggregation is computed for the specified upper level. For example: total = aggregatePrevLevel(1, { cumulateFromTime(actualYear(), { 'M_NAME_1' + 'M_NAME_2' }); }); current = cumulateFromTime(actualYear(), { 'M_NAME_1' + 'M_NAME_2' }); return current / total; |
||||||||||||||||||||||||
|
Computes the expression for desired drill-down member values. Example: return members('[L_LEVEL_1=VAL][L_LEVEL_2="VAL1,VAL2"]', { M_NAME_1 * M_NAME_2 }) This example returns the value of indicator |
||||||||||||||||||||||||
|
Computes the expression for particular members and calculates the sum from particular results. Following example shows the difference of using multiplication within the
|
||||||||||||||||||||||||
|
Computes the expression for particular members of the defined |
||||||||||||||||||||||||
|
Computes the expression for particular members and calculates the average value from particular results. |
||||||||||||||||||||||||
|
Computes the expression for particular members of the defined |
||||||||||||||||||||||||
|
Computes the expression for particular members and calculates the minimal value from particular results. |
||||||||||||||||||||||||
|
Computes the expression for particular members of the defined |
||||||||||||||||||||||||
|
Computes the expression for particular members and calculates the maximul value from particular results. |
||||||||||||||||||||||||
|
Computes the expression for particular members of the defined |
||||||||||||||||||||||||
|
Returns the attribute code of current member. Example:
|
||||||||||||||||||||||||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="c1279d19-9160-46be-9118-3a4836d9fb8c"><ac:plain-text-body><![CDATA[ |
|
Returns the attribute code and value of current member in following form [L_CODE={VALUE}]. Example:]]></ac:plain-text-body></ac:structured-macro>
|
|||||||||||||||||||||||
|
Returns the value of current member. Example:
|
||||||||||||||||||||||||
rank() { expression } |
Returns numerical order (rank) of the indicator applied in the expression within used drill-down. Example:
|
||||||||||||||||||||||||
withoutDateTime() { expression } |
Opt-out from applied Date and Time intervals. Example:
|
||||||||||||||||||||||||
withoutDrillDown() { expression } |
Opt-out from applied Drill-downs. Example:
|
||||||||||||||||||||||||
withoutFilter() |
Opt-out from applied filters. Example: (Filter is set to SEGMENT=SMB)
|
Passing parameters to time formula
It is possible to define the time entry by formula. Following functions are applicable for these kind of formulas only.
Function |
Description |
---|---|
|
Sets the parameter value. |
|
Loads the parameter value. |
|
Returns indicator from the context of the row of current table. This function returns also values of formula defined indicators (defined in report). Example: value(actualYear(),'actualMonth - 1m - 1d',indicator()) |
Consider following example - we have several indicators with codes M_NAME_1
, M_NAME_2
and M_NAME_3
. These indicators are used in formulas 1 - 3. The time area is defined by time formulas 1 - 5.
|
Time formula 1: |
Time formula 2: |
Time formula 3: |
Time formula 4: |
Time formula 5: |
Formula 1: |
1000 |
2000 |
3000 |
1000 |
1000 |
Formula 2: |
1000 |
2000 |
3000 |
2000 |
2000 |
Formula 3: |
1000 |
2000 |
3000 |
3000 |
3000 |
|
1000 |
2000 |
3000 |
N/A |
1000 |
|
1000 |
2000 |
3000 |
N/A |
2000 |
|
1000 |
2000 |
3000 |
N/A |
3000 |