Function | Description |
---|
void filter(String filterExpression, { expression } ) | Evaluates the passed expression with the specified filter. For example:
Code Block |
---|
filter('M_MEASURE > 100') { L_ID_COUNT }
|
|
|
Double aggregatePrevLevel(int countOfPrevlevels, { expression } ) | Returns the aggregated value of the embedded expressioexpression. The aggregation is computed for the specified upper level. For example: Code Block |
---|
total = aggregatePrevLevel(1, {
cumulateFromTime(actualYear(), {
'M_NAME_1' + 'M_NAME_2'
});
});
current = cumulateFromTime(actualYear(), {
'M_NAME_1' + 'M_NAME_2'
});
return current / total;
|
|
Double members(String path, { expression } ) | Computes the expression for desired drill-down member values. Example: Code Block |
---|
return members('[L_LEVEL_1=VAL][L_LEVEL_2="VAL1,VAL2"]', {
M_NAME_1 * M_NAME_2
})
|
This example returns the value of indicator M_NAME_1 aggregated for specified members. |
Double membersSum({ expression } ) | Computes the expression for particular members and calculates the sum from particular results. Following example shows the difference of using multiplication within the membersSum() method and outside: Section |
---|
Column |
---|
| | Ind1 | Ind2 | membersSum( { M_IND_1 * M_IND_2 } ) | M_IND_1 * M_IND_2 | Member | | 5 | 30 | 80 | 150 | Member | Child1 | 3 | 20 | 60 | 60 | Member | Child2 | 2 | 10 | 20 | 20 |
|
|
|
Double membersSum(String levelCode, { expression } ) | Computes the expression for particular members of the defined levelCode and calculates the sum from particular results. |
Double membersAvg({ expression } ) | Computes the expression for particular members and calculates the average value from particular results. |
Double membersAvg(String levelCode, { expression } ) | Computes the expression for particular members of the defined levelCode and calculates the average value from particular results. |
Double membersMin({ expression } ) | Computes the expression for particular members and calculates the minimal value from particular results. |
Double membersMin(String levelCode, { expression } ) | Computes the expression for particular members of the defined levelCode and calculates the minimal value from particular results. |
Double membersMax({ expression } ) | Computes the expression for particular members and calculates the maximul value from particular results. |
Double membersMax(String levelCode, { expression } ) | Computes the expression for particular members of the defined levelCode and calculates the maximum value from particular results. |
String attributeCode() | Returns the attribute code of current member. Example: Section |
---|
Column |
---|
| Population | attributeCode() | Prague | 1200000 | L_CITY | Berlin | 3000000 | L_CITY | London | 7825200 | L_CITY |
|
|
|
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="4a970f3b81d0bcdb-d64cfde3-433043fd-acf7a815-7319b190088efb0cafaf1ee5"><ac:plain-text-body><![CDATA[ | String memberIdentifier() | Returns the attribute code and value of current member in following form [L_CODE={VALUE}]. Example:]]></ac:plain-text-body></ac:structured-macro> Section |
---|
Column |
---|
| Population | memberIdentifier() | <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="d0e4352f1387bbc4-85609a20-4a184ccd-afd7ba8d-5f9a2bc75bbd72a44c95fba2"><ac:plain-text-body><![CDATA[ | Prague | 1200000 | [L_CITY= {Prague}] | ]]></ac:plain-text-body></ac:structured-macro> | <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="6aea52692015d631-69468fa7-453d4bf0-9286bfbb-c3aee99efd045ded7f49074f"><ac:plain-text-body><![CDATA[ | Berlin | 3000000 | [L_CITY= {Berlin}] | ]]></ac:plain-text-body></ac:structured-macro> | <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="8ab320131c259f8e-9ebba15f-480c4ec8-b65e931b-a19811854a9ed6bd52fd05b5"><ac:plain-text-body><![CDATA[ | London | 7825200 | [L_CITY= {London}] | ]]></ac:plain-text-body></ac:structured-macro> |
|
|
|
String memberValue() | Returns the value of current member. Example: Section |
---|
Column |
---|
| Population | memberValue() | Prague | 1200000 | Prague | Berlin | 3000000 | Berlin | London | 7825200 | London |
|
|
|
rank() { expression } | Returns numerical order (rank) of the indicator applied in the expression within used drill-down. Example: Section |
---|
Column |
---|
User | Score | rank() | Peter | 90.3 | 2 | John | 92.7 | 1 | Anna | 89.7 | 3 |
|
|
|