Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
catalog field XML (no hardcoding allowed) — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

catalog field XML (no hardcoding allowed)

Received Response
4
Views
5
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 5 comments

Summary

catalog field XML (no hardcoding allowed)

Content

Hello community,

 

actually I'm creating a PDF report out of a XML file. The XML file is stored as CLOB in the database.

 

Unfortunately there are catalog fields in the XML data (For example: ES instead of Spain, M instead of Male). The final report should print out the full name. There exist some lookup tables in a database where I can find the connection of ES and Spain and so on.

 

I'm not allowed to hardcode this in the report by using conditional formats because lookup tables change from time to time and the owner of the report doesnt want to change the report then. Instead I need some sort of connection in the data model.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!