docs.Schema_SsasRelationList - V

type: V ( view ), modify_date: 2022-09-08 16:36:51

RepoObject_guid: 0C60D8EE-E90A-EC11-8516-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.schema_ssasrelationlist

Columns

Table 1. Columns of docs.Schema_SsasRelationList - V
PK Column Name Data Type NULL? ID

1

nvarchar(128)

NOT NULL

2

nvarchar(10)

NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.schema_ssasrelationlist

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.schema_ssasrelationlist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.schema_ssasrelationlist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.schema_ssasrelationlist

Column Reference Diagram

entity_1_1_colref-docs.schema_ssasrelationlist

Indexes

PK_Schema_SsasRelationList

idx_Schema_SsasRelationList__1

Column Details

_

SchemaName

1

SchemaName

nvarchar(128)

NOT NULL

cultures_name

2

cultures_name

nvarchar(10)

NULL

SsasRelationList_PumlRelation

SsasRelationList_PumlRelation

nvarchar(max)

NULL

sql_modules_definition

docs.Schema_SsasRelationList - V script
CREATE View docs.Schema_SsasRelationList
As
Select
    rel.SchemaName
  , schema_2_culture.cultures_name
  , SsasRelationList_PumlRelation = String_Agg ( Cast(rel.PumlRelation As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                                                      rel.referenced_RepoObject_fullname2
                                                                                                                                    , rel.referencing_RepoObject_fullname2)
From
    docs.ssas_PumlRelation As rel
    Left Join
    (
        Select
            Distinct
            RepoObject_schema_name
          , cultures_name
        From
            docs.RepoObject_OutputFilter_T
        Where
            is_ssas = 1
    )                      As schema_2_culture
        On
        schema_2_culture.RepoObject_schema_name = rel.SchemaName
Group By
    rel.SchemaName
  , schema_2_culture.cultures_name