When multiple security filters need to be applied to multiple users, this task becomes complicated if they are linked manually using the MicroStrategy Desktop 8.1.x and 9.0.x Interface. MicroStrategy Administrator – Command Manager 8.1.x and 9.0.x has routines and scripts to help with this task, but sometimes it is also a complicated task when hundreds or maybe thousands users and security filters are involved. With the help of 3rd party software tools (Microsoft Excel and Notepad), this task can be accomplished much more easily.
Follow the steps below to assign multiple security filters to multiple users in MicroStrategy Administrator – Command Manager 8.1.x and 9.0.x:
- Open MicroStrategy Administrator – Command Manager 8.1.x and 9.0.x. On the menu bar, go to Connection -> Results -> To Grid, as shown below:
- Insert the following outline:
LIST MEMBERS FOR USER GROUP “Everyone”;
- This outline lists all the users in the Everyone group. Run the script (his may take several minutes), as shown below:
- Select all the users and copy and paste them into a Notepad document. Save that document as users.txt, as shown below:
- Open the document users.txt in Microsoft Excel and select the following options as they appear in the Text Import Wizard:
- Review that there is NO SPACE after the last letter of the names in Column A, as shown below. If there is a space, go back to step 3 above.
- Delete the remaining columns (B for this example), as shown below:
- Cut column A and paste it in column D.
- Add the following cells to row 1 to column A, B, C & E:
A B C E APPLY SECURITY FILTER “ XXXX ” FOLDER “MD Security Filters” TO USER “ ” ON PROJECT “PROJECT_NAME”; - Drag columns A, B, C, & E until they reach the bottom row with the last user in column D by selecting the little black dot in the bottom right-corner, as shown below:
Replace column B manually with the respective security filter for each user, as shown below:
- On cell F1, insert the following formula:
=CONCATENATE(A1,B1,C1,D1,E1)
- The following string must be in cell F1, for example:
APPLY SECURITY FILTER “1007” FOLDER “MD Security Filters” TO USER “user1” ON PROJECT “Project A”;Drag column F until it reaches the bottom row with the last user in column D by selecting the little black dot in the bottom right-corner. Column F should appear as follows:
- Select column F and copy and paste it in MicroStrategy Administrator – Command Manager. Execute the command. The security filter will start to apply to each user, as shown below:
