How to Solve the SSAS Cube Browser Error by Using Drag and Drop

  • Article

How to solve SSAS cube browser error and doing some drag and drop.

Summary: This is in an example of correcting the error in a Cube in SSAS.

Problem: In our situation there was a problem when we browser a cube and drag any field it show some error.

The query could not be processed: 0 XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a new value.

http://jeeveshfuloria08.files.wordpress.com/2011/03/19.png

Solution:

If we click on browser in a cube it show above error this is because of your regional settings.

Regional settings have different settings between the "Regional Options" tab and the "Advanced" tab in the "Regional and Language” tab in control panel.

So for solving this error go to start menu then go into the "control panel" and click on “Clock, Language, and Region”.

http://jeeveshfuloria08.files.wordpress.com/2011/03/24.png

Open "Regional and Language Options".

http://jeeveshfuloria08.files.wordpress.com/2011/03/32.png

Click on the "Formats" tab; select English (United States) from format.
http://jeeveshfuloria08.files.wordpress.com/2011/03/44.png

Click OK.

http://jeeveshfuloria08.files.wordpress.com/2011/03/54.png

Now select the cube from server explorer. Go to browser. Now see there is no error in browser.
http://jeeveshfuloria08.files.wordpress.com/2011/03/64.png

Now we can drag and drop the fields:

http://jeeveshfuloria08.files.wordpress.com/2011/03/74.png