Hi
I'm trying to browse a cube using excel. I get through the pivot table wizrd ok but when I click finish I am getting the following error:
XML for Analysis parser: The localeidentifier property is not overwritable and cannot be assigned a new value
I get the message regardless of whether I am trying to connect to my own cubes or the Adventure Works sample. Any idea of cause & remedy please
Thanks
Wayne
Excel Browser error
Scott Cadillac
A couple of things you may want to try.
This error seems to occur if local language is anything other than English-US
a) Refer to post http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=961463&SiteID=17. This relates to CTP2, but there are a couple of tips that may be of use.
b) Had a similar issue, & narrowed down to a conflict between AS_OLEDB Version 8 & 9 installed on same PC. Seems the upgrade to 9 doesn't clean up the old version. To resolve this, run uninstall of the existing oledb driver, go to C:\Program Files\Common Files\System\Ole DB & delete all files in this directory if they exist, re-install AS_OLEDB 9.0.
P.S. Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider (OLEDB 9.0) available at www.microsoft.com/downloads/details.aspx FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc
c) Check analysis server default language.
i.e. SQL Management studio, connect to Analysis Server, Properties (right click on server), Language/Collation, set to US English.