Model Designer Object Properties
A report model consists of three parts:
Semantic Model: A semantic model contains your business model of the data, which is described in terms of familiar names such as Products or Customers.
Physical Model: A physical model contains a physical description of the database with optional transformations, such as defined queries within the Data Source View, to more closely correspond to the business model that you want.
Mapping: A mapping describes how the semantic model is represented within a physical model and binds semantic objects to their corresponding physical objects.
Each report model created by Report Model Designer contains exactly one semantic model, one physical model, and one mapping.
A report model is written in Semantic Model Definition Language (SMDL), which is XML-based. A SMDL file is used to create models when calling the report server Web service. The namespace URI for SMDL is http://schemas.microsoft.com/sqlserver/YYYY/MM/semanticmodeling, where YYYY/MM indicates the date of the release of that version of SMDL. The standard file extension for SMDL files is .smdl. The MimeType to use for SMDL files is simply text/xml. All identifiers in SMDL are case-sensitive and match using Invariant culture. In this documentation, SMDL elements are discussed as objects and collections.
This section discusses the different properties associated with a model and that can be assigned within Model Designer.
ID, Description, Version, Entities, Culture, Perspectives, CustomProperties, DataSourceView
Defines the entire model.
Name, DataType, Nullable, Expression, SortDirection, Width, Alignment, MimeType, DataCulture, DiscourageGrouping, EnableDrillthrough, Format, ContextualName, IsAggregate, IsFilter, OmitSecurityFilters, DefaultAggregateAttributeID, ValueSelection, Binding
Defines an attribute of an entity.
Contains a reference to an attribute along with an optional path that can be used to reach that attribute.
Contains the information about how an entity, attribute, role, or inheritance binds to a physical data source.
Defines the column to which an entity or attribute is bound.
Allows model design tools to store implementation-specific properties.
Contains application-specific data.
Contains references to the aggregate attributes to be shown when a summary of multiple instances of this entity is displayed.
Contains references to the attributes to be shown when an instance of this entity is displayed.
Contains the attribute that is used as a filter on the entity if no security filters are present.
Contains an ordered list of entities and entity folders in the model.
CollectionName, UniqueConstraints, IdentifyingAttributes, DefaultDetailAttributes, DefaultAggregateAttributes, SortAttributes, InstanceSelection, IsLookup, Inheritance, DisjoinInheritance, Fields, SecurityFilters, DefaultSecurityFilter, Binding
Defines an entity within the model.
Defines a folder that contains entities (and entity folders).
Defines a field (attribute or role) of an entity.
Defines a folder that contains fields (and field folders).
Contains an ordered list of fields (attributes and roles) and field folders for the entity.
Contains references to the fields and field folders that should not be displayed for the role's target entity when the role is used to reach the entity.
Contains references to the attributes used to identify an instance of the entity to the user.
Defines how the entity inherits from another entity.
Defines linguistic properties of a role.
ID, Name, Description, Hidden, CustomProperties
Defines an element of the model: an entity, entity folder, field, or field folder.
Contains a list of model items in the perspective.
ID, Name, Description, ModelItems, CustomProperties
Identifies a subset of the model to provide to users as a submodel.
Contains a list of perspectives of the model, for example, model subsets.
Defines recursive traversal properties of a role.
Defines the relation to which a Role or Inheritance is bound.
Name, Linguistics, RelatedRoleID, Cardinality, ContextualName, HiddenFields, ExpandInline, PromoteLookup, Preferred, Recursion, Binding
Defines a role (a related entity) of an entity.
Contains attributes which should be used as filters on the entity.
Contains a reference to an attribute on which to sort.
Contains references to attributes on which to sort.
Defines the table to which an entity is bound.
Contains fields which are considered variations of the containing field.