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.
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
