A blog about designing and developing Business Intelligence solutions using Microsoft SQL Server

XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a new value

August 10th, 2012 | Posted by David Stewart in Analysis Services

Previously I wrote a post about the LocaleIdentifier error when browsing an Analysis Services cube via Management Studio. Whilst it’s annoying, it really only affects developers so quickly slips down the list of priorities to address! However, when it starts to affect users it becomes a serious issue. Working on another project with an Excel component this issue came up in a couple of places – connecting to the cube from Excel (sometimes), and using drill-through in Excel.

After looking into this for a while I came across a solution, although it’s not one I feel completely comfortable with.

1. Go to Windows > Control Panel > Region and Language

2. Update the Format to “English (United States)”

Region and Language Format

3. Click Apply

4. Update the Format back to your original language, in my case “English (Australia)”

5. Click Apply

6. Click OK

You can follow any responses to this entry through the RSS 2.0 You can leave a response, or trackback.

2 Responses

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>