I have a Analysis Services 2008 project that I distribute to client
servers with xmla. On the client site I add roles and memebers to the
cubes (maually)
I could not find a way to script those roles to xmla after entering
them manually.
This is necessary when I send an update of the project (complete
xmla). As the roles depend on the customer and the local AD I cannot
prepare the roles in my big xmla.
What I would like to do is something like:
Quote:
export all existing roles/memberships/dimension sequrities to xmla (on the customer site)
replace the entire project (run big xmla)
import xmla with roles/memberships/dimension |
I tried to skript the roles structure with the management studio. It
never gives me the complete xmla - only the part of the node. I would
have to export lots of xmla.
Any ideas?
Thanks!