After deploying a Business Intelligence project how to recreate the OLAP security

During development the project is focus on schema and schema changes and test

security. When I I deploy the database to production, I end getting

the development security in the production database. How does one create

a script that recreates the security in the production environment so that I can

be reused it after the deployment. The synchronziation wizard is not appropriate

since it moves data as well.

In SQL

Server Management Studio you can access Script related menu commands from the

context menu. All management dialogs in that program also have Script button on

the toolbar. An object can be scripted and script re-executed on another

server.

Additionally you can import entire database as a BI Development project using. In

BI Development Studio - menu File | New | Project and choose the project of

type "Import Analysis Services 9.0 Database". That imported solution

can be adjusted and deployed onto another server.

|||

I not sure what is meant by context senstive menus? I was hoping for a faster method.

I know that what I ending up doing was for each role in the production database Roles Heading:

I right clicked on the properties of the role and then selected the "Cubes" page and then clicked the Script Action menu.

This took 3 hours to do for all of the production roles:

I am not sure I understand the second choice since I did this at the beginning of the project, removed all of the

production security, made hundreds of changes to cubes and dimensions and readded the development security interactively.

|||You actually did what i meant. Performance is another story.