Share via

3.1.4.2.2.1.3.62.1 Columns

  • Article

The DISCOVER_CALC_DEPENDENCY rowset contains the following columns.

Name

Type

Restriction

Description

DATABASE_NAME

xsd:string

Yes

The name of the database.

OBJECT_TYPE

xsd:string

Yes

Indicates the type of the object for which dependency analysis is requested.

For objects that are in Tabular models at compatibility level 1100 or 1103, the following are the possible types:

  • QUERY: A query.

  • COLUMN: A regular column.

  • CALC_COLUMN: A calculated column.

  • HIERARCHY: A hierarchy.

  • MEASURE: A measure.

  • ACTIVE_RELATIONSHIP: An active relationship.

  • RELATIONSHIP: A relationship.

  • ROWS_ALLOWED: The number of rows allowed.

For objects that are in Tabular models at compatibility level 1200 or higher, the following are the possible types:

  • CALC_COLUMN: A calculated column.

  • MEASURE: A measure.

  • RELATIONSHIP: A relationship.

  • ACTIVE_RELATIONSHIP: An active relationship.

  • CALC_TABLE: A calculated table.

  • HIERARCHY: A hierarchy.

  • ATTRIBUTE_HIERARCHY: An attribute hierarchy.

  • ROWS_ALLOWED: The number of rows allowed.

  • DETAIL_ROWS_EXPR: A detail rows definition.

  • PARTITION: A partition.

  • M_EXPRESSION: An M expression, as defined in [MS-SSAS-T].
    Requires compatibility level 1400 or higher.

  • QUERY: A query.

TABLE

xsd:string

The name of the table that contains the object for which dependency information is sought.

OBJECT

xsd:string

The name of the object for which dependency information is sought.

EXPRESSION

xsd:string

The formula of the object for which dependency information is sought.

REFERENCED_OBJECT_TYPE

xsd:string

Returns the type of the object that has a dependency on the referenced object.

For objects that are returned by Tabular models at compatibility level 1100 or 1103, the following are the possible types:

  • CALC_COLUMN: A calculated column.

  • COLUMN: A column of data.

  • MEASURE: A measure.

  • RELATIONSHIP: A relationship.

  • HIERARCHY: A hierarchy.

For objects that are returned by Tabular models at compatibility level 1200 or higher, the following are the possible types:

  • COLUMN: A column of data.

  • CALC_COLUMN: A calculated column.

  • MEASURE: A measure.

  • RELATIONSHIP: A relationship.

  • ACTIVE_RELATIONSHIP: An active relationship.

  • TABLE: A table.

  • CALC_TABLE: A calculated table.

  • ATTRIBUTE_HIERARCHY: An attribute hierarchy.

  • DETAIL_ROWS_EXPR: A detail rows definition.

  • DATASOURCE: A data source.

  • M_EXPRESSION: An M expression, as defined in [MS-SSAS-T].
    Requires compatibility level 1400 or higher.

  • HIERARCHY: A hierarchy.

  • CALCULATION_ITEM: A calculation item.

  • CALCULATION_ITEM_FORMAT_STRING: A calculation item format string.

REFERENCED_TABLE

xsd:string

The name of the table that contains the dependent object.

REFERENCED_OBJECT

xsd:string

The name of the object that has a dependency on the referenced object.

REFERENCED_EXPRESSION

xsd:string

A formula that is dependent on the referenced object. In a calculated table, a calculated column, or a measure, the formula can be a DAX expression. In a partition, the formula can be a provider data source expression or an M language expression.

The response has the following definition.

 <xsd:element name="root">
               <xsd:complexType>
                 <xsd:sequence minOccurs="0" maxOccurs="unbounded">
                   <xsd:element name="row" type="row" />
                 </xsd:sequence>
               </xsd:complexType>
             </xsd:element>
             <xsd:simpleType name="uuid">
               <xsd:restriction base="xsd:string">
                 <xsd:pattern value="[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}" />
               </xsd:restriction>
             </xsd:simpleType>
             <xsd:complexType name="xmlDocument">
               <xsd:sequence>
                 <xsd:any />
               </xsd:sequence>
             </xsd:complexType>
             <xsd:complexType name="row">
               <xsd:sequence>
                 <xsd:element sql:field="DATABASE_NAME" name="DATABASE_NAME" type="xsd:string" 
                              minOccurs="0" />
                 <xsd:element sql:field="OBJECT_TYPE" name="OBJECT_TYPE" type="xsd:string" 
                              minOccurs="0" />
                 <xsd:element sql:field="TABLE" name="TABLE" type="xsd:string" 
                              minOccurs="0" />
                 <xsd:element sql:field="OBJECT" name="OBJECT" type="xsd:string" 
                              minOccurs="0" />
                 <xsd:element sql:field="EXPRESSION" name="EXPRESSION" type="xsd:string" 
                              minOccurs="0" />
                 <xsd:element sql:field="REFERENCED_OBJECT_TYPE" name="REFERENCED_OBJECT_TYPE" 
                              type="xsd:string" minOccurs="0" />
                 <xsd:element sql:field="REFERENCED_TABLE" name="REFERENCED_TABLE" 
                              type="xsd:string" minOccurs="0" />
                 <xsd:element sql:field="REFERENCED_OBJECT" name="REFERENCED_OBJECT" 
                              type="xsd:string" minOccurs="0" />
                 <xsd:element sql:field="REFERENCED_EXPRESSION" name="REFERENCED_EXPRESSION" 
                              type="xsd:string" minOccurs="0" />
               </xsd:sequence>
             </xsd:complexType>