Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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.

  6. Select the Title Enrichment domain and then go to the CD Rules tab, add a new domain rule, and name it Male Title. In the Build a Rule: Male Title pane, choose Gender in the drop-down list and then choose Value is equal to in the rule drop-down...