2.2.5.25 ExtendedProperty Object

  • Article

The ExtendedProperty object<74> is a child object of a logical metadata object in the Tabular model. ExtendedProperty objects represent one or more application-specific name/value pairs for the parent object. The Analysis Services server does not interpret the ExtendedProperty objects. An ExtendedProperty object requires compatibility level 1400 or higher.

The ExtendedProperty object has the following properties. Possible logical metadata objects for which ExtendedProperty is a child object are listed for the ObjectType property.

Name

Type

Description

ID

unsignedLong

A reference to the object.

ObjectID

unsignedLong

An ID-based reference to the object.

ObjectType

int

The data type of the object that is specified by ObjectID. The possible values are as follows:

  • TM_TYPEID_Model (1)

  • TM_TYPEID_DataSource (2)

  • TM_TYPEID_Table (3)

  • TM_TYPEID_Column (4)

  • TM_TYPEID_AttributeHierarchy (5)

  • TM_TYPEID_Partition (6)

  • TM_TYPEID_Relationship (7)

  • TM_TYPEID_Measure (8)

  • TM_TYPEID_Hierarchy (9)

  • TM_TYPEID_Level (10)

  • TM_TYPEID_KPI (12)

  • TM_TYPEID_Culture (13)

  • TM_TYPEID_LinguisticMetadata (15)

  • TM_TYPEID_Perspective (29)

  • TM_TYPEID_PerspectiveTable (30)

  • TM_TYPEID_PerspectiveColumn (31)

  • TM_TYPEID_PerspectiveHierarchy (32)

  • TM_TYPEID_PerspectiveMeasure (33)

  • TM_TYPEID_Role (34)

  • TM_TYPEID_RoleMembership (35)

  • TM_TYPEID_TablePermission (36)

  • TM_TYPEID_Variation (37)

  • TM_TYPEID_Expression (41)

  • TM_TYPEID_ColumnPermission (42)

Name

string

The name of the object.

Type

enumeration

A value that provides information about the format of the value. The possible values are as follows:

  • String (0) – The value is a raw string without specific formatting.

  • Json (1) – The value is a JSON object.

Value

string

The value of ExtendedProperty.

ModifiedTime

dateTime

The time that the object was last modified.