2.1.13 TProperty

The TProperty complex type annotates the Property element that is defined in [MC-CSDL] section 2.1.3. The TProperty complex type is an extension of the TBaseProperty complex type (section 2.1.14) that adds attributes that appear only in instance columns.

The TProperty complex type is defined in the schema as follows.

  <xs:complexType name ="TProperty">
    <xs:extension base="bi:TBaseProperty">
     <xs:sequence >
      <xs:element name="OrderBy" type="bi:TPropertyRefs" minOccurs="0"
      <xs:element name="GroupBy " type="bi:TPropertyRefs" minOccurs="0"
      <xs:element name="RelatedTo" type="bi:TPropertyRefs" minOccurs="0"
       <xs:element name="DefaultValue" type="xs:any" minOccurs="0"
      <xs:element name="FilterNullsBy" type="bi:TPropertyRefs" minOccurs="0"
     <xs:element name="Statistics" type="bi:TPropertyStatistics" minOccurs="0"
     <xs:attribute name="Contents" type="bi:TContents" use="optional"
     <xs:attribute name="DefaultAggregateFunction"
       type="bi:TDefaultAggregateFunction" default="Default" />
     <xs:attribute name="GroupingBehavior" type="bi:TGroupingBehavior"
     <xs:attribute name="Stability" type="bi:TStability" default="Stable"/>

The element and attributes that are defined by the TProperty complex type are specified in the following tables.




A reference to a property within the entity that defines the sort order for that property's values. The values for the current property and the OrderBy property SHOULD have a 1-to-1 mapping. Otherwise, the sort behavior is undefined. If this element is omitted, the properties are sorted based on their values.


In CSDLBI 2.0, a reference to other properties within the entity that MUST be used as GroupBy columns when the Data Analysis Expressions (DAX) query contains the current property. Otherwise, the query will fail.


In CSDLBI 2.0, a reference to other properties within the entity that are related to the current property. This information MAY be used to construct DAX queries that will give the same results as equivalent multidimensional expression (MDX) queries that take attribute relationships into account.


In CSDLBI 2.0, a property that specifies the value that SHOULD be used when evaluating the query. The DefaultValue property is optional, but it is automatically selected if the values from the member cannot be aggregated.


In CSDLBI 2.0, a reference to other properties within the entity that SHOULD be used in DAX queries to properly construct filter by NULL values.


In CSDLBI 2.0, a set of statistics from the underlying data that is associated with the column. These statistics are defined by the TPropertyStatistics complex type and are provided only if they are not computationally expensive to generate, as described in section




The type of data in a column. This value is drawn from the DimensionAttribute complex type, as defined in [MS-SSAS] section The contents of this attribute are defined by the TContents simple type (section


A value that indicates the default aggregate function, if any, that is typically used to summarize properties. The contents of this attribute are defined by the TDefaultAggregateFunction simple type (section


A value that specifies how query results are grouped. The attribute's contents are defined by the TGroupingBehavior simple type (section


An attribute that specifies the stability of a declared property between refresh operations. This attribute is set on columns that contain a row number or other volatile value (such as NOW()). This attribute is emitted only for an unstable value. The contents of this attribute are defined by the TStability simple type (section