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 a model and an entity


In this example, we will create a model and then create an entity using WebUI. We will learn how to configure an entity configuration using WebUI.

  1. Go to http://localhost/mds in Internet Explorer (IE).

  2. Click on System Administration; in the dropdown that appears, hover on Manage and select Models.

  3. Click on the Add button.

  4. In the Add Model window, uncheck Create entity with same name as model. After unchecking this item, the other two items will be unchecked as well.

  5. Enter the model name as PacktPub_BI_Model. Save the model using the Save button located at top-left hand side under the Main menu.

  6. Hover on the Manage menu again and select Entities.

  7. In the Entity Maintenance window, choose PacktPub_BI_Model from the drop-down list.

  8. In the Add Entity window, enter the entity name as Product.

  9. Leave the staging table name empty, and check Create code values automatically. Set enable explicit hierarchies and collections as no and save.

  10. You will be redirected...