Report custom formula for OBIEE Report

Summary:

Previously we have a BIP report and for one column we have used below query.

case when f.NAME like '%Singapore%' then 'AA Singapore'

          when f.NAME like '%Malaysia%' then 'AA Malaysia'

          when upper(f.NAME) like 'ANA U%' then 'ANA US'

           when upper(f.NAME) like 'ANA CA%' then 'ANA CA'

           when (REGEXP_INSTR(f.NAME, '0|1|2|3|4|5|6|7|8|9') -1) > 0 then substr(f.NAME, 1,(REGEXP_INSTR(f.NAME, '0|1|2|3|4|5|6|7|8|9') -1))       

            else f.NAME

            end BUSINESSUNIT

Now we are building the same report in OBIEE using subject area. So in the Business Unit column we have modified the above sql as below.