Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Jo-Feb 22 2017 — edited Feb 23 2017

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
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2017
Added on Feb 22 2017
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
1 comment
431 views