How to validate Subscriber information using the Create Publication Wizard (Enterprise Manager)

How to validate Subscriber information using the Create Publication Wizard (Enterprise Manager)

1. In the Create Publication Wizard, on the Customize the Properties of the Publication page, select Yes, I will define data filters, enable anonymous subscriptions, or customize other properties.
   
   
2. On the Filter Data page, select Horizontally, by filtering the rows of published data, and then on the Enable Dynamic Filters page, select Yes, enable dynamic filters.
   
   
3. On the Filter Table Rows page, click the Filter Clause (...) button next to the article you want to filter, and then in the Specify Filter dialog box, complete the WHERE clause with the function that will retrieve information at the Subscriber and filter the publication dynamically.
   
   
4. On the Validate Subscriber Information page, select Yes, validate Subscriber information, and then type in the functions used in dynamic filters for this publication.