ssas.RepoObjectColumn_translation - V

type: V ( view ), modify_date: 2022-01-05 18:06:34

RepoObject_guid: 0E42B32F-5E24-EC11-8526-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssas.repoobjectcolumn_translation

Columns

Table 1. Columns of ssas.RepoObjectColumn_translation - V
PK Column Name Data Type NULL? ID

1

uniqueidentifier

NOT NULL

2

nvarchar(10)

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(500)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(512)

NULL

nvarchar(512)

NULL

uniqueidentifier

NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

bit

NOT NULL

nvarchar(500)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-ssas.repoobjectcolumn_translation

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.repoobjectcolumn_translation

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.repoobjectcolumn_translation

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.repoobjectcolumn_translation

Column Reference Diagram

entity_1_1_colref-ssas.repoobjectcolumn_translation

Indexes

PK_RepoObjectColumn_translation

idx_RepoObjectColumn_translation__2

idx_RepoObjectColumn_translation__3

idx_RepoObjectColumn_translation__4

idx_RepoObjectColumn_translation__5

idx_RepoObjectColumn_translation__6

idx_RepoObjectColumn_translation__7

idx_RepoObjectColumn_translation__8

Column Details

_

RepoObjectColumn_guid

1

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

cultures_name

2

cultures_name

nvarchar(10)

NOT NULL

Referenced Columns

Column_name

Column_name

nvarchar(128)

NOT NULL

Description

(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

nvarchar(500)

NULL

cultures_translations_model_tables_columns_name

cultures_translations_model_tables_columns_name

nvarchar(128)

NULL

cultures_translations_model_tables_name

cultures_translations_model_tables_name

nvarchar(128)

NULL

databasename

databasename

nvarchar(128)

NULL

displayfolder_DisplayName

displayfolder_DisplayName

nvarchar(512)

NULL

pk_index_guid

pk_index_guid

uniqueidentifier

NULL

RepoObject_name

RepoObject_name

nvarchar(128)

NOT NULL

RepoObject_schema_name

RepoObject_schema_name

nvarchar(128)

NOT NULL

RepoObjectColumn_DisplayName

RepoObjectColumn_DisplayName

nvarchar(128)

NULL

tabcol_IsHidden

tabcol_IsHidden

bit

NOT NULL

tables_columns_displayFolder

tables_columns_displayFolder

nvarchar(500)

NULL

tables_columns_name

tables_columns_name

nvarchar(128)

NULL

tables_name

tables_name

nvarchar(128)

NULL

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