syntax to call LPAD function in physical layer of the Admin tool (OBIEE)

Jo-

I am trying to create a join in the physical layer of the Admin Tool wherein I would call the LPAD funcation

Here is an example of what I am trying to do:

column_name = LPAD(column_name2, 14, '0')

Unfortunately, I get following error:

[2017-02-22T09:53:36.000-06:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: ec0]  [46153] The configuration file (security.xml) was not found or is inaccessible.

I searched Admin Tool Help for LPAD function but could not find anything.

Please help if you have any suggestion.

[Deleted User]

Zero information about source, versions involved on either side or anything else of pertinence...

https://www.youtube.com/watch?v=5CgBmj7Jz6Y&t=27s

How To Ask Questions The Smart Way