Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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
Anil Pandey-Oracle
Anil Pandey-Oracle Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Idea Lab

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>