Solved

How to create an aggregation measure that uses a SQL logical operator

Posted on 2014-11-27
1
188 Views
Last Modified: 2014-11-27
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
Comment
Question by:mariita
1 Comment
 
LVL 51

Accepted Solution

by:
HainKurt earned 500 total points
ID: 40469008
this works:

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

or

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

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now