docs.ssas_PumlRelation - V
type: V ( view ), modify_date: 2021-09-01 15:19:42
RepoObject_guid: 6C6E8DEE-3D08-EC11-8515-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_ssas_PumlRelation__1
-
IndexSemanticGroup: no_group
-
[column-referencing_ObjectName]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_ssas_PumlRelation__2
-
IndexSemanticGroup: no_group
-
[column-referenced_ObjectName]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_ssas_PumlRelation__3
-
IndexSemanticGroup: no_group
-
[column-referenced_IndexPatternColumnName]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_ssas_PumlRelation__4
-
IndexSemanticGroup: no_group
-
[column-referencing_IndexPatternColumnName]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_ssas_PumlRelation__5
-
IndexSemanticGroup: no_group
-
[column-referenced_ColumnName]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_ssas_PumlRelation__6
-
IndexSemanticGroup: no_group
-
[column-referencing_ColumnName]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_ssas_PumlRelation__7
-
IndexSemanticGroup: no_group
-
[column-ForeignKey_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_ssas_PumlRelation__8
-
IndexSemanticGroup: no_group
-
[column-SchemaName]; nvarchar(128)
-
[column-relationships_name]; nvarchar(500)
-
-
PK, Unique, Real: 0, 0, 0
idx_ssas_PumlRelation__9
-
IndexSemanticGroup: no_group
-
[column-SchemaName]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
referenced_IndexPatternColumnDatatype
referenced_IndexPatternColumnDatatype |
|
|
referenced_IndexPatternColumnGuid
referenced_IndexPatternColumnGuid |
|
|
referenced_IndexPatternColumnName
referenced_IndexPatternColumnName |
|
|
referenced_RepoObject_fullname2
referenced_RepoObject_fullname2 |
|
|
referencing_IndexPatternColumnDatatype
referencing_IndexPatternColumnDatatype |
|
|
referencing_IndexPatternColumnGuid
referencing_IndexPatternColumnGuid |
|
|
referencing_IndexPatternColumnName
referencing_IndexPatternColumnName |
|
|
referencing_RepoObject_fullname
referencing_RepoObject_fullname |
|
|
referencing_RepoObject_fullname2
referencing_RepoObject_fullname2 |
|
|
relationships_crossFilteringBehavior
relationships_crossFilteringBehavior |
|
|
sql_modules_definition
docs.ssas_PumlRelation - V script
/*to: noch nicht fertig, unnötige entfernen*/
CREATE View docs.ssas_PumlRelation
As
Select
ForeignKey_guid
, ForeignKey_name
, SchemaName = databasename
, PumlRelation = Concat (
Cast(N'' As NVarchar(Max))
--ssas names can contain space and other
, docs.fs_cleanStringForPuml ( referenced_RepoObject_fullname2 )
, '::'
, docs.fs_cleanStringForPuml ( referenced_ColumnName )
, ' '
--todo: check with test data, containing 1:1 and 1:n relations
--, Iif(relationships_toCardinality = 'one', '|', '}')
, Iif(IsNull ( relationships_toCardinality, 'one' ) = 'one', '|', '}')
, Iif(referenced_IsNullable = 1, 'o', '|')
, Case
When relationships_isActive = 1
Then
Iif(relationships_crossFilteringBehavior = 'bothDirections'
, '-[bold]-'
, '-[plain]-')
Else
Iif(relationships_crossFilteringBehavior = 'bothDirections'
, '-[dashed]-'
, '-[dotted]-')
End
, Iif(referencing_IsNullable = 1, 'o', '|')
--'one' is the exception
, Iif(relationships_fromCardinality = 'one', '|', '{')
, ' '
, docs.fs_cleanStringForPuml ( referencing_RepoObject_fullname2 )
, '::'
, docs.fs_cleanStringForPuml ( referencing_ColumnName )
)
, ForeignKey_fullname
, referenced_IndexPatternColumnName
, referenced_IndexPatternColumnGuid
, referenced_RepoObject_guid
, referencing_IndexPatternColumnName
, referencing_IndexPatternColumnGuid
, referencing_RepoObject_guid
, delete_referential_action
, update_referential_action
, relationships_name
, relationships_isActive
, relationships_crossFilteringBehavior
--, JoinOnDateBehavior
--, RelyOnReferentialIntegrity
, relationships_fromCardinality
, relationships_toCardinality
--, SecurityFilteringBehavior
, referenced_ObjectName
, referenced_ColumnName
, referenced_IndexPatternColumnDatatype
, referenced_RepoObject_fullname
, referenced_RepoObject_fullname2
, referencing_ObjectName
, referencing_ColumnName
, referencing_IndexPatternColumnDatatype
, referencing_RepoObject_fullname
, referencing_RepoObject_fullname2
From
repo.ForeignKey_ssas_IndexPattern