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 expression. 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 | | DrillDownMember1 | 3 | 20 | 60 | 60 | | DrillDownMember2 | 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="f835b78d74af4241-e760ee22-4a1a4e4b-a5a2aeb6-4c9566a8063aaa8a8c01ea11"><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="69bce4810ae32ff3-deeb1f61-42ef44b7-8447b6d1-c84c2cae9c3467f28702053b"><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="6631590c2c613d34-e7f641b6-46124c17-a0a9939f-4f1c63ef2cdd9aabfe634351"><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="d60b0d9945c39e5c-bea45677-43174846-96fdaea4-af5eef8ed055e55fc42378b5"><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 |
|
|
|
withoutDateTime() { expression } | Opt-out from applied Date and Time intervals (filters). Example: Section |
---|
Column |
---|
Wiki Markup |
| Date | | |
| | 1000 | 3000 |
| | 100 | 500 |
|
|
|
withoutDrillDown() { expression } | Opt-out from applied Drill-downs. Example: Section |
---|
Column |
---|
Date | M_INDICATOR | withoutDrillDown() { M_INDICATOR } | UK | 3000 | 3000 | London | 1000 | 3000 | Manchester | 1000 | 3000 | Oxford | 1000 | 3000 |
|
|
|
withoutFilter() | Opt-out from applied filters. Example: (Filter is set to SEGMENT=SMB) Section |
---|
Column |
---|
Date | M_INDICATOR | withoutFilter(M_INDICATOR) | Paris | 1000 | 3000 | London | 900 | 3000 | Berlin | 1100 | 3000 |
|
|
|