This article is about the case expression in OBIEE Logical SQL.
This operator calculation have two type:
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.
A Point-and-click generation of case statement logic is given by the Bins tab of the Column Formula
If the last ELSE statement is omitted, “ELSE NULL” is assumed. The case when statement returns then NULL.
CASE WHEN "Sales Facts"."Amount Sold" > 600000 THEN 'Big'
WHEN "Sales Facts"."Amount Sold" > 300000 THEN 'Middle'
ELSE 'Small' END
Request Condition Operator:
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'
END
'Administrators;XMLP_ADMIN' in ('Administrators', 'CNT_ADMIN')