I have a requirement to write a code in OBIEE analysis to pick the newest score for a candidate, such that if 01/05/2018 the took a test and scored say 75 then retook the same test in 3/15/2018 and scored 95, i want my code to return 95 only. how do i accomplish this in obiee?
Set the aggregation rule for the measure to LAST. Either for the time dimension only or - which in the case of a test score would make sense - for all dimensions.