ssas.RepoObjectColumn_translation - V
type: V ( view ), modify_date: 2022-01-05 18:06:34
RepoObject_guid: 0E42B32F-5E24-EC11-8526-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_RepoObjectColumn_translation
-
IndexSemanticGroup: no_group
-
[column-RepoObjectColumn_guid]; uniqueidentifier
-
[column-cultures_name]; nvarchar(10)
-
-
PK, Unique, Real: 1, 1, 0
idx_RepoObjectColumn_translation__2
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-tables_name]; nvarchar(128)
-
[column-tables_columns_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_translation__3
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-tables_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_translation__4
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_translation__5
-
IndexSemanticGroup: no_group
-
[column-cultures_translations_model_name]; nvarchar(500)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_translation__6
-
IndexSemanticGroup: no_group
-
[column-RepoObject_schema_name]; nvarchar(128)
-
[column-RepoObject_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_translation__7
-
IndexSemanticGroup: no_group
-
[column-pk_index_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_RepoObjectColumn_translation__8
-
IndexSemanticGroup: no_group
-
[column-RepoObjectColumn_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
RepoObjectColumn_guid
1 |
RepoObjectColumn_guid |
|
|
Column_name
Column_name |
|
|
(case when TRY_CAST([RepoObjectColumn_name] AS [uniqueidentifier]) IS NULL then [RepoObjectColumn_name] else [SysObjectColumn_name] end)
cultures_translations_model_name
cultures_translations_model_name |
|
|
cultures_translations_model_tables_columns_name
cultures_translations_model_tables_columns_name |
|
|
cultures_translations_model_tables_name
cultures_translations_model_tables_name |
|
|
displayfolder_translation
displayfolder_translation |
|
|
RepoObject_schema_name
RepoObject_schema_name |
|
|
RepoObjectColumn_translation
RepoObjectColumn_translation |
|
|
tables_columns_displayFolder
tables_columns_displayFolder |
|
|
sql_modules_definition
ssas.RepoObjectColumn_translation - V script
CREATE View ssas.RepoObjectColumn_translation
As
Select
roc.RepoObjectColumn_guid
, c.cultures_name
, roc.Column_name
, roc.RepoObject_schema_name
, roc.RepoObject_name
, RepoObjectColumn_translation = cult.cultures_translations_model_tables_columns_translatedCaption
, RepoObjectColumn_DisplayName = Coalesce (
cult.cultures_translations_model_tables_columns_translatedCaption
, roc.Column_name
)
, tabcol.databasename
, tabcol.tables_name
, tabcol.tables_columns_name
, cult.cultures_translations_model_name
, cult.cultures_translations_model_tables_name
, cult.cultures_translations_model_tables_columns_name
, tabcol.tables_columns_displayFolder
, displayfolder_translation = cult.cultures_translations_model_tables_columns_translatedDisplayFolder
, displayfolder_DisplayName = Coalesce (
cult.cultures_translations_model_tables_columns_translatedDisplayFolder
, tabcol.tables_columns_displayFolder
)
, roc.pk_index_guid
, roc.tabcol_IsHidden
From
repo.RepoObjectColumn_gross As roc
Cross Join docs.Culture As c
Left Outer Join
ssas.model_json_311_tables_columns_T As tabcol
On
tabcol.RepoObjectColumn_guid = roc.RepoObjectColumn_guid
Left Outer Join
ssas.model_json_341111_cultures_translations_model_tables_columns As cult
On
cult.databasename = tabcol.databasename
And cult.cultures_name = c.cultures_name
And cult.cultures_translations_model_tables_name = tabcol.tables_name
And cult.cultures_translations_model_tables_columns_name = roc.Column_name