July 21, 2010 at 1:38 pm
I have several sql server 2005 analysis services cubes that I connect to via MS Excel 2003 and MS Excel 2007. Several of my users recently upgraded their PC's to Excel 2010. These users now get the following error messages that prevent them from browsing the cubes, "XML for Analysis parser: The DbpropMsmdSubqueries property was not recognized" and "XML for Analysis parser: The restriction value provided by the consumer either does not match other restrictions or refers to an unknown object".
My test PC is running MS Windows XP Pro 2002 sp3 and MS Office 2010. I reinstalled SQLServer2005_ASOLEDB9 and msxml6_x86, but the problem continues.
We are running this version of SQL: Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
July 22, 2010 at 5:37 am
Hi Patrick,
Some of our users in Norwary got that error when they installed Excel 2010. I believe they installed the following patch on each user machine:
Give it a go.
Andy
July 22, 2010 at 7:57 am
Thanks, Andrew. The download fixed the problem.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply