repo.Measure_union - V :: DataHandwerk Docs

Description

Measures should assigned twice to two different tables

original table
virtual table '_measures'
the guid and name of this table are defined in repo.RepoSchema - U

Examples

Entity Diagram

Columns

Table 1. Columns of repo.Measure_union - V
Column Name	Data Type	NULL?
Description	`nvarchar(max)`	`NULL`
Expression	`nvarchar(max)`	`NULL`
is_ssas	`bit`	`NULL`
Measure_fullname	`nvarchar(517)`	`NULL`
Measure_fullname2	`nvarchar(638)`	`NOT NULL`
Measure_guid	`uniqueidentifier`	`NOT NULL`
measures_description	`nvarchar(max)`	`NULL`
measures_description_ja	`nvarchar(max)`	`NULL`
measures_displayFolder	`nvarchar(500)`	`NULL`
measures_expression	`nvarchar(max)`	`NULL`
measures_expression_ja	`nvarchar(max)`	`NULL`
measures_formatString	`nvarchar(500)`	`NULL`
measures_isHidden	`bit`	`NULL`
measures_name	`nvarchar(500)`	`NOT NULL`
RepoObject_fullname2	`nvarchar(257)`	`NOT NULL`
RepoObject_guid	`uniqueidentifier`	`NULL`
RepoObject_name	`nvarchar(128)`	`NULL`
RepoSchema_name	`nvarchar(128)`	`NOT NULL`

Foreign Key Diagram

References

Referenced Objects

repo.Measure - V

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Column Details

_

Description

nvarchar(max)

NULL

Expression

nvarchar(max)

NULL

is_ssas

bit

NULL

Measure_fullname

nvarchar(517)

NULL

Measure_fullname2

nvarchar(638)

NOT NULL

Measure_guid

uniqueidentifier

NOT NULL

Referencing Columns

ssas.Measure_translation.Measure_guid

measures_description

nvarchar(max)

NULL

measures_description_ja

nvarchar(max)

NULL

measures_displayFolder

nvarchar(500)

NULL

Referencing Columns

ssas.Measure_translation.measures_displayFolder

measures_expression

nvarchar(max)

NULL

measures_expression_ja

nvarchar(max)

NULL

measures_formatString

nvarchar(500)

NULL

measures_isHidden

bit

NULL

measures_name

nvarchar(500)

NOT NULL

Referencing Columns

ssas.Measure_translation.measures_name

RepoObject_fullname2

nvarchar(257)

NOT NULL

RepoObject_guid

uniqueidentifier

NULL

Referencing Columns

RepoObject_name

nvarchar(128)

NULL

Referencing Columns

ssas.Measure_translation.RepoObject_name

RepoSchema_name

nvarchar(128)

NOT NULL

Referencing Columns

ssas.Measure_translation.RepoSchema_name

sql_modules_definition

repo.Measure_union - V script

/*
<<property_start>>Description
Measures should assigned twice to two different tables

* original table
* virtual table '_measures' +
  the guid and name of this table are defined in xref:sqldb:repo.reposchema.adoc[]
<<property_end>>
*/
CREATE View repo.Measure_union
As
Select
    Measure_guid
  , RepoSchema_name
  , Description
  , Expression
  , is_ssas
  , measures_name
  , measures_description
  , measures_description_ja
  , measures_displayFolder
  , measures_expression
  , measures_expression_ja
  , measures_formatString
  , measures_isHidden
  , Measure_fullname2
  , Measure_fullname
  , RepoObject_fullname2
  , RepoObject_guid
  , RepoObject_name
From
    repo.Measure
Union All
Select
    Measure_guid
  , RepoSchema_name
  , Description
  , Expression
  , is_ssas
  , measures_name
  , measures_description
  , measures_description_ja
  , measures_displayFolder
  , measures_expression
  , measures_expression_ja
  , measures_formatString
  , measures_isHidden
  , Measure_fullname2
  , Measure_fullname
  , RepoObject_fullname2
  , RepoObject_guid = MeasuresRepoObjekt_guid
  , RepoObject_name = MeasuresRepoObjekt_name
From
    repo.Measure