Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide

Time for action – composite domain rules

In this example, we will create a Knowledge Base with a composite domain for title enrichment. The title enrichment CD has three domains: Title, Gender, and Marital Status. Then we will create a CD rule to fetch the correct title based on gender and marital status with the following steps:

1. Create a new Knowledge Base and name it Customer KB.
2. Create three domains of string data type named Title, Gender, and Marital Status.
3. Select the Gender domain in the Domain Values tab and add two values: F and M.
4. Add two values for the Marital Status domain: S and M. And add three values for the Title domain: Mr., Mrs., and Ms..
5. Create a composite domain containing all three domains mentioned earlier and name it Title Enrichment ...