INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!

*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.

Jobs

Linking to AS 2005 SP2 with Excel, Menus not displaying

Linking to AS 2005 SP2 with Excel, Menus not displaying

(OP)
Greetings:

We have an AS 2005 server with SP2 installed.  A client is trying to use Pivot Tables with the OLAP cube, however, I guess the "Value Filters" are not displaying for them.

According to the following two websites:

CODE

http://www.microsoft.com/sql/technologies/analysis/overview.mspx

http://blogs.msdn.com/excel/archive/2007/05/06/excel-2007-and-sql-server-analysis-services-2005-service-pack-2.aspx
A.S. with SP2 installed should allow these filters; alas, it appears this is not the case.

Has anyone run into this scenario before, or know what we might be doing wrong?  (Or, is this simply a bug that has yet to be worked out?)

I should note that Excel apparently does not have a problem with this when interacting with Excel spreadsheets or MS Access databases...only Analysis Services w/ SP2.

Thanks!

 

  -Ovatvvon          licking face

RE: Linking to AS 2005 SP2 with Excel, Menus not displaying

(OP)

Disregard
 

  -Ovatvvon          licking face

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!

Resources

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