Monday, March 12, 2012

Problem while exporting OLAP data to Excel

Hello all,

I have Analysis Services installed on one machine (dedicated server) .
Other machnines have OLAP application installed (Pivot Table is used).

When client machine tries to export olap data to excel , it takes a long time to load and sometimes it hangs.
Is it related to analysis server settings?

Regards,
Deepti

Deepti, can your provide some more information?

What version of Excel are you using? What version of Analysis Services? Are you trying to export an Office Web Component Pivot connected to Olap data to Excel? If so, what version is the Office Web Component Pivot?

No comments:

Post a Comment