ssas.RepoObjectColumn_translation_displayfolder_union - V

type: V ( view ), modify_date: 2021-10-07 15:08:29

RepoObject_guid: 6CD59DE4-7727-EC11-852A-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssas.repoobjectcolumn_translation_displayfolder_union

Columns

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

nvarchar(128)

NOT NULL

nvarchar(10)

NOT NULL

nvarchar(500)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(512)

NULL

nvarchar(512)

NULL

int

NOT NULL

uniqueidentifier

NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NULL

tinyint

NULL

nvarchar(500)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-ssas.repoobjectcolumn_translation_displayfolder_union

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.repoobjectcolumn_translation_displayfolder_union

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.repoobjectcolumn_translation_displayfolder_union

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.repoobjectcolumn_translation_displayfolder_union

Column Reference Diagram

entity_1_1_colref-ssas.repoobjectcolumn_translation_displayfolder_union

Column Details

_

Column_name

Column_name

nvarchar(128)

NOT NULL

cultures_name

cultures_name

nvarchar(10)

NOT NULL

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

displayfolder_translation

displayfolder_translation

nvarchar(512)

NULL

is_displayfolder

is_displayfolder

int

NOT 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

RepoObjectColumn_guid

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

RepoObjectColumn_translation

RepoObjectColumn_translation

nvarchar(128)

NULL

tabcol_IsHidden

tabcol_IsHidden

tinyint

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_displayfolder_union - V script
CREATE   View [ssas].[RepoObjectColumn_translation_displayfolder_union]
As
Select
    T1.RepoObjectColumn_guid
  , T1.cultures_name
  , T1.Column_name
  , T1.cultures_translations_model_name
  , T1.cultures_translations_model_tables_columns_name
  , T1.cultures_translations_model_tables_name
  , T1.databasename
  , T1.displayfolder_DisplayName
  , T1.displayfolder_translation
  , T1.pk_index_guid
  , T1.RepoObject_name
  , T1.RepoObject_schema_name
  , T1.RepoObjectColumn_DisplayName
  , T1.RepoObjectColumn_translation
  , T1.tabcol_IsHidden
  , T1.tables_columns_displayFolder
  , T1.tables_columns_name
  , T1.tables_name
  , is_displayfolder = 0
From
    ssas.RepoObjectColumn_translation_T As T1
Union All
--one pseudo measure per culture, table and displayfolder
Select
    T2.RepoObjectColumn_guid
  , T2.cultures_name
  , T2.Column_name
  , T2.cultures_translations_model_name
  , T2.cultures_translations_model_tables_columns_name
  , T2.cultures_translations_model_tables_name
  , T2.databasename
  , T2.displayfolder_DisplayName
  , T2.displayfolder_translation
  , T2.pk_index_guid
  , T2.RepoObject_name
  , T2.RepoObject_schema_name
  , T2.RepoObjectColumn_DisplayName
  , T2.RepoObjectColumn_translation
  , T2.tabcol_IsHidden
  , T2.tables_columns_displayFolder
  , T2.tables_columns_name
  , T2.tables_name
  , T2.is_displayfolder
From
(
    Select
        T1.RepoObjectColumn_guid
      , T1.cultures_name
      , T1.Column_name
      , T1.cultures_translations_model_name
      , T1.cultures_translations_model_tables_columns_name
      , T1.cultures_translations_model_tables_name
      , T1.databasename
      , T1.displayfolder_DisplayName
      , T1.displayfolder_translation
      , T1.pk_index_guid
      , T1.RepoObject_name
      , T1.RepoObject_schema_name
      , T1.RepoObjectColumn_DisplayName
      , T1.RepoObjectColumn_translation
      , T1.tabcol_IsHidden
      , T1.tables_columns_displayFolder
      , T1.tables_columns_name
      , T1.tables_name
      , is_displayfolder = 1
      , rn               = Row_Number () Over ( Partition By
                                                    T1.cultures_name
                                                  , T1.RepoObject_schema_name
                                                  , T1.RepoObject_name
                                                  , T1.displayfolder_DisplayName
                                                Order By
                                                    --das ist noch nicht richtig, weil nicht jede Spalte in jeder ColumnList enthalten ist
                                                    --am besten wäre es, erst mal die Spalten zu nehmen, die in einem PK enthalten sind
                                                    --dann not hidden
                                                    T1.pk_index_guid Desc
                                                  , T1.tabcol_IsHidden
                                              )
    From
        ssas.RepoObjectColumn_translation_T As T1
) As T2
Where
    T2.rn = 1