Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

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

1
Views
1
Comments
Jo-
Jo- Rank 2 - Community Beginner
edited Aug 13, 2024 6:06PM in Oracle Analytics Forum

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.

Comments