Access COGNOS 8 Data as live XML source?

[wentriken]

Hello, I am an end user of COGNOS 8. I have created a great report in Analyst and would like to export this as XML.

In Excel I would like to open the URL and collect the data (Data->Get External Data->From Web). Then next month, I can log in to Excel and refresh the data source so it will re-download the data and update the sheet.

Is this possible?

Thank you!
William Entriken

[wentriken]

Update: I did find the COGNOS URL guide:
http://public.dhe.ibm.com/software/dw/dm/cognos/reporting/scripting_techniques/using_urls_in_cognos_8.pdf

But am still seeking to make this work

[blom0344]

I can reach the saved xml from within Excel, but without a schema Excel will have no clue how to import the xml data.

Take a look here:

http://social.msdn.microsoft.com/Forums/en/sqlxml/thread/e14b3181-79ff-4169-a10f-9602341f8442