table Fact_EC_Total
	lineageTag: daa665c8-d4a0-4e27-a464-301f1dd1ab1a

	column CORP_COD
		dataType: string
		lineageTag: 67962be5-0d1c-4611-816a-51bf6a7631ec
		summarizeBy: none
		sourceColumn: CORP_COD

		annotation SummarizationSetBy = Automatic

	column TA
		dataType: string
		lineageTag: 5b0c67ff-c3bc-4ef4-b496-b9925d4979cf
		summarizeBy: none
		sourceColumn: TA

		annotation SummarizationSetBy = Automatic

	column YYYYMM
		dataType: string
		lineageTag: cab210cf-a683-4781-883d-b987981d9fc0
		summarizeBy: none
		sourceColumn: YYYYMM

		annotation SummarizationSetBy = Automatic

	column YTD
		dataType: string
		lineageTag: 737aea27-b674-4a72-a56b-e7e3c97c96ef
		summarizeBy: none
		sourceColumn: YTD

		annotation SummarizationSetBy = Automatic

	column KPI_NAME
		dataType: string
		lineageTag: c8fc0c1f-15e5-42dc-a9ff-1a7d9a9120e2
		summarizeBy: none
		sourceColumn: KPI_NAME

		annotation SummarizationSetBy = Automatic

	column TOTAL_FLAG
		dataType: string
		lineageTag: 891d8e5f-08e5-40e3-8431-d6c68a789914
		summarizeBy: none
		sourceColumn: TOTAL_FLAG

		annotation SummarizationSetBy = Automatic

	column PLATFORM
		dataType: string
		lineageTag: 2a5f036d-4914-44c8-8da3-2784a1b4d686
		summarizeBy: none
		sourceColumn: PLATFORM

		annotation SummarizationSetBy = Automatic

	column STORE_TYPE
		dataType: string
		lineageTag: ebeb7776-df3e-4297-b5d0-82a5badb59d8
		summarizeBy: none
		sourceColumn: STORE_TYPE

		annotation SummarizationSetBy = Automatic

	column DATA_SOURCE
		dataType: string
		lineageTag: 5ff6948b-d50a-451b-88d5-d5450ae2a652
		summarizeBy: none
		sourceColumn: DATA_SOURCE

		annotation SummarizationSetBy = Automatic

	column KPI_VAL
		dataType: double
		lineageTag: 4d0efbad-be14-477e-8a4a-30d0877d660c
		summarizeBy: sum
		sourceColumn: KPI_VAL

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	column KPI_VAL_LY
		dataType: double
		lineageTag: cb682e0b-4834-4f70-89f7-89f92f73f05e
		summarizeBy: sum
		sourceColumn: KPI_VAL_LY

		annotation SummarizationSetBy = Automatic

		annotation PBI_FormatHint = {"isGeneralNumber":true}

	column STR_KPI_VAL
		dataType: string
		lineageTag: b3a1e346-ccb5-46b7-8923-2c14153fd91a
		summarizeBy: none
		sourceColumn: STR_KPI_VAL

		annotation SummarizationSetBy = Automatic

	column STR_KPI_VAL_LY
		dataType: string
		lineageTag: 4d2a7d30-87f5-4376-9659-f21a5eceb58f
		summarizeBy: none
		sourceColumn: STR_KPI_VAL_LY

		annotation SummarizationSetBy = Automatic

	column STR_KPI_VOL
		dataType: string
		lineageTag: 5fe9cfe6-eb1e-4ba5-a8c5-31213cb371d9
		summarizeBy: none
		sourceColumn: STR_KPI_VOL

		annotation SummarizationSetBy = Automatic

	column STR_KPI_VOL_LY
		dataType: string
		lineageTag: 274cbf35-2fef-413f-a274-72e624fcf8d8
		summarizeBy: none
		sourceColumn: STR_KPI_VOL_LY

		annotation SummarizationSetBy = Automatic

	column TA_SOURCE = [TA] & [DATA_SOURCE]
		lineageTag: 6717cce3-b22d-4a39-9cb7-32a5a5b14955
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column DATE_KEY = DATE(LEFT([YYYYMM],4),RIGHT([YYYYMM],2),"01")
		formatString: General Date
		lineageTag: d06076b9-90e7-41db-9751-b48cac332018
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column PLATFORM_TYPE_SOURCE = [PLATFORM] & [DATA_SOURCE]
		lineageTag: 24e59c8e-7f9d-42b2-8882-990949d515f0
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column STORE_TYPE_SOURCE = [STORE_TYPE] & [DATA_SOURCE]
		lineageTag: 496edf0d-2b02-46f4-8b01-672697ecd1d9
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	partition Fact_EC_Total = m
		mode: import
		queryGroup: 首页直取KPI
		source = ```
				let
				    Source = 
				Value.NativeQuery(
				        Databricks.Catalogs(
				            ServerAddress, HttpPath, [
				                Catalog = CatalogName,
				                Database = null,
				                EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
				            ]
				        ){
				            [Name = CatalogName, Kind = "Database"]
				        }[Data],
				      "SELECT A.CORP_COD,TA,YYYYMM,YTD,KPI_NAME,TOTAL_FLAG,PLATFORM,STORE_TYPE,'EC(Monthly)' DATA_SOURCE,SUM(KPI_VAL) KPI_VAL,SUM(KPI_VAL_LY) KPI_VAL_LY,MAX(STR_KPI_VAL) 
				              STR_KPI_VAL,MAX(STR_KPI_VAL_LY) STR_KPI_VAL_LY,MAX(STR_KPI_VOL) STR_KPI_VOL,MAX(STR_KPI_VOL_LY) STR_KPI_VOL_LY
				         FROM dm.dm_zk_ec_sales_kpi A 
				        WHERE KPI_NAME = 'top_rank' AND A.CORP_COD = 'A5Z'
				        GROUP BY A.CORP_COD,TA,YYYYMM,YTD,KPI_NAME,TOTAL_FLAG,PLATFORM,STORE_TYPE"
				      & UsingLimit,
				        null,
				        [
				            EnableFolding = true
				        ]
				    )
				    in
				    Source
				```

	annotation PBI_ResultType = Exception

	annotation PBI_NavigationStepName = Navigation