Categories
Error when using LocateN function

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
-
That is a documentation bug. Use Locate function instead.
LOCATE(expr1, expr2, integer)
LocateN Function Is Failing With Error "Formula syntax is invalid" in OBIEE 11g (Doc ID 1391254.1)
0 -
Wow...looks like I need to work on my internet searching skills. I googled but never found that documentation you've provided.
Thank you VERY much. This was a great help.
0 -
You are welcome.
And it's very unlikely that google can crawl and index MOS.
0