Yes, it may sound strange. When we started using Excel 2007 our pivot table connectivity saw a performance drop.
As near as I can tell, Excel 2007 wants to do a Discover for
MDSCHEMA_PROPERTIES with a RestrictionList of
Since the restriction does
not filter on a particular cube, it appears that the operation is causing the user's dimension security to be calculated for
every single cube in the database.
This is not a behavior that occurred in Excel 2003. I noticed that t
View Complete Post