ssas.additional_Reference_step1 - V
type: V ( view ), modify_date: 2021-09-28 18:49:40
RepoObject_guid: 1EEFA93C-7C20-EC11-8524-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_additional_Reference_step1__1
-
IndexSemanticGroup: no_group
-
[column-tables_columns_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_additional_Reference_step1__2
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-tables_name]; nvarchar(128)
-
[column-tables_partitions_name]; nvarchar(500)
-
-
PK, Unique, Real: 0, 0, 0
idx_additional_Reference_step1__3
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-tables_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_additional_Reference_step1__4
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
referenced_AntoraComponent
referenced_AntoraComponent |
|
|
referenced_AntoraModule
referenced_AntoraModule |
|
|
tables_columns_sourceColumn
tables_columns_sourceColumn |
|
|
sql_modules_definition
ssas.additional_Reference_step1 - V script
Create View ssas.additional_Reference_step1
As
Select
col.RepoObject_guid
, col.RepoObjectColumn_guid
, part.databasename
, part.tables_name
, col.tables_columns_name
, col.tables_columns_sourceColumn
, part.tables_partitions_source_dataSource
, part.Part1
, part.Part2
, part.Part3
, part.tables_partitions_name
, dsource.referenced_AntoraComponent
, dsource.referenced_AntoraModule
, referencing_AntoraComponent = AntoraComponent.Parameter_value_result
, referencing_AntoraModule = AntoraModule.Parameter_value_result
--, part.tables_partitions_source_name
--, part.tables_partitions_source_expression
--, part.tables_partitions_source_query
--, part.tables_partitions_source_query_ja
--, part.tables_partitions_source_type
--, part.PosFrom
--, part.PosFromWhere
--, part.StringFrom
--, part.PosDot1
--, part.PosDot2
From
ssas.model_json_31311111_tables_partitions_source_Part123 As part
Left Outer Join
ssas.model_json_311_tables_columns_T As col
On
col.RepoObject_guid = part.RepoObject_guid
Left Join
ssas.model_json_33_dataSources_T As dsource
On
dsource.databasename = part.databasename
And dsource.dataSources_name = part.tables_partitions_source_dataSource
Cross Join config.ftv_get_parameter_value ( 'AntoraComponent', '' ) As AntoraComponent
Cross Join config.ftv_get_parameter_value ( 'AntoraModule', '' ) As AntoraModule
Where
Not col.tables_columns_name Is Null
And Not col.tables_columns_sourceColumn Is Null
And col.tables_name = part.tables_name
And Not part.Part3 Is Null