123 lines
2.7 KiB
Plaintext
123 lines
2.7 KiB
Plaintext
table Dim_MarketTA
|
|
lineageTag: afacd2f2-f2f7-4281-ab5d-81ce59e8dd6b
|
|
|
|
column MARKET
|
|
dataType: string
|
|
lineageTag: 627fc8ad-3e2f-4c1e-bef1-78b0bc422aad
|
|
summarizeBy: none
|
|
sourceColumn: MARKET
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column TA
|
|
dataType: string
|
|
lineageTag: 3047c32e-71e6-42fa-a02e-993f5a460c49
|
|
summarizeBy: none
|
|
sourceColumn: TA
|
|
|
|
changedProperty = SortByColumn
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column TA_RN
|
|
dataType: int64
|
|
formatString: 0
|
|
lineageTag: 48473ec5-b9fa-4428-a1bb-9ff5c7efe06c
|
|
summarizeBy: sum
|
|
sourceColumn: TA_RN
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column DATA_SOURCE
|
|
dataType: string
|
|
lineageTag: f60d7f37-34f6-4afb-a927-b04ae50d33cb
|
|
summarizeBy: none
|
|
sourceColumn: DATA_SOURCE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MKT_SOURCE = [MARKET] & [DATA_SOURCE]
|
|
lineageTag: f8ed9a55-0e5b-4ecd-844c-1f74641ec184
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MARKET_DESC
|
|
dataType: string
|
|
lineageTag: e8cb778c-9cd1-4643-8696-6a1cda4af99c
|
|
summarizeBy: none
|
|
sourceColumn: MARKET_DESC
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column TA_SOURCE =
|
|
|
|
// 2.1 EC数据源对应NIAD和DM要保持一样的数据
|
|
SWITCH(TRUE(),[DATA_SOURCE] = "EC(Monthly)"&& [TA] = "NIAD","DMEC(Monthly)",
|
|
[TA] & [DATA_SOURCE])
|
|
lineageTag: 1b085954-9d8d-4e94-9a05-9c7eaf148b99
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column TA_MAP
|
|
dataType: string
|
|
lineageTag: 53b34554-bdbb-42d5-887d-7285705c5426
|
|
summarizeBy: none
|
|
sourceColumn: TA_MAP
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column TA_SOURCE2 = [TA_MAP] & [DATA_SOURCE]
|
|
lineageTag: f76019ab-dba0-4fbd-81b1-be0d09823b2c
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition Dim_MarketTA = 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
|
|
MARKET,
|
|
TA,
|
|
TA_MAP,
|
|
TA_RN,
|
|
MARKET_DESC,
|
|
DATA_SOURCE
|
|
FROM
|
|
dm.dm_td_ext_unionall_market_ta
|
|
WHERE
|
|
TA <> ''
|
|
OR TA_MAP <> ''
|
|
"
|
|
& UsingLimit,
|
|
null,
|
|
[
|
|
EnableFolding = true
|
|
]
|
|
)
|
|
in
|
|
Source
|
|
```
|
|
|
|
annotation PBI_ResultType = Table
|
|
|
|
annotation PBI_NavigationStepName = 导航
|
|
|
|
annotation TabularEditor_TableGroup = 04_DimTable
|
|
|