103 lines
2.4 KiB
Plaintext
103 lines
2.4 KiB
Plaintext
table Dim_Institution
|
|
lineageTag: c0020314-ede0-4bf5-af71-1f63368ac6aa
|
|
|
|
column DATA_SOURCE
|
|
dataType: string
|
|
lineageTag: ef92d86e-2672-48cb-b067-4d00cf81e2ca
|
|
summarizeBy: none
|
|
sourceColumn: DATA_SOURCE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column INST_CODE
|
|
dataType: string
|
|
lineageTag: 0e1528fb-ae58-4b73-a6c2-fe734c464f54
|
|
summarizeBy: none
|
|
sourceColumn: INST_CODE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column INST_NAME
|
|
dataType: string
|
|
lineageTag: 7b364ad9-6e06-45a2-b407-269122777845
|
|
summarizeBy: none
|
|
sourceColumn: INST_NAME
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column INST_TYPE
|
|
dataType: string
|
|
lineageTag: b422bc30-7174-4c1e-8117-7ababf1767a0
|
|
summarizeBy: none
|
|
sourceColumn: INST_TYPE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column INST_SUB_TYPE
|
|
dataType: string
|
|
lineageTag: 97c97591-1e35-4a47-b883-a00bfe81b35d
|
|
summarizeBy: none
|
|
sourceColumn: INST_SUB_TYPE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column INS_LEVEL
|
|
dataType: string
|
|
lineageTag: 00eafba3-6a05-4888-b4f3-01d9fca3a621
|
|
summarizeBy: none
|
|
sourceColumn: INS_LEVEL
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column INST_SOURCE = [INST_CODE] & [DATA_SOURCE]
|
|
lineageTag: 3b4b18cd-ef02-4997-be9d-92f52044c84d
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition Dim_Institution = m
|
|
mode: import
|
|
queryGroup: Dim
|
|
source = ```
|
|
let
|
|
Source =
|
|
Value.NativeQuery(
|
|
Databricks.Catalogs(
|
|
ServerAddress, HttpPath, [
|
|
Catalog = CatalogName,
|
|
Database = null,
|
|
EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
|
|
]
|
|
){
|
|
[Name = CatalogName, Kind = "Database"]
|
|
}[Data],
|
|
"
|
|
SELECT DISTINCT
|
|
A.DATA_SOURCE,
|
|
A.INST_CODE,
|
|
NVL(B.inst_name, '') INST_NAME,
|
|
B.INST_TYPE,
|
|
B.INST_SUB_TYPE,
|
|
B.org_level_desc INS_LEVEL
|
|
FROM
|
|
dm.dm_tf_ext_unionall_sales a
|
|
left join dm.dm_td_institution b
|
|
on a.inst_code = b.inst_code
|
|
"
|
|
& UsingLimit,
|
|
null,
|
|
[
|
|
EnableFolding = true
|
|
]
|
|
)
|
|
in
|
|
Source
|
|
```
|
|
|
|
annotation PBI_NavigationStepName = Navigation
|
|
|
|
annotation PBI_ResultType = Table
|
|
|
|
annotation TabularEditor_TableGroup = 04_DimTable
|
|
|