ssas.model_json_312_tables_measures_T - U

Description

Examples

Entity Diagram

Columns

Table 1. Columns of ssas.model_json_312_tables_measures_T - U
PK	Column Name	Data Type	NULL?
1	Measure_guid Default: DF_model_json_312_tables_measures_T_RepoObjectColumn_guid `(newsequentialid())`	`uniqueidentifier`	`NOT NULL`
	databasename	`nvarchar(128)`	`NOT NULL`
	RepoObject_guid	`uniqueidentifier`	`NOT NULL`
	tables_measures_description	`nvarchar(max)`	`NULL`
	tables_measures_description_ja	`nvarchar(max)`	`NULL`
	tables_measures_displayFolder	`nvarchar(500)`	`NULL`
	tables_measures_expression	`nvarchar(max)`	`NULL`
	tables_measures_expression_ja	`nvarchar(max)`	`NULL`
	tables_measures_formatString	`nvarchar(500)`	`NULL`
	tables_measures_isHidden	`bit`	`NULL`
	tables_measures_name	`nvarchar(500)`	`NOT NULL`
	tables_name	`nvarchar(128)`	`NOT NULL`
	Measure_fullname Definition (PERSISTED) `((quotename([databasename])+'.')+quotename([tables_measures_name]))`	`nvarchar(517)`	`NULL`
	Measure_fullname2 Definition (PERSISTED) `(([databasename]+'.measures.')+[tables_measures_name])`	`nvarchar(638)`	`NOT NULL`
	RepoObject_fullname2 Definition (PERSISTED) `(([databasename]+'.')+[tables_name])`	`nvarchar(257)`	`NOT NULL`

Persistence, History Table

persistence source: ssas.model_json_312_tables_measures - V
is_persistence: 1
is_persistence_check_duplicate_per_pk: 0
is_persistence_check_for_empty_source: 0
is_persistence_delete_changed: 0
is_persistence_delete_missing: 1
is_persistence_insert: 1
is_persistence_truncate: 0
is_persistence_update_changed: 1
has_history: 0
has_history_columns: 0

Foreign Key Diagram

References

Referenced Objects

ssas.model_json_312_tables_measures - V

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

PK_model_json_312_tables_measures_T

IndexSemanticGroup: no_group
- [column-Measure_guid]; uniqueidentifier
PK, Unique, Real: 1, 1, 1

UK_model_json_312_tables_measures_T__1

IndexSemanticGroup: ssas_table_measure
- databasename; nvarchar(128)
- [column-tables_name]; nvarchar(128)
- [column-tables_measures_name]; nvarchar(500)
PK, Unique, Real: 0, 1, 0

idx_model_json_312_tables_measures_T__2

IndexSemanticGroup: no_group
- databasename; nvarchar(128)
- [column-tables_name]; nvarchar(128)
PK, Unique, Real: 0, 0, 0

idx_model_json_312_tables_measures_T__3

IndexSemanticGroup: no_group
- databasename; nvarchar(128)
PK, Unique, Real: 0, 0, 0

Column Details

_

Measure_guid

1

Measure_guid

Default: DF_model_json_312_tables_measures_T_RepoObjectColumn_guid

(newsequentialid())

uniqueidentifier

NOT NULL

Referencing Columns

databasename

nvarchar(128)

NOT NULL

Referenced Columns

ssas.model_json_312_tables_measures.databasename

Referencing Columns

RepoObject_guid

uniqueidentifier

NOT NULL

Referenced Columns

ssas.model_json_312_tables_measures.RepoObject_guid

Referencing Columns

tables_measures_description

nvarchar(max)

NULL

Referenced Columns

ssas.model_json_312_tables_measures.tables_measures_description

Referencing Columns

repo.Measure.measures_description

tables_measures_description_ja

nvarchar(max)

NULL

Referenced Columns

ssas.model_json_312_tables_measures.tables_measures_description_ja

Referencing Columns

repo.Measure.measures_description_ja

tables_measures_displayFolder

nvarchar(500)

NULL

Referenced Columns

ssas.model_json_312_tables_measures.tables_measures_displayFolder

Referencing Columns

repo.Measure.measures_displayFolder

tables_measures_expression

nvarchar(max)

NULL

Referenced Columns

ssas.model_json_312_tables_measures.tables_measures_expression

Referencing Columns

repo.Measure.measures_expression

tables_measures_expression_ja

nvarchar(max)

NULL

Referenced Columns

ssas.model_json_312_tables_measures.tables_measures_expression_ja

Referencing Columns

repo.Measure.measures_expression_ja

tables_measures_formatString

nvarchar(500)

NULL

Referenced Columns

ssas.model_json_312_tables_measures.tables_measures_formatString

Referencing Columns

repo.Measure.measures_formatString

tables_measures_isHidden

bit

NULL

Referenced Columns

ssas.model_json_312_tables_measures.tables_measures_isHidden

Referencing Columns

repo.Measure.measures_isHidden

tables_measures_name

nvarchar(500)

NOT NULL

Referenced Columns

ssas.model_json_312_tables_measures.tables_measures_name

Referencing Columns

tables_name

nvarchar(128)

NOT NULL

Referenced Columns

ssas.model_json_312_tables_measures.tables_name

Referencing Columns

Measure_fullname

Definition (PERSISTED)

((quotename([databasename])+'.')+quotename([tables_measures_name]))

nvarchar(517)

NULL

Description

quotename([databasename])+'.')+quotename([tables_measures_name]

Referenced Columns

ssas.model_json_312_tables_measures_T.tables_measures_name
ssas.model_json_312_tables_measures_T.databasename

Referencing Columns

repo.Measure.Measure_fullname

Measure_fullname2

Definition (PERSISTED)

(([databasename]+'.measures.')+[tables_measures_name])

nvarchar(638)

NOT NULL

Description

(('.measures.')[tables_measures_name])

Referenced Columns

ssas.model_json_312_tables_measures_T.tables_measures_name
ssas.model_json_312_tables_measures_T.databasename

Referencing Columns

repo.Measure.Measure_fullname2

RepoObject_fullname2

Definition (PERSISTED)

(([databasename]+'.')+[tables_name])

nvarchar(257)

NOT NULL

Description

(('.')[tables_name])

Referenced Columns

ssas.model_json_312_tables_measures_T.databasename
ssas.model_json_312_tables_measures_T.tables_name

Referencing Columns

repo.Measure.RepoObject_fullname2