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:
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 :-Q
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:
[URL unfurl="true"]http://www.microsoft.com/sql/technologies/analysis/overview.mspx[/URL]
[URL unfurl="true"]http://blogs.msdn.com/excel/archive/2007/05/06/excel-2007-and-sql-server-analysis-services-2005-service-pack-2.aspx[/URL]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 :-Q