This issue needs a solution.

Exporting data from ITA 7.1 Cubes to Excel

Created: 21 Nov 2012
Login to vote
0 0 Votes

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

 

 

Filed Under