2.2.5.1 Model Object

The Model object represents the Tabular data model. It is a child of the Database object as defined in [MS-SSAS]. All other Tabular metadata objects are descendants of the Model object.

The Model object has the following properties.

Name

Type

Description

ID

unsignedLong

A reference to the object.

Name

string

The name of the object.

Description

string

The description of the object.

StorageLocation<3>

string

The location on disk to place the model.

DefaultMode

long

The default method for making data available in the partition.

DefaultDataView

enumeration

Determines which partitions are to be selected to run queries against the model. The possible values are as follows:

  • Full (0) – Partitions with DataView set to "Default" or "Full" are selected.

  • Sample (1) – Partitions with DataView set to "Default" or "Sample" are selected.

  • Default (3) – Not applicable to Model.

Culture

string

The culture name to use for formatting.<4>

Collation

string

The collation sequence.

ModifiedTime

dateTime

The time that the object was last modified.

StructureModifiedTime

dateTime

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

Version

long

The current version of the Model object. The version number is incremented when any transaction on the Model is committed. This version number is set to 1 for any newly created Tabular databases and is always set to 1 for all Tabular databases when the server is restarted.

DataAccessOptions<5>

string

A JSON property bag that contains the following three Boolean properties:

  • fastCombine – A Boolean that indicates the ability to override privacy levels to share data across data sources and queries.

    • If set to "true", data from data sources is allowed to be sent in queries to other data sources, regardless of the other data sources' privacy levels.

    • If set to "false", possible data sharing is controlled by the data source's privacy levels.

  • legacyRedirects – A Boolean that indicates whether unsafe redirects to a different site and from HTTPS to HTTP are enabled.

    • If set to "true", unsafe redirects are enabled; otherwise, it is "false".

  • returnErrorValuesAsNull – A Boolean that indicates whether individual cell errors are returned as null values or the query fails.

    • If set to "true", individual cell errors are returned as null values.

    • If set to "false", the query fails.

The default value for these Boolean properties is "false".

Compatibility level 1400 or higher is required.

DefaultMeasureID<6>

unsignedLong

An ID-based reference to the default measure of the Model object.

Compatibility level 1400 or higher is required.

ForceUniqueNames<7>

boolean

A Boolean that determines whether a measure can have the same name as any column in the model.

  • If set to "true", a measure cannot have the same name as any column in the model.

  • If set to "false", this restriction is not enforced.

Compatibility level 1500 or higher is required.

DiscourageImplicitMeasures<8>

boolean

A Boolean that determines whether to discourage the implicit measures.

  • If set to "true", implicit measures are discouraged.

  • If set to "false", implicit measures are not discouraged.

Compatibility level 1500 or higher is required.

DataSourceDefaultMaxConnections<9>

int

The default value for the MaxConnections property of the DataSource object when the object does not specify that value explicitly.

Compatibility level 1600 or higher is required.

SourceQueryCulture<10>

string

The name of the culture to be used when formatting during refresh through M.

Compatibility level 1600 or higher is required.

MAttributes<11>

string

A set of optional properties that can be used to define the literal attributes on the section members of the M queries.

Compatibility level 1600 or higher is required.

DiscourageCompositeModels<12>

boolean

A Boolean that indicates whether composite models usage is discouraged.

Compatibility level 1600 or higher is required.

AutomaticAggregationOptions<13>

string

A set of options for the automatic-aggregation subsystem.

Compatibility level 1600 or higher is required.

MaxParallelismPerRefresh<14>

int

The default value for number of concurrent jobs in data refresh. The command SEQUENCE can override the property using the MaxParallelism field.

Compatibility level 1600 or higher is required.

MaxParallelismPerQuery<15>

int

The maximum degree of parallelism for a query when connecting to data sources using DirectQuery.

Compatibility level 1600 or higher is required.