Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

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)
0
mariita
Asked:
mariita
1 Solution
 
HainKurtSr. System AnalystCommented:
this works:

sum(case student_oen when '000000000' then 1 else 0 end)

or

sum(decode(student_oen, '000000000',1,0))
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now