[Webinar] Streamline your web hosting managementRegister Today

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

OBIEE column formula with multiple criteria

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')
and
 "Enrolment - College"."D Registration Status"."Registration Status Code"   in ('10','41')
and
"Enrolment - College"."F College Enrolment"."Semester" in ('NOV')
)
then 1 else 0 end)
0
mariita
Asked:
mariita
1 Solution
 
slightwv (䄆 Netminder) Commented:
Never used OBIEE but that case statement isn't correct syntax for regular Oracle.

The two syntaxes are:
1:  case some_object
         when some_value then some_value
         when some_other_value then some_other_value
      end

2: case when some_object=some_value then some_value
              when some_other_object=some_other_value then some_other_value
    end


It appears you are trying to mix them.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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