docs.Schema_SsasRelationList - V
type: V ( view ), modify_date: 2022-09-08 16:36:51
RepoObject_guid: 0C60D8EE-E90A-EC11-8516-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
Indexes
PK_Schema_SsasRelationList
-
IndexSemanticGroup: no_group
-
[column-SchemaName]; nvarchar(128)
-
[column-cultures_name]; nvarchar(10)
-
-
PK, Unique, Real: 1, 1, 0
idx_Schema_SsasRelationList__1
-
IndexSemanticGroup: no_group
-
[column-SchemaName]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
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