Exporting OLAP Views to Excel

R

Richard

Hi,

I'm having problems exporting OLAP views from Portfolio Analyzer into Excel.

Whenever I export a view containing the Time Dimension, everything is
working fine until I try to drill down into lower levels of the Time
dimension e.g. Quarters, Months. Excel just seems to hang with the message
"Running OLAP query" and then starts consuming large amounts of memory usage
(>50%) on the machine.

After several minutes in this state, I have to shut down Excel and restart.

Has anyone come across this problem before?

I am using Office 2003 with Office Web Components installed OK.

Richard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top