JesseDW (8/22/2012)
I can query the SQL view in Mgt. Studio and see all of the numbers.Excel Pivot Tables work for views that are not using linked servers pointing to Oracle so....
It is either...
1. An Excel bug when connecting to this type of view--most likely
2. Excel requires a certain setup on the view and/or linked server in order to work properly
Does that make sense?
Excel shouldn't even know the SQL Server view is a view pointing to an Oracle view via a linked server -- I agree the issue is most likely around the Excel piece. If after a reasonable amount of time solution still refuses to work I would open a case with Microsoft.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.