2.6.6 DimensionTabularModel

  • Article

The DimensionTabularModel type is extended from the Dimension base type, as specified in [MS-SSAS] section 2.2.4.2.2.8.

The dimension definition is contained in a dimension definition XML file. An example of a generated dimension definition XML file name is Table-Diet.64.dim.xml.

Every tabular model MUST have a dimension defined.

A dimension MUST be defined for every table that is included in the tabular model.

The dimension MUST follow the following rules:

  • An Attribute element of type DimensionAttribute, as specified in [MS-SSAS] section 2.2.4.2.2.8.1, MUST be defined for every column in the table.

  • If the dimension represents a table that is a primary table in a table relationship, a Relationships collection of type Relationships, as specified in [MS-SSAS] section 2.2.4.2.2.8, MUST contain a Relationship element of type Relationship, as specified in [MS-SSAS] section 2.2.4.2.2.8.3, for each relationship defined in the tabular model.

     <xs:complexType name="DimensionTabularModel">
   <xs:complexContent>
     <xs:extension base="Dimension">
       <xs:sequence>
         <xs:group ref="TabularModelElementsGroup"/>
         <xs:element name="PermissionFileList" type="xs:string"/>
       </xs:sequence>
     </xs:extension>
   </xs:complexContent>
 </xs:complexType>

TabularModelElementsGroup: A group of elements that is added to base OLAP types for the tabular model derivations from those types. For more details, see section 2.6.1.3.

PermissionFileList: A semicolon-separated list of the files included in the tabular model metadata that define user permissions for the dimension.