Exporting to Excel from Data Analysis

[Jennifer L]

Hello,
We're using MOPS 2007. We have built and published about 10 projects, then
made them into a Master Plan (also available on the Server). We created
several custom views in the Data Analysis reporting area on PWA to generate
reports in Excel from this Master schedule.

One view pulls very general information from the Master and when we export
to Excel (Office 2007) it takes little time (about 1-2 minutes). Another view
pulls VERY detailed information (down to the task level) from the Master.
When we try to export this report to Excel it just doesn't do it. We have
even left the computer alone, come back a half hour later, and still nothing
has exported. It launches Excel but does not export the data.

Though there are about 10 projects in the Master schedule, the projects
themselves are not very big (all less than 100 task lines each).

Anyone know what might be causing Excel to freeze up on us?

Thank you!
Jennifer

 

[Marc Soester [MVP]]

Hi Jennifer,

I dont know what excel freezes. It could have many reasons ( network, etc),
but a suggestion would be to use Excel directly. all that the Data Analyser
does is access OLAP Cubes using office web components. You can access these
cubes directly using Excel. It means that you can connect to the OLAP cubes,
create your report, save it and reopen it any time you need it. Excel will
update the report based on the OLAP cubes. This may be an acceptable work
around for you
Hope this helps

 

[Jennifer L]

Thanks for the great response. How do I access the cubes via Excel? I've
never tried this before.
Thank you!
Jennifer

 

[Jennifer L]

Thanks Marc,

I went into Excel and figured it out. Does it matter that we're using
Project Server 2007 and one of our users has Excel 2003? Should that make any
difference in pulling the data directly from the OLAP cube?

Thank you!
Jennifer

 

[Marc Soester [MVP]]

Hi Jennifer,

no that is fine. You can access the Cubes in Excel 2003 or 2007. 2007 has a
nicer interface and reporting capabillities, but apart from that, there is no
issue running it in 2003.