3.1.4.2.2.1.3.62.2 Additional Restrictions

  • Article

The following restrictions can apply to this rowset.

Name

Type

Description

QUERY<350>

xsd:string

Given a specific DAX query, if the query contains a measure, the rowset shows each object on which the DAX query has a dependency.

DATABASE_NAME<351>

xsd:string

The name of the database.

OBJECT_TYPE<352>

xsd:string

A string that indicates the type of the object for which dependency analysis is requested.

OBJECT_CATEGORY<353>

xsd:string

A string that specifies the categorization of an object as being about data access versus analysis.

The possible values are the following:

  • DATA_ACCESS – Returns partitions, M objects, and data sources.

  • ANALYSIS – Returns anything considered by a query on a cached model, such as calculated table partitions, tables, columns, hierarchies, relationships, and measures.

Values DATA_ACCESS and ANALYSIS are mutually exclusive.

KIND<354>

xsd:string

A string that specifies the kind of reference that is used to compute the dependency.

The possible values are the following:

  • DATA_DEPENDENCY – Is used for data references and applies to DAX expressions, M expressions, and metadata/structural dependencies, such as hierarchies and relationships.

  • NAMED_DEPENDENCY – Is used for explicitly named references and applies to DAX expressions and M expressions only.

An M expression is always both a named dependency and a data dependency. A DAX expression can be either or both.

Values NAMED_DEPENDENCY and DATA_DEPENDENCY are not mutually exclusive, and many dependencies are both.

Both OBJECT_CATEGORY and KIND restrictions MUST be satisfied. If either restriction is not satisfied, the schema rowset output is not returned. Dependency is allowed by current OBJECT_CATEGORY and KIND restriction settings as described in the following table.

Restriction

OBJECT_CATEGORY

KIND

Dependency

DATA_
ACCESS

ANALYSIS

Not present

DATA

NAMED

Not present

Data and structural (such as hierarchy and relationship) dependency

Yes

Yes

Yes

Yes

Yes

Mashup dependency

Yes

Yes

Yes

Yes

Yes

Partition with provider data source dependency

Yes

Yes

Yes

Yes

Yes

Named dependency

Yes

Yes

Yes