Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I view the mdx that excel sends?

Status
Not open for further replies.

bradbruno

Programmer
Jan 9, 2003
1
US
Excel is slow when I am designing an excel piviot table report based off a cube in excel 2002. How can I see what query is being sent to analysis server?
 
How slow? How many rows? Is the cube on a local disk (faster) i.e. on the same PC or being acessed across the network (slower)? How fast is your PC?

On slow PCs I have found that once the cube "warms up" it goes faster (seriously, I'm not kidding, it must be caching data locally)

Please let me know your experience because I'm about to commit to an XP PivotTable-based MIS strategy!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top