i need to restore cube role defaults on a whole lot of roles in a whole
lot of cubes. As it is right now i have to do it manually, going into
each cube and opening each role, click Restore Defaults, and for each
writeback enabled cube i also have to enable unrestricted read/write.
I am working on a SQL Server 2000 Enterprise edition with service pack 3
analysis service from the same package and also with service pack 3.
I have migrated the repository.

All the roles are defined on a database level. but when changes to roles
are made on database level, they are not propagated to cube roles before
i click Restore Defaults on the cube roles.

Please advise, and if you have a script i would love to se it.

Regards Isak