Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


MS AS 2005

MS AS 2005

MS AS 2005

Hi All,

Iam after a general overview what thoughts are about outputting cube data via MSExcel?

I personally find it so slow and time consuming....especially when trying to filter objects, the list is of values is so long the workbook just times out....

What's the best way to represent the cube data?

Many Thanks

RE: MS AS 2005

While not  ahuge fan of excel on top of cubes it does have it's uses and the improvements from previous versions are massive.  If excel times out loading a very high level pivot table then you may want to look at design and perfomance of your cube.  There are various options both from MS and other vedors to allow access to a cube.  Each one has it's pros and cons and just depends on your needs.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close