Repeat values only

Question

Hi,

I have a subject area with a single fact based on 'People' and 'Interview People' (count distinct and count respectfully on different keys, call them Person Key and Interview Person Key)

This fact joins to; location, time, classification etc etc dimensions.

What I want is a Measure that shows a count of 1 for people who have been interviewed previously, outside of the current period (or any other dimension, i.e. I don't care if it is a different location, classification etc etc, just that that person has another record with the same person key against any other 'tuple' of data

i.e. If I filter to this month (say) I want to see 1 for each person interviewed in that month who has been interviewed previously, either in that time period or outside it.

Is there any non-resource intensive way to achieve this?

thanks,

Robert.

Robert Angel · Answer

Thanks for all your input, I did not think I was missing anything in OBIEE for this, and I was aware of evaluate but try not to resort to it wherever possible for performance reasons.

3365160 · Answer

use evaluate fonction to execute a custom sql (in Oracle use OVER() function

[Deleted User] · Answer

Yeah @Robert Angel you started quite a discussion. We're going at it since half an hour in the chat