table Dim_PackInfo_Retail
	lineageTag: b0655c42-285d-44c4-b17d-1d8e0253e10d

	column product_id
		dataType: string
		lineageTag: 09fd3dac-2f11-4f8a-ba1e-76d73f14ae99
		summarizeBy: none
		sourceColumn: product_id

		annotation SummarizationSetBy = Automatic

	column iqvia_pack_code
		dataType: string
		lineageTag: 059a8601-5c87-41d7-b527-cc60b94c59a3
		summarizeBy: none
		sourceColumn: iqvia_pack_code

		annotation SummarizationSetBy = Automatic

	column prescription_nature
		dataType: string
		lineageTag: 05b398db-6f6d-4498-9965-79e71b8eb622
		summarizeBy: none
		sourceColumn: prescription_nature

		annotation SummarizationSetBy = Automatic

	column medicine_type
		dataType: string
		lineageTag: 195c1d06-fc75-4584-bb52-1c2a9036f3f6
		summarizeBy: none
		sourceColumn: medicine_type

		annotation SummarizationSetBy = Automatic

	column zk_medicine_tier1
		dataType: string
		lineageTag: c60a1bf2-d42c-4973-a3e2-206ecdecbd0b
		summarizeBy: none
		sourceColumn: zk_medicine_tier1

		annotation SummarizationSetBy = Automatic

	column zk_medicine_tier2
		dataType: string
		lineageTag: bc15beb2-dd7b-4ed2-b550-cbc0e2268a1e
		summarizeBy: none
		sourceColumn: zk_medicine_tier2

		annotation SummarizationSetBy = Automatic

	column zk_medicine_tier3
		dataType: string
		lineageTag: 9e9e36f2-a346-4ede-bd67-7677a2e91fb6
		summarizeBy: none
		sourceColumn: zk_medicine_tier3

		annotation SummarizationSetBy = Automatic

	column zk_medicine_tier4
		dataType: string
		lineageTag: fa02309d-f254-46c4-b3be-38ec728f1fde
		summarizeBy: none
		sourceColumn: zk_medicine_tier4

		annotation SummarizationSetBy = Automatic

	column common_name
		dataType: string
		lineageTag: a5acb45a-e843-428e-a857-0d3b70125091
		summarizeBy: none
		sourceColumn: common_name

		annotation SummarizationSetBy = Automatic

	column dosage_form
		dataType: string
		lineageTag: 6c9c6da5-f19b-4ffb-a670-9330336e3282
		summarizeBy: none
		sourceColumn: dosage_form

		annotation SummarizationSetBy = Automatic

	column user_type
		dataType: string
		lineageTag: 7d4e57ef-7b34-4f5c-a81a-258df46e84ed
		summarizeBy: none
		sourceColumn: user_type

		annotation SummarizationSetBy = Automatic

	column category_name
		dataType: string
		lineageTag: aff8df22-d9ae-4fd6-92b4-08c6b5702060
		summarizeBy: none
		sourceColumn: category_name

		annotation SummarizationSetBy = Automatic

	column product_name
		dataType: string
		lineageTag: 8afd7257-d8c6-4c0b-9b8c-e60ab403b5e9
		summarizeBy: none
		sourceColumn: product_name

		annotation SummarizationSetBy = Automatic

	column brand_name
		dataType: string
		lineageTag: 5a4651ef-0bae-4548-9a1f-bce1d5184a83
		summarizeBy: none
		sourceColumn: brand_name

		annotation SummarizationSetBy = Automatic

	column zk_manu_des
		dataType: string
		lineageTag: aea34570-21b9-492b-b1a1-23e046c89984
		summarizeBy: none
		sourceColumn: zk_manu_des

		annotation SummarizationSetBy = Automatic

	column zk_corp_des
		dataType: string
		lineageTag: 3bdc6d45-39d3-456d-91cf-a5e42a687141
		summarizeBy: none
		sourceColumn: zk_corp_des

		annotation SummarizationSetBy = Automatic

	column zk_pack_des
		dataType: string
		lineageTag: 9f91ed0c-cd5e-4884-97fd-58aee00a26e7
		summarizeBy: none
		sourceColumn: zk_pack_des

		annotation SummarizationSetBy = Automatic

	column DATA_SOURCE
		dataType: string
		lineageTag: f9ecf473-aed1-4a76-a71a-d9dfefb9b512
		summarizeBy: none
		sourceColumn: DATA_SOURCE

		annotation SummarizationSetBy = Automatic

	column PACK_SOURCE = [iqvia_pack_code] & [DATA_SOURCE]
		lineageTag: 59712599-b98f-4868-a21b-88bc9199057a
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	partition Dim_PackInfo_Retail = m
		mode: import
		queryGroup: FreeReport独有表
		source = ```
				let
				    Source = 
				Value.NativeQuery(
				        Databricks.Catalogs(
				            ServerAddress, HttpPath, [
				                Catalog = CatalogName,
				                Database = null,
				                EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
				            ]
				        ){
				            [Name = CatalogName, Kind = "Database"]
				        }[Data],
				      "SELECT product_id,iqvia_pack_code,prescription_nature,medicine_type,zk_medicine_tier1,zk_medicine_tier2,zk_medicine_tier3,zk_medicine_tier4,common_name,dosage_form,user_type,category_name,product_name,
				              brand_name,zk_manu_des,zk_corp_des,zk_pack_des,'Retail(Quarterly)' DATA_SOURCE
				         FROM DM.dm_zk_retail_product_info
				         union all 
				        SELECT product_id,iqvia_pack_code,prescription_nature,medicine_type,zk_medicine_tier1,zk_medicine_tier2,zk_medicine_tier3,zk_medicine_tier4,common_name,dosage_form,user_type,category_name,product_name,
				              brand_name,zk_manu_des,zk_corp_des,zk_pack_des,'EC(Monthly)' DATA_SOURCE
				         FROM DM.dm_zk_retail_product_info
				         "
				      & UsingLimit,
				        null,
				        [
				            EnableFolding = true
				        ]
				    )
				    in
				    Source
				```

	annotation PBI_ResultType = Table

	annotation PBI_NavigationStepName = Navigation