If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

XML Report

Started by nthacker, 15 Sep 2011 09:05:27 AM

Previous topic - Next topic

nthacker

I need to create an XML report.  I have created a list report and when I run it as an XML report the data items come out as
<value>data item </value>
instead of ther column names
ex.
<ID>idnum</ID>

Is there some way I need to define the tags?  The report also needs to have a section with the institution name and info, then another section with the employee info.
Ihave a couple of books but there is not much info in them about XML.
Thanks

nthacker

Does anyone know how to do an XML report in Cognos?
Thanks

kalyanapu

Is there single you are using or multiple quries you are asing to generate the XML report.

XML format doe not support for  Charts , Multiple queries( in report page body, but you can have multiple quieries in prompt page support) and Maps"

Producing a Report in XML Format

XML report outputs save the report data in a format that conforms to an internal schema, xmldata.xsd. You can find this schema file in c8_location/bin.

This format consists of a dataset element, which contains a metadata element and a data element. The metadata element contains the data item information in item elements. The data element contains all the row and value elements.

You can create models from reports and other data that conform to the xmldata.xsd schema. This is useful if you want to use a report as a data source for another report, or if you use a database that cannot be read by Framework Manager. In this case, export the data from the data source to an XML file, in conformance with the xmldata schema, and then open the XML file in Framework Manager.
"

Best Regards,
Srinivas Kalyanapu

nthacker

Thanks for your reply.