Defining Event Filters

1. Create an event filter or highlight one in the navigation pane to specify its definition in the edit mode.
2. From the Event list select that event on which the event filter takes effect. For our example choose the CellChange.
3. In the Component to be executed section you must define the module to be carried out when activating the filter. Specify the name of the dll or the project name in the ActiveX box, EvASample for example.
4. In the Class box specify the name of the class that provides the interface function PushRule, clsEvASample for example.
5. From the Function list you can either select one of the three Standard Functions (NOP), or specify a name for the PushRule parameter that has to be passed on to the 'pushrule' method. Only the CellChange event requires this entry.
6. In the Comments box you can include comments or details.
7. In the Database section you specify details on the cube and the dimensions. From the Cube list select the cube the Event Filter applies to.
8. Select one of these element types from the Type list:

   Option	Description
   N	To select base elements.
   C	To select consolidated elements.
   N*C	To select base and consolidated elements.

9. In the dimension fields you can delimit the effect of the Event Filter within the dimensions. Choose the * to include all the elements. To select single elements, use the Browse dimension button and to select subsets, use the Subset dialog button. In our example we select the Price element of the Measures dimension, and keep all the elements in the remaining dimensions. If the Use wildcards check box for a dimension is selected, wildcards are used for element names (’?’ as a wildcard for 1 character, ’*’ for 0 or more characters).

   Option	Description
   Example 1	Element name "200?" Use wildcards is not selected: the pushrule is applied only for the element with the name "200?" Use wildcards is selected: The question mark is used as wildcard, the pushrule is applied for elements named "2001", "2002", etc.
   Example 2	Element name "20*": the pushrule is applied to "20", "200", "2010", "2008", etc.

10. To save your definition, click the Apply button (if you wish to continue working in the dialog box) or the OK button.