You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Report custom formula for OBIEE Report

Received Response
53
Views
3
Comments
edited Oct 14, 2022 8:23AM in Sales 3 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!