Avatar of mariita
mariitaFlag for Canada

asked on 

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)
Oracle DatabaseDB Reporting Tools

Avatar of undefined
Last Comment
HainKurt
ASKER CERTIFIED SOLUTION
Avatar of HainKurt
HainKurt
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Oracle Database
Oracle Database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo