Create BO XI report using XML and XSD

[Former Member]

Hi,

Would like to know if its possible to generate report from BO XI Deski using VBA. We have set of XML and XSD files provided by the client which contains data about reports already generated by them using Actuate.

Please let me know is its possible to write program using VBA script within BO XI which will take input from XML and XSD and then generate report using Free Hand SQL and will contain basic structure of a table.

Any help in this regards shall be much appreciated.

Thanks

Vishant

[Former Member · Accepted solution]

Hi Vishant,

In Desktop Intelligence SDK, there is an "ExportAsXML" method as well as a "SaveAs" method that could save a Desktop Intelligence report in XML. In the DeskI Application you can easily use the following options.

- Visual Basic for Application procedures

- XML Data provider.

If it is a Desktop Intelligence Report then we can export it to XML via the Desktop Intelligence SDK - using the ExportAsXML method or the SaveAs method.

Could you please visit the following link?

http://devlibrary.businessobjects.com

Regards,

Sarbhjeet Kaur

[Former Member · Accepted solution]

Hi Sarbhjeet,

If would be helpful If you could send me some example on how to traverse through XML file from Deski VBA. I would like to create dataprovider and then a report based on the input from XML file.

Thanks

Vishant

[Former Member · Accepted solution]

Hi Vishant,

I donu2019t have fair idea about this however the following code might help you to get the input from the XML file using VBA macro.

Module: modImportXML

Function: getArrayFromBOTable()

ThisDocument.Reports(1).ImportAsText (sBOTextFileName)

Or try the following if above doesn't works

Module: modExportXML

Function: getArrayFromBOTable()

ThisDocument.Reports(1).ExportAsText (sBOTextFileName)

The format for an XML data source is as follows:

<?xml version="1.0" encoding="UTF-8" ?>

- <Data Provider>

- <Row1>

<Column1> Value1 </end of Column1>

<Column2> Value2 </end of Column2>

</end of Row1>

- <Row2>

<Column1> Value1 </end of Column1>

<Column2> Value2 </end of Column2>

</end of Row2>

...

</end of Data Provider>

The XML file you will use, XMLIMPORT.XML, has the following structure:

<?xml version="1.0" encoding="UTF-8" ?>

- <Resorts>

- <Resort>

<Country>France</Country>

<ResortName>French Riviera</ResortName>

<ServiceLine>Accomodation</ServiceLine>

<Revenue>563250</Revenue>

</Resort>

- <Resort>

<Country>France</Country>

<ResortName>French Riviera</ResortName>

<ServiceLine>Food and Drinks</ServiceLine>

<Revenue>107400</Revenue>

</Resort>

- <Resort>

<Country>France</Country>

<ResortName>French Riviera</ResortName>

<ServiceLine>Recreation</ServiceLine>

<Revenue>164770</Revenue>

</Resort>

- <Resort>

<Country>US</Country>

<ResortName>Bahamas Beach</ResortName>

<ServiceLine>Accomodation</ServiceLine>

<Revenue>67364</Revenue>

</Resort>

- <Resort>

<Country>US</Country>

<ResortName>Bahamas Beach</ResortName>

<ServiceLine>Food and Drinks</ServiceLine>

<Revenue>169680</Revenue>

</Resort>

- <Resort>

<Country>US</Country>

<ResortName>Bahamas Beach</ResortName>

<ServiceLine>Recreation</ServiceLine>

<Revenue>128100</Revenue>

</Resort>

</Resorts

Regards,

Sarbhjeet Kaur