Catalog field XML

Question

Summary

Catalog field XML

Content

Hello Community,

I want to convert an XML File to PDF. In the XML there are some catalog fields (for example "1" = male und "2" = female). Is there any possibility to convert the 1 to "male" in the layout editor of the BI Publisher?

Thanks in advance

Niclas Wagenknecht · Answer

Hi YGUTTIKONDA,

there is another problem now. Unfortunately I may not use that hardcoding solution. We have lookup tables in a database for those code values and they change from time to time. Thats why I'm not allowed to hardcode those values in the report.

What I need is the following: I would like to read the code value out of my XML file in the data model of the publisher and afterwards create a SQL statement to get the code name. My problem is that I don't get single fields out of my XML file in the data model. The whole XML file is one single field there.

Do you understand what I mean and is there any possibility to solve that issue?

Shall I open a new thread for that?

Thanks

Niclas

Niclas Wagenknecht · Answer

Sounds cool. I try that. Is it possible to use that for more than two codes? Something like else if?

YGUTTIKONDA · Answer

yes .. below snippet from the user guide 1000 then 'Higher' else if AMOUNT < 1000 then 'Lower' else 'Equal' end if?> Pl Mark Complete / Helpful