Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Exporting data from ITA 7.1 Cubes to Excel

Created: 21 Nov 2012

I meed help for opening Cubes in Excel:

I can easily export ITA Dashboards and ITA Reports to Excel (2010). Unfortunately opening Pivot Tables (Cubes) in Excel always fails. 

I did not find any useful KB artticle (like HOWTO62410 does not help) nor instructions in ITA documentation.

It looks to me that some "Data Connections" should be created in Excel, since user may not have required access privileges to SQL.

First error in Excel says "Data connections have been disabled." >> Enable Content.

By doing that, some more errors appear, like this one: "XML for Analysis parser."

Any guidance is more than welcome :-)

Thanks, Jan