ssas.Measure_translation - V

type: V ( view ), modify_date: 2021-11-28 11:01:08

RepoObject_guid: 1C8B3C65-6124-EC11-8526-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssas.measure_translation

Columns

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

1

uniqueidentifier

NOT NULL

2

nvarchar(10)

NOT NULL

3

nvarchar(128)

NULL

nvarchar(512)

NULL

nvarchar(512)

NULL

nvarchar(500)

NULL

nvarchar(128)

NULL

nvarchar(500)

NULL

nvarchar(500)

NOT NULL

nvarchar(128)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-ssas.measure_translation

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.measure_translation

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.measure_translation

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.measure_translation

Column Reference Diagram

entity_1_1_colref-ssas.measure_translation

Indexes

PK_Measure_translation

UK_Measure_translation__1

Column Details

_

Measure_guid

1

Measure_guid

uniqueidentifier

NOT NULL

Referenced Columns

cultures_name

2

cultures_name

nvarchar(10)

NOT NULL

Referenced Columns

RepoObject_name

3

RepoObject_name

nvarchar(128)

NULL

displayfolder_DisplayName

displayfolder_DisplayName

nvarchar(512)

NULL

Measure_DisplayName

Measure_DisplayName

nvarchar(500)

NULL

measures_displayFolder

measures_displayFolder

nvarchar(500)

NULL

measures_name

measures_name

nvarchar(500)

NOT NULL

RepoSchema_name

RepoSchema_name

nvarchar(128)

NOT NULL

sql_modules_definition

ssas.Measure_translation - V script
/****** Script for SelectTopNRows command from SSMS  ******/
CREATE View ssas.Measure_translation
As
Select
    m.Measure_guid
  , c.cultures_name
  , m.RepoSchema_name
  , m.RepoObject_name
  , m.measures_name
  , Measure_translation       = cult.cultures_translations_model_tables_measures_translatedCaption
  , Measure_DisplayName       = Coalesce (
                                             cult.cultures_translations_model_tables_measures_translatedCaption
                                           , m.measures_name
                                         )
  , m.measures_displayFolder
  , displayfolder_translation = cult.cultures_translations_model_tables_measures_translatedDisplayFolder
  , displayfolder_DisplayName = Coalesce (
                                             cult.cultures_translations_model_tables_measures_translatedDisplayFolder
                                           , m.measures_displayFolder
                                         )
From
    repo.Measure_union     As m
    Cross Join docs.Culture As c
    Left Outer Join
        ssas.model_json_341113_cultures_translations_model_tables_measures As cult
            On
            cult.databasename                                         = m.RepoSchema_name
            And
            (
                cult.cultures_translations_model_tables_name          = m.RepoObject_name
                Or m.RepoObject_name                                  = '_measures'
            )
            And cult.cultures_translations_model_tables_measures_name = m.measures_name
            And cult.cultures_name                                    = c.cultures_name