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; | ||||||||||||||||||||||||
Double forEachRow('expression') | Computes the expression on data set row level and calculates the sum from particular results. Following example shows the difference of using multiplication within the
| ||||||||||||||||||||||||
Double forEachRow('expression','aggregation') | Computes the expression on data set row level and calculates the aggreagation based on second parameter from particular results. Aggregation can include SUM, MIN, MAX, AVG, COUNT, DCOUNT. | ||||||||||||||||||||||||
| 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:
| ||||||||||||||||||||||||
| Returns the attribute code and value of current member in following form [L_CODE={VALUE}]. Example:
| ||||||||||||||||||||||||
| 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 |
Getting User Information
It is possible to obtain information about logged in user for your reporting needs.
Function | Description |
---|---|
String getSignedUserName() | Returns username of currently signed in user. |
String getSignedUserSurname() | Returns surname of currently signed in user. |
String getSignedUserEmail() | Returns email of currently signed in user. |
String getSignedUser() | Returns login of currently signed in user. |