Cross-referencing Values from Different Data Set

CrossValue function is used to access Indicators from other Data Sets.

It receives two parameters:

1. Cube name
2. Indicator name

Following example returns Students count from Results data set.

crossValue('CUBE_RESULTS.RESULTS', 'L_STUDENT_COUNT')

Cross Reference with Drill-down

When cross-referencing values, BellaDati does not take in consideration applied drill-downs. It is possible that it will display same value for each member.

Therefore, you need to explicitelly tell BellaDati, which member is currently processed and set up filter to process only values related to this member.

You can achieve this by combining filter and mamberValue functions.

filter("L_PASS_RESULT in ('"+memberValue()+"')"){  
	crossValue('CUBE_RESULTS.RESULTS', 'L_STUDENT_COUNT')
}

Cross Reference with Filter

BellaDati also does not take in consideration filters applied throught view settings. Therefore, you need to explicitelly tell BellaDati in formula definition which filters and how do you want to use them.

filter("L_PASS_RESULT in ('" + memberValue() + "') AND L_PASS_SUBJECT in ('Math')"){  
	crossValue('CUBE_RESULTS.RESULTS', 'L_STUDENT_COUNT')
}

You can find more about filters and their combinations in Filtering in Formulas.

Next Steps

• Calculating Average Cumulated Values
• Calculating Percentiles and Quantils
• Getting Last Available Value