Hi I have a cube that was developed and deployed to the production server with an xmla script. I have created an additional hierarchy in a dimension in development and and assigned the appropriate translation attributes in the translations window.
I followed the same steps on the production server but when I tried to assign the translations, the window did not contain and attributes and I am unable to assign the correct translations.
I then created an alter script for the modified dimension on the dev machine and ran it on the production machine and got errors that the measure group were being invalidated, the script failed to commit
The versions of sql server are identical, sql 2008 r2 enterprise.
Any help would be greatly appreciated.
View Complete Post