I dont have access to the MS SQL Server 2008 Analysis Server where I want to add new cubes and update Dimensions (because hierachy was added).
So I cannot use BIDS, I have to deliver xmla-files to the Administrators
Currently I get this Metadata Manager Error when updating Dimensions:
"transaction cannot be committed because one or more objects were invalidated during the transaction"
I have done researches and found out that it could help
- to use "myDimension.Update(UpdateOptions.AlterDependents);"
- delete cube, change dimension, create cube by running its xmla
- use more RAM (we already have 16GB RAM)
Do you have more recommendations how to update Dimensions without deleting existing cubes (because I actually want to add cubes but need to change DIMs for that)
View Complete Post