Page History

...

Following example returns Students count from Results data set.

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

...

You can achieve this by inserting memberIdentifier as second parameter of crossValue functions.

crossValue('CUBE_CRAFT_COUNT_HOURS.CRAFT_COUNT_HOURS_',
           memberIdentifier(),
           'M_HOURS');

...

member-identifier

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')
}

Cross Reference with Date

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

...