How to create an aggregation measure that uses a SQL logical operator
Is it possible to create an aggregation measure that uses a SQL logical operator in the Oracle BI Administration Tool (BMM model)?
When I create a new logical column, it seems that I can either create an aggregation measure, or use a logical operator, but not both.
If I select a "default aggregation rule", then "derived from existing columns using an expression" is grayed out.
If I select "derived from existing columns using an expression", then "default aggregation rule" is grayed out.
I need to count all records where the value = 000000000. The SQL equivalent would be something like:
sum(case when student_oen IN ('000000000') then 1 else 0 end)
When I create a new logical column, it seems that I can either create an aggregation measure, or use a logical operator, but not both.
If I select a "default aggregation rule", then "derived from existing columns using an expression" is grayed out.
If I select "derived from existing columns using an expression", then "default aggregation rule" is grayed out.
I need to count all records where the value = 000000000. The SQL equivalent would be something like:
sum(case when student_oen IN ('000000000') then 1 else 0 end)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.