table 'AIA.Fields_Columns'
	lineageTag: 5af64682-c52e-4339-b38e-054815c3185a

	column 'AIA.Fields_Columns'
		lineageTag: d6f2ae4d-643f-4583-9f71-a82a8c37dfdc
		summarizeBy: none
		sourceColumn: [Value1]
		sortByColumn: 'AIA.Fields_Columns Order'

		relatedColumnDetails
			groupByColumn: 'AIA.Fields_Columns Fields'

		annotation SummarizationSetBy = Automatic

	column 'AIA.Fields_Columns Fields'
		isHidden
		lineageTag: 03064e6f-4121-42db-9147-7e2fd5742bf2
		summarizeBy: none
		sourceColumn: [Value2]
		sortByColumn: 'AIA.Fields_Columns Order'

		extendedProperty ParameterMetadata =
				{
				  "version": 3,
				  "kind": 2
				}

		annotation SummarizationSetBy = Automatic

	column 'AIA.Fields_Columns Order'
		isHidden
		formatString: 0
		lineageTag: 10b0d01e-4161-4289-8ad3-4c31ba48792e
		summarizeBy: sum
		sourceColumn: [Value3]

		annotation SummarizationSetBy = Automatic

	column Value4
		lineageTag: 61ee26f1-d3fb-4072-9bf3-ceecc4fc72be
		summarizeBy: none
		isNameInferred
		sourceColumn: [Value4]

		annotation SummarizationSetBy = Automatic

	column Value5
		formatString: 0
		lineageTag: f8bd85a0-c567-422e-b7fa-17c6a8158ebc
		summarizeBy: sum
		isNameInferred
		sourceColumn: [Value5]

		annotation SummarizationSetBy = Automatic

	column Value6
		lineageTag: 473efe8d-635d-4d6e-97c6-2d6642a7c1f6
		summarizeBy: none
		isNameInferred
		sourceColumn: [Value6]

		annotation SummarizationSetBy = Automatic

	column Value7
		formatString: 0
		lineageTag: 3ea11172-d33f-4a62-8e65-dbc7735b0c9b
		summarizeBy: sum
		isNameInferred
		sourceColumn: [Value7]

		annotation SummarizationSetBy = Automatic

	partition 'AIA.Fields_Columns' = calculated
		mode: import
		source = ```
				{
				    ("Value Type", NAMEOF('Dim_Unit'[DW]), 0, "Period", 1 , "Unit", 1),
				    ("Period", NAMEOF(MQY[Period]), 1, "Period", 1 , "Period", 1),
				    ("YEAR", NAMEOF(Dim_Calendar[YEAR]), 2, "Period", 1 , "Period", 1),
				    ("YYYYHH", NAMEOF(Dim_Calendar[HALF_YEAR]), 3, "Period", 1  , "Period", 1),
				    ("YYYYQQ", NAMEOF(Dim_Calendar[YEAR_QUATER]), 4, "Period", 1  , "Period", 1),
				    ("YYYYMM", NAMEOF(Dim_Calendar[YYYYMM]), 5, "Period", 1  , "Period", 1),
				
				
				    ("Class", NAMEOF(Dim_MKTPackMapping[Class]), 11, "Market & Product", 2, "Market", 2),
				    ("Molecule CN", NAMEOF(Dim_PackInfo[CMPS_DES_C]), 13, "Market & Product", 2, "Product", 3),
				    ("Corp CN", NAMEOF('Dim_Corp'[CORP_DES_C]), 20, "Market & Product", 2  , "Corp", 1),
				    ("Brand CN", NAMEOF('Dim_PackInfo'[PROD_DES_C]), 30, "Market & Product", 2, "Product", 3),
				    
				    // ("Key Brand", NAMEOF(Dim_MKTPackMapping[KEY_COMPETITOR]), 32, "Market & Product", 2, "Key Brand", 5),
				    // ("Package EN", NAMEOF(Dim_PackInfo[PACK_DES]), 33, "Market & Product", 2, "Product", 3),
				    // ("Package Code", NAMEOF(Dim_PackInfo[PACK_COD]), 34, "Market & Product", 2, "Product", 3),
				    // ("Pack_LCH", NAMEOF(Dim_PackInfo[PACK_LCH]), 35, "Market & Product", 2, "Product", 3),
				    // ("VBP", NAMEOF(Dim_PackInfo[VBP_DESC]), 36, "Market & Product", 2, "VBP", 4),
				    // ("VBP_BATCH", NAMEOF('Dim_PackInfo'[VBP_BATCH]), 37, "Market & Product", 2, "VBP", 4),
				    // ("Originator/Generics", NAMEOF(Dim_PackInfo[GENE_ORIG_DESC]), 38, "Market & Product", 2, "Product", 3),
				
				    ("Province", NAMEOF('Dim_Geo'[PROVINCE_C]), 55, "Geography", 3, "Geo", 4),
				    ("City", NAMEOF('Dim_Geo'[CITY_C]), 56, "Geography", 3, "Geo", 4),
				    // ("City Tier", NAMEOF('Dim_Geo'[AZ_CITY_TIER]), 57, "Geography", 3, "Geo", 4),
				    // ("County", NAMEOF('Dim_Geo'[COUNTY_NAME]), 58, "Geography", 3, "Geo", 4),
				    // ("County Tier", NAMEOF('Dim_Geo'[county_tier]), 59, "Geography", 3, "Geo", 4),
				    // ("PMT Region", NAMEOF('Dim_Geo'[pmt_region]), 60, "Geography", 3, "Geo", 4),
				 
				    // ("BU Category", NAMEOF('Dim_Org'[BU_CATEGORY]), 70, "Organization", 4, "Org", 3),
				    // ("BU", NAMEOF('Dim_Org'[BU_NAME_EN]), 71, "Organization", 4, "Org", 3),
				    // ("Sub BU", NAMEOF('Dim_Org'[SUB_BU_NAME]), 72, "Organization", 4, "Org", 3),
				    ("RC", NAMEOF('Dim_Org'[RC_Name]), 73, "Organization", 4, "Org", 3),
				    ("Region", NAMEOF('Dim_Org'[region_name_en]), 74, "Organization", 4, "Org", 3),
				    // ("Team", NAMEOF('Dim_Org'[team]), 75, "Organization", 4, "Org", 3),
				    // ("Territory Code", NAMEOF('Dim_Org'[mr_trty_code]), 76, "Organization", 4, "Org", 3),
				    // ("RSD Name", NAMEOF('Dim_Org'[RC_Name]), 77, "Organization", 4, "Org", 3),
				    // ("RSM Name", NAMEOF('Dim_Org'[RSM_Name]), 78, "Organization", 4, "Org", 3),
				    // ("DSM Name", NAMEOF('Dim_Org'[dsm_name]), 79, "Organization", 4, "Org", 3),
				    // ("MR", NAMEOF('Dim_Org'[mr_name]), 80, "Organization", 4, "Org", 3),
				
				    ("Sub Channel", NAMEOF('Dim_RC'[sub_channel]), 90, "Channel", 5, "Channel", 5),
				    ("Dragon Flag", NAMEOF('Dim_RC'[DRAGON_FLAG]), 91, "Channel", 5, "Channel", 5),
				
				    // ("Ins Name", NAMEOF('Dim_Institution'[inst_name]), 100, "Ins", 6, "Ins", 1),
				    // ("Ins Sub Type", NAMEOF('Dim_Institution'[inst_sub_type]), 102, "Ins", 6, "Ins", 1),
				    // ("Ins Level", NAMEOF('Dim_Institution'[ins_level]), 103, "Ins", 6, "Ins", 1),
				    // ("Potential Type", NAMEOF('Dim_HP_Potential_AIA'[potential_type_name]), 105, "Ins", 6, "Potential", 2),
				    // ("Potential Market", NAMEOF('Dim_HP_Potential_AIA'[potential_mkt_name]), 106, "Ins", 6, "Potential", 2),
				    ("Decile", NAMEOF('Dim_HP_Potential_AIA'[decile]), 109, "Ins", 6, "Decile", 3),
				    ("Decile Group", NAMEOF('Dim_HP_Potential_AIA'[decile_group]), 110,  "Ins", 6, "Decile", 3)
				}
				```

	annotation PBI_Id = 94e09a8c59644a4292bfb633b2094d96