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.
1