2.2.5.3 Table Object

The Table object represents a table in the data model. It is a child of a Model object. The Table object is defined to have a set of columns, and the rows in the tables are based on Partition child objects.

The Table object has the following properties.

Name

Type

Description

ID

unsignedLong

A reference to the object.

ModelID

unsignedLong

An ID-based reference to a Model object.

Name

string

The name of the object.

DataCategory

string

A string that specifies the category of the data. The values automatically map to the DIMENSION_TYPE column as defined in [MS-SSAS] section 3.1.4.2.2.1.3.6.1.

The possible values are as follows:

  • Unknown (0) – All unknown strings are returned in the Contents attribute of the EntityType element of Conceptual Schema Definition Language with Business Intelligence annotations (CSDLBI). For more information, see [MS-CSDLBI]. (Maps to UNKNOWN)

  • Regular (1) – standard dimension (Maps to OTHER)

  • Time (2) – time dimension (Maps to TIME)

  • Geography (3) – geography dimension (Maps to GEOGRAPHY)

  • Organization (4) – organization dimension (Maps to ORGANIZATION)

  • BillOfMaterials (5) – bill of materials dimension (Maps to BILL OF MATERIALS)

  • Accounts (6) – accounts dimension (Maps to ACCOUNTS)

  • Customers (7) – customers dimension (Maps to CUSTOMERS)

  • Products (8) – products dimension (Maps to PRODUCTS)

  • Scenario (9) – scenario dimension (Maps to SCENARIO)

  • Quantitative (10) – quantitative dimension (Maps to QUANTITATIVE)

  • Utility (11) – utility dimension (Maps to UTILITY)

  • Currency (12) – currency dimension (Maps to CURRENCY)

  • Rates (13) – rates dimension (Maps to RATES)

  • Channel (14) – channel dimension (Maps to CHANNEL)

  • Promotion (15) – promotion dimension (Maps to PROMOTION)

Description

string

The description of the object.

IsHidden

boolean

A Boolean that indicates whether the table is treated as hidden by client visualization tools.

If the table is treated as hidden by client visualization tools, it is "true"; otherwise, it is "false".

TableStorageID

unsignedLong

An ID-based reference to a TableStorage object. The TableStorage object is reserved for internal use only.

ModifiedTime

dateTime

The time that the object was last modified.

StructureModifiedTime

dateTime

The time that the structure of the object was last modified.

SystemFlags

long

A bitmask that is used to identify the type of object.

The possible values are as follows:

  • Bit 0 is set to 1: The object is a system table that is defined and built internally by the system.

  • Bit 1 is set to 1: The object is a user-created calculated table.

ShowAsVariationsOnly<24>

boolean

A Boolean that dictates whether the table is shown only when referenced as Variation.

If it is "true", the table is shown only when it is referenced as a variation; otherwise, it is "false".

Compatibility level 1400 or higher is required.

IsPrivate<25>

boolean

A Boolean that dictates whether the table is to be hidden for all clients.

If it is "true", the table is hidden for all clients; otherwise, it is "false".

Compatibility level 1400 or higher is required.

DefaultDetailRowsDefinitionID<26>

unsignedLong

An ID-based reference to a DetailRowsDefinition object. This property defines the default Data Analysis Expressions (DAX) expression to apply when drilling through to the detail rows for measures in this table.

Compatibility level 1400 or higher is required.

CalculationGroupID<27>

unsignedLong

An ID-based reference to a CalculationGroup object. A calculation group reduces the number of redundant measures by grouping common measure expressions as calculation items.

Compatibility level 1500 or higher is required.

RefreshPolicyID<28>

unsignedLong

An ID-based reference to a RefreshPolicy object. A refresh policy allows partitions to be refreshed and maintained by the server automatically.

Compatibility level 1500 or higher is required.

ExcludeFromModelRefresh<29>

boolean

A Boolean that indicates whether the table is excluded when the model is refreshed.

When the value is "true", a refresh operation on the model does not trigger a refresh on any partitions of the table that were already processed.

Compatibility level 1500 or higher is required.

AlternateSourcePrecedence<30>

int

The ranking or precedence that is used to select the aggregation table in case more than one match is found. The table with higher precedence is preferred over the table with lower precedence if more than one aggregation table matches for a query.

Compatibility level 1500 or higher is required.

LineageTag<31>

string

An optional tag that can be used to define the lineage of a table across different versions of a model.

Compatibility level 1600 or higher is required.

SourceLineageTag<32>

string

An optional tag that can be used to define the lineage of a referenced table across different versions of a model. As opposed to LineageTag, SourceLineageTag can be used to define the lineage of a referenced table rather than a table itself. SourceLineageTag is useful when a model references other models by using a Direct Query connection.

Compatibility level 1600 or higher is required.

SystemManaged<33>

boolean

A Boolean that indicates whether the table is managed by the system.

Compatibility level 1600 or higher is required.

ExcludeFromAutomaticAggregations<34>

boolean

A Boolean that indicates whether the table is to be considered for training in automatic aggregations.

Compatibility level 1600 or higher is required.