Add a User List

1.  Click User List in the Admin Utilities view group.

2.  Click New in the User List window.

3.  Set up basic properties in the User List Maintenance window:

• Description is optional.

• View and security administrators can designate the list as a globally available list by selecting Global as the Type. Otherwise the list will be a personal list.

• Security administrators can designate the list as a security list by selecting the Security User List checkbox. The list will be available to administrators for filtering purposes when they set up roles in addition to being available for filtering views.

4.  Choose a list Mode, either static or dynamic.

5.  The Server and Database drop-down lists will default to the server and database associated with your user profile's role. If you are a security administrator and there are multiple databases registered with Stratum.Viewer, you will need to select which server and database to use for the list.

6.  Use the Dimension, then Hierarchy, and then Level drop-down lists to determine the level on which to base the list.

7.  For Static Lists, click Members, and choose members from the Select or Advanced Select Members window that displays.

OR

7.  For Dynamic User Lists:

• Click Browse , and use the Expression window to set up an expression for determining the list members. See also Example Dynamic User List Expressions.  

• Select the Batch Process checkbox if you want the list definition processed and updated with members during every process of the Stratum.Connector for Viewer Analysis Services database. If you do not select Batch Process, you can manually update the list by clicking Process .

• {Optional} To fine tune the expression for the list, you can do an initial save then click Process. A count of members that meet the expression criteria displays in the Attributes section. You can click the Members button to see a list of those members. If needed, adjust the expression until the members returned fit your analysis needs and then proceed with a final save (step 8).   

8.  Save the user list.