Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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