docs.ssas_PumlRelation - V

type: V ( view ), modify_date: 2021-09-01 15:19:42

RepoObject_guid: 6C6E8DEE-3D08-EC11-8515-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.ssas_pumlrelation

Columns

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

tinyint

NULL

nvarchar(517)

NULL

uniqueidentifier

NOT NULL

nvarchar(263)

NULL

nvarchar(max)

NOT NULL

nvarchar(128)

NULL

nvarchar(500)

NULL

varchar(36)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(517)

NULL

nvarchar(257)

NULL

uniqueidentifier

NULL

nvarchar(128)

NULL

nvarchar(500)

NULL

varchar(36)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(517)

NULL

nvarchar(257)

NULL

uniqueidentifier

NULL

nvarchar(500)

NULL

nvarchar(500)

NULL

bit

NOT NULL

nvarchar(500)

NULL

nvarchar(500)

NULL

nvarchar(128)

NOT NULL

tinyint

NULL

Foreign Key Diagram

entity_1_1_fk-docs.ssas_pumlrelation

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.ssas_pumlrelation

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.ssas_pumlrelation

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.ssas_pumlrelation

Column Reference Diagram

entity_1_1_colref-docs.ssas_pumlrelation

Indexes

idx_ssas_PumlRelation__1

idx_ssas_PumlRelation__2

idx_ssas_PumlRelation__3

idx_ssas_PumlRelation__4

idx_ssas_PumlRelation__5

idx_ssas_PumlRelation__6

idx_ssas_PumlRelation__7

idx_ssas_PumlRelation__8

idx_ssas_PumlRelation__9

Column Details

_

delete_referential_action

delete_referential_action

tinyint

NULL

ForeignKey_fullname

ForeignKey_fullname

nvarchar(517)

NULL

ForeignKey_guid

ForeignKey_guid

uniqueidentifier

NOT NULL

ForeignKey_name

ForeignKey_name

nvarchar(263)

NULL

PumlRelation

PumlRelation

nvarchar(max)

NOT NULL

referenced_ColumnName

referenced_ColumnName

nvarchar(128)

NULL

referenced_IndexPatternColumnDatatype

referenced_IndexPatternColumnDatatype

nvarchar(500)

NULL

referenced_IndexPatternColumnGuid

referenced_IndexPatternColumnGuid

varchar(36)

NULL

referenced_IndexPatternColumnName

referenced_IndexPatternColumnName

nvarchar(128)

NULL

referenced_ObjectName

referenced_ObjectName

nvarchar(128)

NULL

referenced_RepoObject_fullname

referenced_RepoObject_fullname

nvarchar(517)

NULL

referenced_RepoObject_fullname2

referenced_RepoObject_fullname2

nvarchar(257)

NULL

referenced_RepoObject_guid

referenced_RepoObject_guid

uniqueidentifier

NULL

referencing_ColumnName

referencing_ColumnName

nvarchar(128)

NULL

referencing_IndexPatternColumnDatatype

referencing_IndexPatternColumnDatatype

nvarchar(500)

NULL

referencing_IndexPatternColumnGuid

referencing_IndexPatternColumnGuid

varchar(36)

NULL

referencing_IndexPatternColumnName

referencing_IndexPatternColumnName

nvarchar(128)

NULL

referencing_ObjectName

referencing_ObjectName

nvarchar(128)

NULL

referencing_RepoObject_fullname

referencing_RepoObject_fullname

nvarchar(517)

NULL

referencing_RepoObject_fullname2

referencing_RepoObject_fullname2

nvarchar(257)

NULL

referencing_RepoObject_guid

referencing_RepoObject_guid

uniqueidentifier

NULL

relationships_crossFilteringBehavior

relationships_crossFilteringBehavior

nvarchar(500)

NULL

relationships_fromCardinality

relationships_fromCardinality

nvarchar(500)

NULL

relationships_isActive

relationships_isActive

bit

NOT NULL

relationships_name

relationships_name

nvarchar(500)

NULL

relationships_toCardinality

relationships_toCardinality

nvarchar(500)

NULL

SchemaName

SchemaName

nvarchar(128)

NOT NULL

update_referential_action

update_referential_action

tinyint

NULL

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