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 – creating synonyms and setting standardization


In this example, we will create some synonyms for countries, for instance, USA, United States, and US. And we will also set the standardization format for the Knowledge Base domains. Perform the following steps:

  1. Open Address KB in the Domain Management mode.

  2. Select the Country domain and then go to the Domain Values tab.

  3. Add two new domain values: USA and US.

  4. Select these three values: United States, USA, and US. Then click on Set selected domain values as synonyms, which is the fourth icon from the left on the top-right-hand side icons' list.

  5. You will see that a hierarchical list will be created under United States, with US and USA as the second levels. This means that the heading value is United States and this value has two other synonyms: US and USA. The following screenshot shows the hierarchical list:

  6. Go to the Domain Properties tab of the Country domain. Make sure you have the Use Leading Values checkbox checked. And also format...