AS2005 Cube Excel 2007 Filtering Issue

When browsing our AS2005 Cube we only have one filtering option. Top 10... under the Value Filters menu item. All other filtering options are disabled. I can create a pivot table manually from data in an excel worksheet and the filtering options work fine. Which leads me to believe it is something wrong with our cube design / metadata? Any ideas for what we might need to have the filtering options enabled.Have you installed SP2 on the AS server ? Some features of Excel 2007 are only enabled against AS SP2.|||No it doesn't, I have tested against my local copy of sql server which does have sp2 and it resolved the issue. Thanks for the help.|||

Hello Mosha. It would be interesting to know about the features in Excel 2007 that are disabled before SSAS2005 SP2?

Is this something that you have mentioned in your Blog(multiselect) or something else?

Do you mean internal features like the MDX being generated from Excel2007?

Are these new features being enabled by an update on the client?

Kind Regards

Thomas Ivarsson

|||

> It would be interesting to know about the features in Excel 2007 that are disabled before SSAS2005 SP2?

I agree that it would be interesting to know. This question belongs to the Excel forum, however. Also, in couple of months when everybody has upgraded to SP2, this will become a moot point.

> Are these new features being enabled by an update on the client?

I beleive it's enough to upgrade AS server only.

|||

From what you are saying I think the new features will be in an Office 2007 SP1, not in SSAS2005 SP2, even if SSAS2005 will provide the basis for that.

Writeback in Excel 2007 will be on my whish list.

I think we have a problem of where to post Excel 2007 and ProClarity questions regarding SSAS2005.

Regards

Thomas Ivarsson

|||

For Excel 2007 questions, the following forum seems to be appropriate: http://forums.microsoft.com/technet/showforum.aspx?forumid=544&siteid=17