1 Reply Latest reply on Feb 22, 2017 6:29 PM by Christian Berg

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


      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.