68 lines
1.7 KiB
Plaintext
68 lines
1.7 KiB
Plaintext
table Dim_RC_Merged_Data
|
|
lineageTag: 96000f39-4333-4de0-aadd-89d481bc13a3
|
|
|
|
column KEY
|
|
dataType: string
|
|
lineageTag: ef40fbb2-e0cc-4dc2-bd87-b89ec8e48f89
|
|
summarizeBy: none
|
|
sourceColumn: KEY
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MARKET
|
|
dataType: string
|
|
lineageTag: 57d6ffb7-f7e5-4024-aee3-a4905383f349
|
|
summarizeBy: none
|
|
sourceColumn: MARKET
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column IS_TARGET_HP
|
|
dataType: string
|
|
lineageTag: 98f47592-994c-4290-98f3-1a406bd5edbb
|
|
summarizeBy: none
|
|
sourceColumn: IS_TARGET_HP
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition Dim_RC_Merged_Data = m
|
|
mode: import
|
|
queryGroup: OLD\非首页
|
|
source = ```
|
|
let
|
|
Source =
|
|
Value.NativeQuery(
|
|
Databricks.Catalogs(
|
|
ServerAddress, HttpPath, [
|
|
Catalog = CatalogName,
|
|
Database = null,
|
|
EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
|
|
]
|
|
){
|
|
[Name = CatalogName, Kind = "Database"]
|
|
}[Data],
|
|
"
|
|
Select
|
|
distinct
|
|
concat( AUDIT_COD ,DATA_SOURCE ) KEY
|
|
,MARKET
|
|
,CASE WHEN (A.REGION_CODE ='ROC' OR A.REGION_CODE ='' OR A.REGION_CODE IS NULL ) AND A.DATA_SOURCE = 'AIA(Monthly)' THEN 'N' ELSE 'Y' END AS IS_TARGET_HP
|
|
from DM.dm_td_external_org_merged_data A
|
|
"
|
|
& UsingLimit,
|
|
null,
|
|
[
|
|
EnableFolding = true
|
|
]
|
|
)
|
|
in
|
|
Source
|
|
```
|
|
|
|
annotation PBI_NavigationStepName = Navigation
|
|
|
|
annotation PBI_ResultType = Table
|
|
|
|
annotation TabularEditor_TableGroup = 04_DimTable
|
|
|