table Dim_IsTarget_AIASpecial
	lineageTag: 6eb3e95e-4ee6-4745-a70e-640a321d49bf

	column DATA_SOURCE
		dataType: string
		lineageTag: d2b25a39-907e-475d-b5d4-d73c08ca1c98
		summarizeBy: none
		sourceColumn: DATA_SOURCE

		annotation SummarizationSetBy = Automatic

	column IS_TARGET_HP
		dataType: string
		lineageTag: 6109e25a-2bab-4759-89e8-d035eec074cf
		summarizeBy: none
		sourceColumn: IS_TARGET_HP

		annotation SummarizationSetBy = Automatic

	column ISTARGET_SOURCE = [TARGET_KEY] & [DATA_SOURCE]
		lineageTag: db9571f9-7f4d-49d6-bf90-d692d2b8efe0
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	column TARGET_KEY
		dataType: string
		lineageTag: 391636df-d56a-4749-b7ce-b9b041c45abb
		summarizeBy: none
		sourceColumn: TARGET_KEY

		annotation SummarizationSetBy = Automatic

	partition Dim_IsTarget_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.IS_TARGET_HP ,CASE WHEN A.DATA_SOURCE = 'AIA(Monthly)' THEN B.IS_TARGET_HP ELSE '' END TARGET_KEY
				                FROM DM.DM_TF_EXTERNAL_SALES A
				            INNER JOIN (SELECT DISTINCT is_target_hp FROM DM.dm_aia_targethp_flag WHERE NVL(IS_TARGET_HP,'') <> '') B
				      "
				      & UsingLimit,
				        null,
				        [
				            EnableFolding = true
				        ]
				    )
				    in
				    Source
				```

	annotation PBI_ResultType = Table

	annotation PBI_NavigationStepName = Navigation