katokay


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.


Re: AS2005 Cube Excel 2007 Filtering Issue

Mosha Pasumansky


Have you installed SP2 on the AS server Some features of Excel 2007 are only enabled against AS SP2.





Re: AS2005 Cube Excel 2007 Filtering Issue

katokay

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.




Re: AS2005 Cube Excel 2007 Filtering Issue

Thomas Ivarsson

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





Re: AS2005 Cube Excel 2007 Filtering Issue

Mosha Pasumansky

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






Re: AS2005 Cube Excel 2007 Filtering Issue

Thomas Ivarsson

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





Re: AS2005 Cube Excel 2007 Filtering Issue

Mosha Pasumansky

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