Oracle Transactional Business Intelligence Idea Lab

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

How to show XSD data in readable format in BIP xlsx output?

1
Views
0
Comments

I am getting xml tag value of a column in XSD format in BIP xlsx report output and there is requirement to show this column data in more readable format and not in XSD format. Kindly looking for your input on the same. Note - I am using RTF template to design this report.

Below is the sample column value in XSD format:

<?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="urn:swift:xsd:envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><AppHdr xmlns="urn:iso:std:iso:20022:tech:xsd:head.001.001.02"><Fr><FIId><FinInstnId><BICFI>IMFDUS30XXX</BICFI></FinInstnId></FIId></Fr><To><FIId><FinInstnId><BICFI>FRNYUS33XXX</BICFI></FinInstnId></FIId></To><BizMsgIdr>2409501721009000</BizMsgIdr><MsgDefIdr>pacs.009.001.08</MsgDefIdr><BizSvc>swift.cbprplus.02</BizSvc><CreDt>2022-03-24T01:51:31.053-04:00</CreDt></AppHdr><Document xmlns="urn:iso:std:iso:20022:tech:xsd:pacs.009.001.08"><FICdtTrf><GrpHdr><MsgId>2409501921091000</MsgId><CreDtTm>2022-03-24T01:51:31.053-04:00</CreDtTm><NbOfTxs>1</NbOfTxs><SttlmInf><SttlmMtd>INDA</SttlmMtd><SttlmAcct><Id><Othr><Id>021082324</Id></Othr></Id><Ccy>USD</Ccy></SttlmAcct></SttlmInf></GrpHdr><CdtTrfTxInf><PmtId><InstrId>2409501320780000</InstrId><EndToEndId>THIS IS A COPY</EndToEndId><UETR>dd4184a1-c49a-47ac-b752-aff34e0b0b04</UETR></PmtId><PmtTpInf><InstrPrty>HIGH</InstrPrty><CtgyPurp><Cd>OTHR</Cd></CtgyPurp></PmtTpInf><IntrBkSttlmAmt Ccy="USD">1000000</IntrBkSttlmAmt><IntrBkSttlmDt>2023-05-10</IntrBkSttlmDt><InstgAgt><FinInstnId><BICFI>IMFDUS30XXX</BICFI></FinInstnId></InstgAgt><InstdAgt><FinInstnId><BICFI>FRNYUS33XXX</BICFI></FinInstnId></InstdAgt><Dbtr><FinInstnId><BICFI>IMFDUS3WXXX</BICFI><Nm>ACDESC_USA-CURNO1-USD-A</Nm><PstlAdr><AdrLine>ADD1</AdrLine></PstlAdr></FinInstnId></Dbtr><DbtrAgt><FinInstnId><BICFI>IMFDUS30XXX</BICFI></FinInstnId></DbtrAgt><Cdtr><FinInstnId><BICFI>FRNYUS33XXX</BICFI></FinInstnId></Cdtr><Purp><Cd>ADMG</Cd></Purp><RmtInf><Ustrd>/BNF/DEBIT IMF NO.1 ACCOUNT OF INDIA, XDR EQUIVALENT XXXXX, EXCHANGE RATE: ONE INR EQUALS XDR</Ustrd></RmtInf></CdtTrfTxInf></FICdtTrf></Document></Envelope>