How to Solve the SSAS Cube Browser Error by Using Drag and Drop
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.
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”.
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.pngClick 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.pngNow we can drag and drop the fields:
