OBIEE - Case When Statement

Obiee Ceim


This article is about the case expression in OBIEE Logical SQL.

This operator calculation have two type:

  • In a CASE statement, AND has precedence over OR.
  • If no ELSE expression is specified, the system will automatically add an null.

You can enter it on every place where you create a logical sql as the formula in Presentation service but also in the BI Server Expression Builder.

Obiee Case When Lookup

A Point-and-click generation of case statement logic is given by the Bins tab of the Column Formula

Type of case


If the last ELSE statement is omitted, “ELSE NULL” is assumed. The case when statement returns then NULL.

Case If

CASE WHEN "Sales Facts"."Amount Sold" > 600000  THEN 'Big' 
     WHEN "Sales Facts"."Amount Sold" > 300000  THEN 'Middle' 
     ELSE 'Small' END

Request Condition Operator:

  • >
  • =
  • IN The IN operator can only be used in the repository and not in the logical sql (ie in an answer/analytics)

Case Switch

It's also known as the case Lookup.

CASE  Promotions."Promo Subcategory" 
WHEN  'TV commercial'          then 'Commercial'  
WHEN  'TV program sponsorship' then 'Sponsor'  
ELSE  'Default' 



With the GROUP system session variable in the repository

'Administrators;XMLP_ADMIN' in ('Administrators', 'CNT_ADMIN')


Discover More
Obiee Row Wise
OBIEE - (Row-wise|List of Values) server variable

A server variable can be initialized to a list of values (vector) with the row-wise initialization option of an Init block. cached This SQL statement populates the variable MY_VARIABLE_NAME with...
Obiee Parameter Prompt Result
OBIEE - Dashboard parameter prompt - The WHEN 1=0 or ifnull solution

You may need to create a dashboard prompt to set a presentation parameter (as for the hierachy level) to change the behaviour of your dashboard. The dashboard prompt is based on the column of a subject...
Obiee User Group Permission Filter
OBIEE - Data security (visibility of data)

This article is data security or authorization in OBIEE. Data-level security controls the visibility of data (content rendered in subject areas, dashboards, Oracle BI Answers, and so on) based on the...
Obiee Ceim
OBIEE - Functions

The home page of OBIEE functions of the logical sql and from BI Server. See Logical SQL Reference
Obi Edition
OBIEE - Localization

localization refers to the process of adapting the Oracle Business Intelligence deployment to a particular language. Part of the process of customizing is localizing the interface, if...
Obiee Pivot Measures
OBIEE - Pivot Measures (The Filter Function)

Indicator, description of Measures are generally the sign that you need to pivot your measure (i.e. to create a Pivot Measure) The revenue is booked. Revenue is the measure and booked is a description...
Obiee Data Is Dense
OBIEE - Repository Aggregation rules based on dimension (dimension-specific aggregate)

Obiee offer the possibility to have differents measure aggregation rule based on the dimension. This functionality is really tied to the last and first function (in order to define its grain ?) ...
Saw Object
OBIEE 10G/11G - Conditional Filtering based on Presentation Service Variable

How to apply a filter based on a condition ? The value of stock is a good example. You can't sum it because it's point in time fact. The stock at the end of the week is not the sum of all stock by...
Sqlite Banner
SQLite - Date

The date data type in SQLite context does not exist. It is not an affinity. SQLite are capable of storing dates and times with the following data type (affinity) as: TEXT with ISO8601 strings (“YYYY-MM-DD...

Share this page:
Follow us:
Task Runner