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

Creating models and entities


MDS will store data in entities; multiple entities of the same subject can be stored in a model. A model is a container of some entities and can have a specific permission assigned to it. A model in MDS is similar to a schema in a database, because it contains some objects (entities), which has permissions on it related to groups or users. An entity is a data object that is similar to a table in a database. Each entity has two mandatory and default columns (Name and Code) and the ability to add as many as columns for covering the requirement. Entity members are equal to rows in the table, and entity attributes are columns.