Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Error when using LocateN function

Received Response
193
Views
3
Comments
Chris Arnold
Chris Arnold Rank 5 - Community Champion

I am trying to use the 'LocateN' function by doing using the following formula in OBIEE 12c:

LocateN('.',"PROCESS_LOG"."PROCESS_STEP_NO",3)

I am receiving the error:

[nQSError: 27042] Function LOCATEN is not defined by administrator. (HY000)

I have Googled this error message and I am not finding anything.

Is LocateN not able to be used in 12c?

Answers