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!