Aggregation measure with equivalent of SQL "not in" operator
Posted on 2014-11-27
I am using the Oracle BI Administration Tool (BMM model) . How would I create an aggregation measure that uses the equivalent of the a SQL "not in" logical operator?
I need to count all records where the value does not equal '999999999','999999998','000000000'.
The SQL equivalent would be something like:
sum(case when student_oen NOT IN ('999999999','999999998','000000000') then 1 else 0 end) as count_oen_other