ssas.Measure_translation_displayfolder_union

Description

Examples

Entity Diagram

Columns

Table 1. Columns of ssas.Measure_translation_displayfolder_union - V
Column Name	Data Type	NULL?
cultures_name	`nvarchar(10)`	`NOT NULL`
displayfolder_DisplayName	`nvarchar(512)`	`NULL`
displayfolder_translation	`nvarchar(512)`	`NULL`
is_displayfolder	`int`	`NOT NULL`
Measure_DisplayName	`nvarchar(500)`	`NULL`
Measure_guid	`uniqueidentifier`	`NOT NULL`
Measure_translation	`nvarchar(128)`	`NULL`
measures_displayFolder	`nvarchar(500)`	`NULL`
measures_name	`nvarchar(500)`	`NOT NULL`
RepoObject_name	`nvarchar(128)`	`NOT NULL`
RepoSchema_name	`nvarchar(128)`	`NOT NULL`

Foreign Key Diagram

References

Referenced Objects

ssas.Measure_translation_T - U

Referencing Objects

docs.RepoObject_MeasureList - V

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Column Details

_

cultures_name

nvarchar(10)

NOT NULL

displayfolder_DisplayName

nvarchar(512)

NULL

displayfolder_translation

nvarchar(512)

NULL

is_displayfolder

int

NOT NULL

Measure_DisplayName

nvarchar(500)

NULL

Measure_guid

uniqueidentifier

NOT NULL

Measure_translation

nvarchar(128)

NULL

measures_displayFolder

nvarchar(500)

NULL

measures_name

nvarchar(500)

NOT NULL

RepoObject_name

nvarchar(128)

NOT NULL

RepoSchema_name

nvarchar(128)

NOT NULL

sql_modules_definition

ssas.Measure_translation_displayfolder_union - V script

CREATE View ssas.Measure_translation_displayfolder_union
As
--real measures
Select
    T1.Measure_guid
  , T1.cultures_name
  , T1.RepoObject_name
  , T1.RepoSchema_name
  , T1.measures_name
  , T1.Measure_translation
  , T1.Measure_DisplayName
  , T1.measures_displayFolder
  , T1.displayfolder_translation
  , T1.displayfolder_DisplayName
  , is_displayfolder = 0
From
    ssas.Measure_translation_T T1
Union All
--one pseudo measure per culture, table and displayfolder
Select
    T2.Measure_guid
  , T2.cultures_name
  , T2.RepoObject_name
  , T2.RepoSchema_name
  , T2.measures_name
  , T2.Measure_translation
  , T2.Measure_DisplayName
  , T2.measures_displayFolder
  , T2.displayfolder_translation
  , T2.displayfolder_DisplayName
  , T2.is_displayfolder
From
(
    Select
        T1.Measure_guid
      , T1.cultures_name
      , T1.RepoObject_name
      , T1.RepoSchema_name
      , T1.measures_name
      , T1.Measure_translation
      , T1.Measure_DisplayName
      , T1.measures_displayFolder
      , T1.displayfolder_translation
      , T1.displayfolder_DisplayName
      , is_displayfolder = 1
      , rn               = Row_Number () Over ( Partition By
                                                    T1.cultures_name
                                                  , T1.RepoSchema_name
                                                  , T1.RepoObject_name
                                                  , T1.displayfolder_DisplayName
                                                Order By
                                                    T1.Measure_DisplayName
                                              )
    From
        ssas.Measure_translation_T T1
) As T2
Where
    T2.rn = 1