table Dim_HPFlag_AIASpecial
	lineageTag: dee1f54b-e7f5-4b88-abba-15f3a6c3ab4d

	column DATA_SOURCE
		dataType: string
		lineageTag: 25974d48-ebd7-499c-a67b-2ba737df6312
		summarizeBy: none
		sourceColumn: DATA_SOURCE

		annotation SummarizationSetBy = Automatic

	column AIA_HP_FLAG
		dataType: string
		lineageTag: 295809d7-f93b-4b81-9e16-3bfb66ff1c98
		summarizeBy: none
		sourceColumn: AIA_HP_FLAG

		annotation SummarizationSetBy = Automatic

	column HP_SOURCE = [HP_KEY] & [DATA_SOURCE]
		lineageTag: e32b8d1f-1b77-4f6a-b063-1255fe72fa97
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column HP_KEY
		dataType: string
		lineageTag: 14a208cb-ff36-4993-a882-7e216ac0f307
		summarizeBy: none
		sourceColumn: HP_KEY

		annotation SummarizationSetBy = Automatic

	partition Dim_HPFlag_AIASpecial = m
		mode: import
		queryGroup: 非首页
		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,B.AIA_HP_FLAG ,CASE WHEN A.DATA_SOURCE = 'AIA(Monthly)' THEN B.AIA_HP_FLAG ELSE '' END HP_KEY
				                FROM DM.DM_TF_EXTERNAL_SALES A
				            INNER JOIN (SELECT DISTINCT AIA_HP_FLAG FROM DM.dm_aia_hp_flag WHERE NVL(AIA_HP_FLAG,'') <> '') B
				      "
				      & UsingLimit,
				        null,
				        [
				            EnableFolding = true
				        ]
				    )
				    in
				    Source
				```

	annotation PBI_ResultType = Table

	annotation PBI_NavigationStepName = Navigation