I am using the Oracle BI Administration Tool to create a business (BMM) model. I want to create a logical column that calculates the number of enrolment records that meet a set of criteria. I tried the formula below, but I'm getting a syntax error.
sum(case "Enrolment - College"."F College Enrolment"."Enrolment ID" when
( "Enrolment - College"."F College Enrolment"."Area Flag" in ('O')
"Enrolment - College"."D Registration Status"."Registration Status Code" in ('10','41')
"Enrolment - College"."F College Enrolment"."Semester" in ('NOV')
then 1 else 0 end)
Cursors in Oracle:
A cursor is used to process individual rows returned by database system for a query.
In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
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.