470 lines
11 KiB
Plaintext
470 lines
11 KiB
Plaintext
table Fact_Sales_THC
|
|
lineageTag: dd276b39-96c0-46dd-878f-9f1f23dbeb5c
|
|
|
|
column YYYYMM
|
|
dataType: string
|
|
lineageTag: a70e5d80-2d97-43a4-bdce-9667b4392a72
|
|
summarizeBy: none
|
|
sourceColumn: YYYYMM
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PLATFORM_TYPE
|
|
dataType: string
|
|
lineageTag: 5fe3a8c1-99d1-4c67-a4dc-eada3864db39
|
|
summarizeBy: none
|
|
sourceColumn: PLATFORM_TYPE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column STORE_NAME
|
|
dataType: string
|
|
lineageTag: 9c33981f-64e0-47de-9305-8c43527df67a
|
|
summarizeBy: none
|
|
sourceColumn: STORE_NAME
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column STORE_TYPE
|
|
dataType: string
|
|
lineageTag: 70d75e39-245f-44e5-a502-b0c0fd429dac
|
|
summarizeBy: none
|
|
sourceColumn: STORE_TYPE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column REGION_TYPE
|
|
dataType: string
|
|
lineageTag: 4b455d75-6ed5-463c-975f-14219584cb89
|
|
summarizeBy: none
|
|
sourceColumn: REGION_TYPE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PACK_FLAG
|
|
dataType: int64
|
|
formatString: 0
|
|
lineageTag: 7af100b2-04d3-4ab1-b03e-3bde21ae487d
|
|
summarizeBy: sum
|
|
sourceColumn: PACK_FLAG
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PROD_FLAG
|
|
dataType: int64
|
|
formatString: 0
|
|
lineageTag: 6cc17357-6635-46fc-96e9-a61f697deab5
|
|
summarizeBy: sum
|
|
sourceColumn: PROD_FLAG
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column DTP_FLAG
|
|
dataType: int64
|
|
formatString: 0
|
|
lineageTag: c158556d-4315-4ece-a89b-9e6f05098b8e
|
|
summarizeBy: sum
|
|
sourceColumn: DTP_FLAG
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column SALES_UNIT_CAL
|
|
dataType: double
|
|
lineageTag: a1366f7d-62f4-4588-9867-5de78dd67b86
|
|
summarizeBy: sum
|
|
sourceColumn: SALES_UNIT_CAL
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column SALES_UNIT_CAL_LY
|
|
dataType: double
|
|
lineageTag: 5bc9c8a0-5cae-4840-8e56-ceba4ded83a1
|
|
summarizeBy: sum
|
|
sourceColumn: SALES_UNIT_CAL_LY
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column SALES_VALUE_CAL
|
|
dataType: double
|
|
lineageTag: ba216581-5c0a-45a5-98f6-47c8f44cc985
|
|
summarizeBy: sum
|
|
sourceColumn: SALES_VALUE_CAL
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column SALES_VALUE_CAL_LY
|
|
dataType: double
|
|
lineageTag: 18eea9a2-23a4-4662-82f0-a594fcf6a386
|
|
summarizeBy: sum
|
|
sourceColumn: SALES_VALUE_CAL_LY
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column CONUTING_UNIT
|
|
dataType: double
|
|
lineageTag: 7961ba57-2e88-436d-bac8-91a69a4614cf
|
|
summarizeBy: sum
|
|
sourceColumn: CONUTING_UNIT
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column CONUTING_UNIT_LY
|
|
dataType: double
|
|
lineageTag: 4948e19c-8cf3-48f6-8c4f-0807396c5b4f
|
|
summarizeBy: sum
|
|
sourceColumn: CONUTING_UNIT_LY
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column DATA_SOURCE
|
|
dataType: string
|
|
lineageTag: 4282efad-bf51-49a8-a898-5c9cf0577a9c
|
|
summarizeBy: none
|
|
sourceColumn: DATA_SOURCE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column DEPT_SOURCE = [dept_name] & [DATA_SOURCE]
|
|
lineageTag: dec5ae2c-b418-4d11-b2b2-c58bf604269a
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PLATFORM_TYPE_SOURCE = [PLATFORM_TYPE] & [DATA_SOURCE]
|
|
lineageTag: 70603d6c-857b-47b4-b017-bb9635ccfc05
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PACK_SOURCE = [PACK_COD] & [DATA_SOURCE] &[new_code]
|
|
lineageTag: 6ee5b30a-1653-4404-871c-6d4edd0ab61c
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column AUDIT_KEY = [AUDIT_COD] & [DATA_SOURCE] & [REGION_TYPE]
|
|
lineageTag: 4dbfc7c7-f83c-4639-974e-767fcf7d4e4b
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column DATE_KEY = DATE(LEFT([YYYYMM],4),RIGHT([YYYYMM],2),"01")
|
|
formatString: General Date
|
|
lineageTag: 74f51fd4-a30a-4583-ab76-eed69172f3b7
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column STORE_TYPE_SOURCE = [STORE_TYPE] & [DATA_SOURCE]
|
|
lineageTag: 0c987f3d-1533-4660-8e01-c69f1f0ac596
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column INST_SOURCE = [inst_code] & [DATA_SOURCE]
|
|
lineageTag: d6db6d47-e77c-41f6-937e-5f6fcdbcb56d
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MOLECULE_SOURCE = RELATED(Dim_PackInfo[MOLECULE_SOURCE])
|
|
lineageTag: f5f18756-9e95-4a06-a77d-f32aecfc2fca
|
|
summarizeBy: none
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column MARKET
|
|
dataType: string
|
|
lineageTag: 818eb04d-9dfd-474c-8de5-f6ca0d0aac81
|
|
summarizeBy: none
|
|
sourceColumn: MARKET
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column KEY_COMPETITOR
|
|
dataType: string
|
|
lineageTag: c2f27df5-55d9-4025-9cbc-9c878c712ef2
|
|
summarizeBy: none
|
|
sourceColumn: KEY_COMPETITOR
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column CLASS
|
|
dataType: string
|
|
lineageTag: 85c3b6db-18d0-4db2-ae07-b79fd8e7818b
|
|
summarizeBy: none
|
|
sourceColumn: CLASS
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column CMPS_FLAG
|
|
dataType: string
|
|
lineageTag: 565b34fe-1d3d-4708-92b1-75f283e405ff
|
|
summarizeBy: none
|
|
sourceColumn: CMPS_FLAG
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column NEW_CODE
|
|
dataType: string
|
|
lineageTag: 00eed873-663f-43ff-9344-2422c6ec4986
|
|
summarizeBy: none
|
|
sourceColumn: NEW_CODE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column INST_CODE
|
|
dataType: string
|
|
lineageTag: 2013e8f0-bce7-4f20-9fe0-b7b7edda8bdc
|
|
summarizeBy: none
|
|
sourceColumn: INST_CODE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column AIA_HP_FLAG
|
|
dataType: string
|
|
lineageTag: 955d3ebd-4ee9-4661-a380-b32537935371
|
|
summarizeBy: none
|
|
sourceColumn: AIA_HP_FLAG
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column DEPT_NAME
|
|
dataType: string
|
|
lineageTag: 16522846-58b0-46c1-9ea0-a44c739702f3
|
|
summarizeBy: none
|
|
sourceColumn: DEPT_NAME
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column H_LEVEL
|
|
dataType: string
|
|
lineageTag: 04b39341-e089-4cfe-8f6a-dba7d0d302ce
|
|
summarizeBy: none
|
|
sourceColumn: H_LEVEL
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column REIMBURSE
|
|
dataType: string
|
|
lineageTag: 3418ea49-6073-4b2f-bf53-15f4df6569fd
|
|
summarizeBy: none
|
|
sourceColumn: REIMBURSE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column REIMBURSE_TYPE
|
|
dataType: string
|
|
lineageTag: 1ea2fe54-33c8-407d-bf2f-9792d35c55fd
|
|
summarizeBy: none
|
|
sourceColumn: REIMBURSE_TYPE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PRESCRIPTION_TYPE
|
|
dataType: string
|
|
lineageTag: 122652c2-e9e9-4fd1-8496-a1666b8dedd3
|
|
summarizeBy: none
|
|
sourceColumn: PRESCRIPTION_TYPE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PRESCRIPTION
|
|
dataType: double
|
|
lineageTag: c02a23f2-9e4a-4bff-9010-8471e63632b7
|
|
summarizeBy: sum
|
|
sourceColumn: PRESCRIPTION
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column PRESCRIPTION_LY
|
|
dataType: double
|
|
lineageTag: 5a120918-4194-4f85-a109-464372fcca8a
|
|
summarizeBy: sum
|
|
sourceColumn: PRESCRIPTION_LY
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column VA
|
|
dataType: double
|
|
lineageTag: 3fe98419-b4d4-47fc-893b-ce5871710966
|
|
summarizeBy: sum
|
|
sourceColumn: VA
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column UT
|
|
dataType: double
|
|
lineageTag: 45f3e277-6778-43af-8381-733115dbdbb4
|
|
summarizeBy: sum
|
|
sourceColumn: UT
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column CU
|
|
dataType: double
|
|
lineageTag: eeda6984-c175-4c72-b26e-71bc9375ec09
|
|
summarizeBy: sum
|
|
sourceColumn: CU
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column PT
|
|
dataType: double
|
|
lineageTag: 77486867-5bc5-459b-a1ee-3c37e1758e5e
|
|
summarizeBy: sum
|
|
sourceColumn: PT
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column PDOT
|
|
dataType: double
|
|
lineageTag: 9d8cf148-b6c1-4c55-bb00-37f02e37f653
|
|
summarizeBy: sum
|
|
sourceColumn: PDOT
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column PDOT_LY
|
|
dataType: double
|
|
lineageTag: 3a8f23aa-6a2c-40b1-b671-56a3911ff4e5
|
|
summarizeBy: sum
|
|
sourceColumn: PDOT_LY
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
annotation PBI_FormatHint = {"isGeneralNumber":true}
|
|
|
|
column MARKET_KEY
|
|
dataType: string
|
|
lineageTag: 7827470a-6fd4-49c7-b432-75d6ce8986cb
|
|
summarizeBy: none
|
|
sourceColumn: MARKET_KEY
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column PACK_COD
|
|
dataType: string
|
|
lineageTag: fe7d5135-41de-4f1a-af98-22b14a760dfa
|
|
summarizeBy: none
|
|
sourceColumn: PACK_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column CORP_COD
|
|
dataType: string
|
|
lineageTag: 57a11780-70d7-4454-a8e7-ba7fae398261
|
|
summarizeBy: none
|
|
sourceColumn: CORP_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column AUDIT_COD
|
|
dataType: string
|
|
lineageTag: b4cf1c2e-9d9a-4101-b09c-988725796e51
|
|
summarizeBy: none
|
|
sourceColumn: AUDIT_COD
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition Fact_Sales_THC = m
|
|
mode: import
|
|
queryGroup: Fact_Sales
|
|
source = ```
|
|
let
|
|
Source = Value.NativeQuery(
|
|
Databricks.Catalogs(
|
|
ServerAddress,
|
|
HttpPath,
|
|
[
|
|
Catalog = CatalogName,
|
|
Database = null,
|
|
EnableAutomaticProxyDiscovery = null,
|
|
EnableQueryResultDownload = "0"
|
|
]
|
|
){[Name = CatalogName, Kind = "Database"]}[Data],
|
|
"
|
|
SELECT
|
|
MARKET,
|
|
KEY_COMPETITOR,
|
|
CLASS,
|
|
YYYYMM,
|
|
PACK_CODE AS PACK_COD,
|
|
CORP_CODE AS CORP_COD,
|
|
AUDIT_CODE AS AUDIT_COD,
|
|
PLATFORM_TYPE,
|
|
STORE_NAME,
|
|
STORE_TYPE,
|
|
REGION_TYPE,
|
|
DATA_SOURCE,
|
|
PACK_FLAG,
|
|
PROD_FLAG,
|
|
DTP_FLAG,
|
|
CMPS_FLAG,
|
|
NEW_CODE,
|
|
INST_CODE,
|
|
AIA_HP_FLAG,
|
|
DEPT_NAME,
|
|
H_LEVEL,
|
|
REIMBURSE,
|
|
REIMBURSE_TYPE,
|
|
PRESCRIPTION_TYPE,
|
|
PRESCRIPTION,
|
|
PRESCRIPTION_LY,
|
|
VA,
|
|
UT,
|
|
CU,
|
|
PT,
|
|
SALES_UNIT_CAL,
|
|
SALES_UNIT_CAL_LY,
|
|
SALES_VALUE_CAL,
|
|
SALES_VALUE_CAL_LY,
|
|
CONUTING_UNIT,
|
|
CONUTING_UNIT_LY,
|
|
PDOT,
|
|
PDOT_LY,
|
|
CONCAT(MARKET, DATA_SOURCE) MARKET_KEY
|
|
FROM
|
|
DM.dm_tf_ext_thc_market_sales_cht
|
|
"
|
|
& UsingLimit,
|
|
null,
|
|
[EnableFolding = true]
|
|
)
|
|
in
|
|
Source
|
|
```
|
|
|
|
annotation PBI_NavigationStepName = 导航
|
|
|
|
annotation PBI_ResultType = Table
|
|
|
|
annotation TabularEditor_TableGroup = 05_FactTable
|
|
|