View Items and Functions for Expression - This section displays the hierarchy and level that you selected for the user list from the User List Maintenance window. When you expand the level, you will see an Attribute Relationships folder and Member folder.

• Levels and Attribute Relationships - Click a level or attribute relationship to add it to the dynamic user list expression. Objects can also be drag and dropped into the Expression portion of the window.

• Members - Another tool for building the expression is the Members folder. Click it to access the Select Filter Method window. From there, you can access the Select or Advanced Select Members window. This allows you to select specific members for the expression. Or, you can access the Named Set window and select a named set for the expression in cases when you are working with a single level time dimension.   

When you select objects in the window for an expression, they are added in MDX format. That format includes a reference to the dimension and hierarchy names for the object and in some cases a reference to member values. You can manually adjust or add to the MDX so that it fits your user list filtering needs.

Expression (Examples) - Objects selected from the View Items and Functions portion of the window display in the Expression section. And, you can manually enter and edit text in the Expression portion of the window. Click the Examples link provided to see examples of the required MDX for common types of user lists (Example Dynamic User List Expressions). You can copy the MDX from that topic, paste the example into the Expression window, and customize the expression using your data.

Validate - Click the Validate button at any point while you are building the expression. Stratum.Viewer will verify whether or not the format of your expression is valid.