Converting XML object to normal varchar in SAP BO universe

[vaibhav_rathore]

Hi Experts,

I have a table called "Applications" which includes normal other columns with data type varchar but there is one column which is undefined is "applications" and it contains details XML tag: pfx:LPLForm/pfx:TRANSACTIONS/pfx:TRANSACTION[1]/pfx:grossPremium

please guide me how can i get the "Gross Premium" out of this as the requirement is to get the Gross Premium into the report. How can i convert this to normal column that i can use in Webi.

DB used is My SQL and IDT 4.1.

Please suggest.

Thanks

Vaibhav

[ayman_salem]

A screenshot of sample data and the expected result will help us understand your question correctly and give you the possible correct answer.