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
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
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