reference.additional_Reference_from_ssas_src - V

type: V ( view ), modify_date: 2021-09-29 09:23:24

RepoObject_guid: 989CF4CE-8020-EC11-8524-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.additional_reference_from_ssas_src

Columns

Table 1. Columns of reference.additional_Reference_from_ssas_src - V
PK Column Name Data Type NULL? ID

1

nvarchar(128)

NULL

2

nvarchar(128)

NULL

3

nvarchar(max)

NULL

4

nvarchar(max)

NULL

5

nvarchar(500)

NULL

6

nvarchar(max)

NULL

7

nvarchar(max)

NULL

8

nvarchar(128)

NOT NULL

9

nvarchar(128)

NOT NULL

10

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.additional_reference_from_ssas_src

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.additional_reference_from_ssas_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.additional_reference_from_ssas_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.additional_reference_from_ssas_src

Column Reference Diagram

entity_1_1_colref-reference.additional_reference_from_ssas_src

Indexes

PK_additional_Reference_from_ssas_src

idx_additional_Reference_from_ssas_src__2

idx_additional_Reference_from_ssas_src__3

idx_additional_Reference_from_ssas_src__4

Column Details

_

referenced_AntoraComponent

1

referenced_AntoraComponent

nvarchar(128)

NULL

referenced_AntoraModule

2

referenced_AntoraModule

nvarchar(128)

NULL

referenced_Schema

3

referenced_Schema

nvarchar(max)

NULL

referenced_Object

4

referenced_Object

nvarchar(max)

NULL

referenced_Column

5

referenced_Column

nvarchar(500)

NULL

referencing_AntoraComponent

6

referencing_AntoraComponent

nvarchar(max)

NULL

referencing_AntoraModule

7

referencing_AntoraModule

nvarchar(max)

NULL

referencing_Schema

8

referencing_Schema

nvarchar(128)

NOT NULL

referencing_Object

9

referencing_Object

nvarchar(128)

NOT NULL

referencing_Column

10

referencing_Column

nvarchar(128)

NULL

sql_modules_definition

reference.additional_Reference_from_ssas_src - V script
CREATE View reference.additional_Reference_from_ssas_src
As
Select
    Distinct
    referenced_AntoraComponent
  , referenced_AntoraModule
  , referenced_Schema          = Replace ( Replace ( Part2, '[', '' ), ']', '' )
  , referenced_Object          = Replace ( Replace ( Part3, '[', '' ), ']', '' )
  , referenced_Column          = tables_columns_sourceColumn
  , referencing_AntoraComponent
  , referencing_AntoraModule
  , referencing_Schema         = databasename
  , referencing_Object         = tables_name
  , referencing_Column         = tables_columns_name
--, RepoObject_guid
--, RepoObjectColumn_guid
--, databasename
--, tables_name
--, tables_columns_name
--, tables_columns_sourceColumn
--, tables_partitions_source_dataSource
--, Part1
--, Part2
--, Part3
--, tables_partitions_name
From
    ssas.additional_Reference_step1
Where
    Not referenced_AntoraComponent Is Null
    And Not referenced_AntoraModule Is Null
    And Not Part2 Is Null
    And Not Part3 Is Null
    And Not tables_columns_sourceColumn Is Null