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]  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.