table 'AIA.Fields.Rows' lineageTag: 493fffa3-faf3-483b-a23c-c0833a4cd88f measure 'External.Filter.THC.Province' = CALCULATE(INT(NOT(ISEMPTY(Fact_Sales_THC))),ALL(Dim_Calendar)) lineageTag: 47338742-664d-4c6c-86e7-5455854b1fe6 annotation PBI_FormatHint = {"isGeneralNumber":true} measure 'Config.RatioQuery.Text' = IF(SELECTEDVALUE(Config_ReportURL[ReportName]) = "MA", "点击市场折算系数查询", "点击PDOT系数查询") /* 用于市场系数查询的提示字符串 */ lineageTag: 0bb4edb4-4211-437e-8881-56a47a3f1525 annotation PBI_FormatHint = {"isGeneralNumber":true} measure 'Cofing.PDOTRatioType' = "counting unit" lineageTag: c30660f4-9767-4a8e-be53-e84e1730e1f6 annotation PBI_FormatHint = {"isGeneralNumber":true} measure 'AIA.DataQualityLight' = SWITCH(SELECTEDVALUE(Fact_AIA_DataQuality[light]), "红灯",1, "绿灯",3, "黄灯",2) lineageTag: 101dcce4-4a4b-46e3-a9e6-f0f048ad74c9 annotation PBI_FormatHint = {"isGeneralNumber":true} column Fields lineageTag: bd713b32-177d-4ca2-8bcd-aa425518062f summarizeBy: none sourceColumn: [Value1] sortByColumn: 'AIA.Fields.Rows Order' relatedColumnDetails groupByColumn: 'AIA.Fields.Rows Fields' annotation SummarizationSetBy = Automatic column 'AIA.Fields.Rows Fields' isHidden lineageTag: 69f45bd9-eb1c-4aa2-a930-e7227fda68de summarizeBy: none sourceColumn: [Value2] sortByColumn: 'AIA.Fields.Rows Order' extendedProperty ParameterMetadata = { "version": 3, "kind": 2 } annotation SummarizationSetBy = Automatic column 'AIA.Fields.Rows Order' isHidden formatString: 0 lineageTag: 7da4e131-41ee-49bb-9174-38e0d6bef98e summarizeBy: sum sourceColumn: [Value3] annotation SummarizationSetBy = Automatic column Category lineageTag: 5092e16a-5968-4ff2-8087-81bd70e60e74 summarizeBy: none sourceColumn: [Value4] sortByColumn: 'Category Order' annotation SummarizationSetBy = Automatic column 'Category Order' formatString: 0 lineageTag: ad979d4c-23f2-4913-80a1-cb27b9ddb603 summarizeBy: sum sourceColumn: [Value5] annotation SummarizationSetBy = Automatic column 'Sub Category' lineageTag: 29507a30-6399-4709-a501-3c2e2a3ba200 summarizeBy: none sourceColumn: [Value6] annotation SummarizationSetBy = Automatic column 'Sub Category Order' formatString: 0 lineageTag: eb0c8843-58fb-4a40-94f4-5f79a5399088 summarizeBy: sum sourceColumn: [Value7] annotation SummarizationSetBy = Automatic partition 'AIA.Fields.Rows' = calculated mode: import source = ``` { // ("Data Source", NAMEOF('Dim_DataSource'[SOURCENAME]), 0,"General", 0 ,"General", 1), ("Value Type", NAMEOF('Dim_Unit'[DW]), 1,"General", 0 ,"General", 1), ("Period", NAMEOF(MQY[Period]), 2, "Period", 1 , "Period", 1), ("YEAR", NAMEOF(Dim_Calendar[YEAR]), 3, "Period", 1 , "Period", 1), ("YYYYHH", NAMEOF(Dim_Calendar[HALF_YEAR]), 4, "Period", 1 , "Period", 1), ("YYYYQQ", NAMEOF(Dim_Calendar[YEAR_QUATER]), 5, "Period", 1 , "Period", 1), ("YYYYMM", NAMEOF(Dim_Calendar[YYYYMM]), 6, "Period", 1 , "Period", 1), ("Market", NAMEOF('Dim_Market'[Market]), 10, "Market & Product", 2, "Market", 2), ("Class", NAMEOF(Dim_Class[Class]), 11, "Market & Product", 2, "Market", 2), ("Molecule CN", NAMEOF(Dim_PackInfo[CMPS_DES_C]), 13, "Market & Product", 2, "Product", 3), ("Molecule EN", NAMEOF(Dim_PackInfo[CMPS_DES]), 14, "Market & Product", 2, "Product", 3), ("Brand Package Corp", NAMEOF(Dim_PackInfo[PROD_PACK_CORP]), 16, "Market & Product", 2, "Product", 3), ("Molecule EN & CN", NAMEOF(Dim_PackInfo[MOLECULE_CODE_DESC]), 17, "Market & Product", 2, "Product", 3), ("Corp EN", NAMEOF('Dim_PackInfo'[CORP_DES]), 19, "Market & Product", 2 , "Corp", 1), ("Corp CN", NAMEOF('Dim_PackInfo'[CORP_DES_C]), 20, "Market & Product", 2 , "Corp", 1), ("Corp Type", NAMEOF(Dim_PackInfo[CORP_TYPE]), 21, "Market & Product", 2 , "Corp", 1), ("Manufacturer", NAMEOF(Dim_PackInfo[MANU_DES]), 22, "Market & Product", 2 , "Corp", 1), // ("TA", NAMEOF('Dim_MarketTA'[TA]), 23, "Market & Product", 2 , "Market", 2), ("Brand CN", NAMEOF('Dim_PackInfo'[PROD_DES_C]), 30, "Market & Product", 2, "Product", 3), ("Brand EN", NAMEOF('Dim_PackInfo'[PROD_DES]), 31, "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), ("Originator/Generics", NAMEOF(Dim_PackInfo[GENE_ORIG_DESC]), 36, "Market & Product", 2, "Product", 3), ("VBP", NAMEOF(Dim_PackInfo[VBP_DESC]), 37, "Market & Product", 2, "VBP", 4), ("VBP_BATCH", NAMEOF('Dim_PackInfo'[VBP_BATCH]), 38, "Market & Product", 2, "VBP", 4), ("VBP_IMPLEMENTING_TIME", NAMEOF('Dim_PackInfo'[VBP_IMPLEMENTING_TIME]), 39, "Market & Product", 2, "VBP", 4), ("ATC1", NAMEOF(Dim_PackInfo[ATC1_CODE_DESC]), 40, "Market & Product", 2, "ACT", 6), ("ATC2", NAMEOF(Dim_PackInfo[ATC2_CODE_DESC]), 41, "Market & Product", 2, "ACT", 6), ("ATC3", NAMEOF(Dim_PackInfo[ATC3_CODE_DESC]), 42, "Market & Product", 2, "ACT", 6), ("ATC4", NAMEOF(Dim_PackInfo[ATC4_CODE_DESC]), 43, "Market & Product", 2, "ACT", 6), ("NFC1", NAMEOF(Dim_PackInfo[APP1_COD_DES_C]), 44, "Market & Product", 2, "NFC", 7), ("NFC2", NAMEOF(Dim_PackInfo[APP2_COD_DES_C]), 45, "Market & Product", 2, "NFC", 7), ("NFC3", NAMEOF(Dim_PackInfo[APP3_COD_DES_C]), 46, "Market & Product", 2, "NFC", 7), ("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_en]), 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", NAMEOF('Dim_Org'[RC_Name]), 77, "Organization", 4, "Org", 3), ("RSM", NAMEOF('Dim_Org'[RSM_Name]), 78, "Organization", 4, "Org", 3), ("DSM", 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]), 90, "Channel", 5, "Channel", 5), ("Ins Name", NAMEOF('Dim_Institution'[inst_name]), 100, "Ins", 6, "Ins", 1), ("Ins Code", NAMEOF('Dim_Institution'[INST_CODE]), 101, "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 Value", NAMEOF('Dim_HP_Potential_AIA'[potential_value]), 104, "Ins", 6, "Potential", 2), ("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), ("Is Default Potential MKT", NAMEOF('Dim_HP_Potential_AIA'[IS_DEFAULT_POTENTIAL_MKT]), 107, "Ins", 6, "Potential", 2), ("Is Default Potential Type", NAMEOF('Dim_HP_Potential_AIA'[IS_DEFAULT_POTENTIAL_TYPE]), 108, "Ins", 6, "Potential", 2), ("Decile", NAMEOF('Dim_HP_Potential_AIA'[decile]), 109, "Ins", 6, "Decile", 3), -- 注：该字段不能修改顺序，如修改顺序，要同步更改指标External.Sales.KPI和External.Sales.LY.KPI ("Decile Group", NAMEOF('Dim_HP_Potential_AIA'[decile_group]), 110, "Ins", 6, "Decile", 3), --注： 该字段不能修改顺序，如修改顺序，要同步更改指标External.Sales.KPI和External.Sales.LY.KPI ("Target HP", NAMEOF(Dim_RC[IS_TARGET_HP]), 111, "Ins", 6, "flag", 4), ("KA Ins", NAMEOF(Dim_RC[KA_FLAG]), 112, "Ins", 6, "flag", 4), ("Target Ins Level", NAMEOF(Dim_HP_Potential_AIA[target_ins_level]), 113, "Ins", 6, "flag", 4), ("EG Project Name", NAMEOF(Dim_IsEagle_AIASpecial[is_eagle]), 114, "Ins", 6, "flag", 4), ("Is Default Flag ", NAMEOF('Dim_HP_Potential_AIA'[IS_DEFAULT_MKT_FLAG]), 115, "Ins", 6, "Potential", 2), ("STGH DESC", NAMEOF('Dim_PackInfo'[STGH_DES]), 130, "More Fields", 7, "IQVIA", 8), ("BIO DESC", NAMEOF('Dim_PackInfo'[BIO_DESC]), 131, "More Fields", 7, "IQVIA", 8), ("ETH OTC DESC", NAMEOF('Dim_PackInfo'[ETH_OTC_DESC]), 132, "More Fields", 7, "IQVIA", 8), ("NRDL DESC", NAMEOF('Dim_PackInfo'[NRDL_DESC]), 133, "More Fields", 7, "IQVIA", 8), ("NRDL EntryDate", NAMEOF('Dim_PackInfo'[NRDL_ENTRY_DATE]), 134, "More Fields", 7, "IQVIA", 8), ("EDL DESC", NAMEOF('Dim_PackInfo'[EDL_DESC]), 135,"More Fields", 7, "IQVIA", 8), ("TCM DESC", NAMEOF('Dim_PackInfo'[TCM_DESC]), 136, "More Fields", 7, "IQVIA", 8), ("Manufacturer Code", NAMEOF('Dim_PackInfo'[MANU_COD]), 137, "More Fields", 7, "IQVIA", 8), ("Manufacturer中文", NAMEOF('Dim_PackInfo'[MANU_C]), 138, "More Fields", 7, "IQVIA", 8), ("PAED DESC", NAMEOF('Dim_PackInfo'[PAED_DESC]), 139, "More Fields", 7, "IQVIA", 8), ("GQCE DESC", NAMEOF('Dim_PackInfo'[GQCE_DESC]), 140, "More Fields", 7, "IQVIA", 8), ("MNFL Code", NAMEOF('Dim_PackInfo'[MNFL_COD]), 141, "More Fields", 7, "IQVIA", 8), // ("MNFL_DES", NAMEOF('Dim_PackInfo'[MNFL_DES]), 142, "More Fields", 7, "IQVIA", 8), ("Molecule Code", NAMEOF('Dim_PackInfo'[CMPS_COD]), 143, "More Fields", 7, "Product", 2), ("Corp Code", NAMEOF('Dim_PackInfo'[CORP_COD]), 144, "More Fields", 7 , "Product", 2), ("Brand Code", NAMEOF('Dim_PackInfo'[PROD_COD]), 145, "More Fields", 7, "Product", 2), ("Brand Corp", NAMEOF(Dim_PackInfo[PROD_CORP_C]), 146, "More Fields", 7, "Product", 2), ("ATC1 DES", NAMEOF('Dim_PackInfo'[ATC1_DES]), 147, "More Fields", 7, "Product", 2), ("ATC2 DES", NAMEOF('Dim_PackInfo'[ATC2_DES]), 148, "More Fields", 7, "Product", 2), ("ATC3 DES", NAMEOF('Dim_PackInfo'[ATC3_DES]), 149, "More Fields", 7, "Product", 2), ("ATC4 DES", NAMEOF('Dim_PackInfo'[ATC4_DES]), 150, "More Fields", 7, "Product", 2), ("NFC1 DES", NAMEOF('Dim_PackInfo'[APP1_DES]), 151, "More Fields", 7, "Product", 2), ("NFC2 DES", NAMEOF('Dim_PackInfo'[APP2_DES]), 152, "More Fields", 7, "Product", 2), ("NFC3 DES", NAMEOF('Dim_PackInfo'[APP3_DES]), 153, "More Fields", 7, "Product", 2), ("Org Manufacturer", NAMEOF('Dim_Original_Col_AIA'[org_manu_nm]), 170, "AIA原始字段", 9, "Manufacturer", 1), ("Org Manufacturer Product", NAMEOF('Dim_Original_Col_AIA'[org_manu_prd_nm_c]), 171, "AIA原始字段", 9, "Manufacturer", 1), ("Org Product Code", NAMEOF('Dim_Original_Col_AIA'[org_prd_cd]), 172, "AIA原始字段", 9, "Product", 2), ("Org Package", NAMEOF('Dim_Original_Col_AIA'[org_pk]), 173, "AIA原始字段", 9, "Product", 2), ("Org Pack Unit", NAMEOF('Dim_Original_Col_AIA'[org_pk_unit]), 174, "AIA原始字段", 9, "Product", 2), ("Org Product Name", NAMEOF('Dim_Original_Col_AIA'[org_prd_nm_c]), 175, "AIA原始字段", 9, "Product", 2), ("Org Product Desc", NAMEOF('Dim_Original_Col_AIA'[org_prd_str]), 176, "AIA原始字段", 9, "Product", 2), ("Org Path", NAMEOF('Dim_Original_Col_AIA'[org_pth]), 177, "AIA原始字段", 9, "Product", 2), ("ACT1", NAMEOF('Dim_Original_Col_AIA'[ATC1]), 178, "AIA原始字段", 9, "ACT", 3), ("ACT2", NAMEOF('Dim_Original_Col_AIA'[ATC2]), 179, "AIA原始字段", 9, "ACT", 3), ("ACT3", NAMEOF('Dim_Original_Col_AIA'[ATC3]), 180, "AIA原始字段", 9, "ACT", 3), ("ACT4", NAMEOF('Dim_Original_Col_AIA'[ATC4]), 181, "AIA原始字段", 9, "ACT", 3), ("HP Year", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[year]), 200, "NON-SALES INS", 11, "time", 1), ("Hospital Code", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[az_ins_code]), 201, "NON-SALES INS", 11, "hp", 2), ("CPA HP Code", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[cpa_ins_code]), 202, "NON-SALES INS", 11, "hp", 2), ("Hospital Name", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[az_ins_name]), 203, "NON-SALES INS", 11, "hp", 2), ("Jan.", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[January]), 204, "NON-SALES INS", 11, "time", 1), ("Feb.", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[February]), 205, "NON-SALES INS", 11, "time", 1), ("Mar.", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[March]), 206, "NON-SALES INS", 11, "time", 1), ("Apr.", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[April]), 207, "NON-SALES INS", 11, "time", 1), ("May", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[May]), 208, "NON-SALES INS", 11, "time", 1), ("Jun.", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[June]), 209, "NON-SALES INS", 11, "time", 1), ("Jul.", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[July]), 210, "NON-SALES INS", 11, "time", 1), ("Aug.", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[August]), 211, "NON-SALES INS", 11, "time", 1), ("Sep.", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[September]), 212, "NON-SALES INS", 11, "time", 1), ("Oct.", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[October]), 213, "NON-SALES INS", 11, "time", 1), ("Nov.", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[November]), 214, "NON-SALES INS", 11, "time", 1), ("Dec.", NAMEOF('DM_AIA_TD_HOSPITAL_NOT_PROVIDED'[December]), 215, "NON-SALES INS", 11, "time", 1), ("ㅤ", NAMEOF('AIA.Measures'[Hidden Field]), 1000, "Keep this check box", 100, "Keep this check box", 100) --*******AIA 不需要这几张表的字段，注释掉 By Yuni, 2024/10/10************** // ("Platform(EC)", NAMEOF(Dim_PlatformMID[PLATFORM_TYPE]), 41), // ("Store Type(EC)", NAMEOF(Dim_StoreTypeMID[STORE_TYPE]), 42), // ("Store Name(EC)", NAMEOF(Dim_Store[STORE_NAME]), 43), // ("产品ID", NAMEOF('Dim_PackInfo_Retail'[product_id]), 44), // ("OTC/RX", NAMEOF('Dim_PackInfo_Retail'[prescription_nature]), 45), // ("中西药", NAMEOF('Dim_PackInfo_Retail'[medicine_type]), 46), // ("细分1", NAMEOF('Dim_PackInfo_Retail'[zk_medicine_tier1]), 47), // ("细分2", NAMEOF('Dim_PackInfo_Retail'[zk_medicine_tier2]), 48), // ("细分3", NAMEOF('Dim_PackInfo_Retail'[zk_medicine_tier3]), 49), // ("细分4", NAMEOF('Dim_PackInfo_Retail'[zk_medicine_tier4]), 50), // ("通用名", NAMEOF('Dim_PackInfo_Retail'[common_name]), 51), // ("剂型", NAMEOF('Dim_PackInfo_Retail'[dosage_form]), 52), // ("对象", NAMEOF('Dim_PackInfo_Retail'[user_type]), 53), // ("品名", NAMEOF('Dim_PackInfo_Retail'[category_name]), 54), // ("商品名", NAMEOF('Dim_PackInfo_Retail'[product_name]), 55), // ("品牌", NAMEOF('Dim_PackInfo_Retail'[brand_name]), 56), // ("厂家", NAMEOF('Dim_PackInfo_Retail'[zk_manu_des]), 57), // ("集团权益", NAMEOF('Dim_PackInfo_Retail'[zk_corp_des]), 58), // ("规格", NAMEOF('Dim_PackInfo_Retail'[zk_pack_des]), 59), -- ********************************************************************** // ("Dept Name", NAMEOF(Dim_PackInfo[dept_name]), 61, "Market & Product", 2), // ("Key Department", NAMEOF(Dim_MKTPackMapping[CORE_DEPT]), 62, "Market & Product", 2), // // ("XIEHE_AREA", NAMEOF('Dim_PackInfo'[area]), 62, "Market & Product", 2), // ("XH Data医院级别", NAMEOF('Dim_PackInfo'[h_level]), 63, "Market & Product", 2), // ("XH Data报销", NAMEOF('Dim_PackInfo'[reimburse]), 65, "Market & Product", 2), // // ("XIEHE_报销类型", NAMEOF('Dim_PackInfo'[reimburse_type]), 66, "Market & Product", 2), // ("XH Data来源", NAMEOF('Dim_PackInfo'[prescription_source]), 67, "Market & Product", 2), // // ("XIEHE_ATC", NAMEOF('Dim_PackInfo'[atc]), 68, "Market & Product", 2), // // ("XIEHE_新Code", NAMEOF('Dim_PackInfo'[new_code]), 69, "Market & Product", 2), // ("XH Data通用名", NAMEOF('Dim_PackInfo'[common_name]), 70, "Market & Product", 2), // ("XH Data商品名称", NAMEOF('Dim_PackInfo'[product_name]), 71, "Market & Product", 2), // ("XH Data厂家", NAMEOF('Dim_PackInfo'[manu_des_xiehe]), 72, "Market & Product", 2), // ("XH Data规格", NAMEOF('Dim_PackInfo'[pack_des_xiehe]), 73, "Market & Product", 2), // ("XH Data给药途径", NAMEOF('Dim_PackInfo'[drug_delivery_route]), 74, "Market & Product", 2), // ("XH Data剂型", NAMEOF('Dim_PackInfo'[nfc]), 75, "Market & Product", 2), } ``` annotation PBI_Id = ec914debcdca465284a338f9e5ea6f87