Hello Robert with AX 4 sp2 you can modify the OLAP cube structure and publish the pivot in the ERP menu, but the pivot security settings are not managed by AX, but using the SQL server Management Console.

With the Management Console, we created roles and for each role we setup the security.

Every time we modify the cube structure using AX and with that AX tool we deploy that modifies in the pivot, then each setting done in the roles is lost.

Considering that we've a lot of pivot and each pivot have several roles, I can tell that is really annoying to rebuild the security each time.

For this reason i'm looking for a solution, that permits us to avoid to rebuild the security each time.

Thanks in advance to anyone that can help me.