Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Report Conversion - Replacement for If(Like...) — Cloud Customer Connect
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 Conversion - Replacement for If(Like...)

Question
13
Views
0
Comments
edited Jan 13, 2015 11:28AM in Reporting and Analytics (TBE)

Content

We currently use the Insight expression If(Like.  It was flagged as an error during the migration.  BI has If and Like functions but there isn't an example using both together.  Also, I do not see the Upper function.  Below is the original Insight expression.

IF(((LIKE(UPPER([REQU|CUSTOM_1065]),"%ASSISTANT%")= TRUE) or (LIKE(UPPER([REQU|CUSTOM_1065]),"%SECRETARY%")= TRUE)),"Y" ,"N")

This expression scanned job titles looking for the text ASSISTANT or SECRETARY.  If either was found in the title the result was sent to "Y" else "N".  In addition, our titles can be mixedcase or uppercase which is why UPPER was used in the expression.  How can I achieve the same result in BI?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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