relationship 498db3bf-c273-4468-8f2b-68cdc88a016e joinOnDateBehavior: datePartOnly fromColumn: refresh_time.'Refresh Time' toColumn: LocalDateTable_f977bf82-2b39-42bf-9a54-101485fb4765.Date relationship 144c862d-3101-41a8-a99b-6a78192fa4d3 fromColumn: Fact_Sales_Total.DATA_SOURCE toColumn: Dim_DataSource.DATA_SOURCE relationship 42a44f36-e0a4-4b98-b1d9-6774fabda846 joinOnDateBehavior: datePartOnly fromColumn: Dim_Calendar_Alt.DATE toColumn: LocalDateTable_5fbef699-2187-4467-b846-76fb159e8318.Date relationship 2b3a19ec-b7bb-441d-aa89-b2611c56dd2f fromColumn: Fact_Sales_Total.DATE_KEY toColumn: Dim_Calendar.DATE relationship eb469dda-81e6-4bef-b50c-b535b118982b fromColumn: Fact_Sales.DATE_KEY toColumn: Dim_Calendar.DATE relationship f189ff00-3e1e-380b-af1d-e703b665ec29 toCardinality: many fromColumn: Dim_Market.MKT_SOURCE toColumn: Dim_MarketTA.MKT_SOURCE relationship fb6217e5-a08d-ea69-c2a5-9e8885223f92 fromColumn: Dim_MKTPackMapping.MKT_SOURCE toColumn: Dim_Market.MKT_SOURCE relationship 0547801f-fc04-3da9-527d-6dab683dd0ea toCardinality: many fromColumn: Dim_Market_Total.MKT_SOURCE toColumn: Dim_MarketTA_Total.MKT_SOURCE relationship 6f5cdccf-156c-3665-3355-19fd0e2ec250 toCardinality: many fromColumn: Dim_Market.MKT_SOURCE toColumn: Dim_BrandDefaultMKT.MKT_SOURCE relationship dbeea317-9fd2-18d5-e740-070e4833895d fromColumn: Dim_MKTPackMapping_Total.MKT_SOURCE toColumn: Dim_Market_Total.MKT_SOURCE relationship a1493a4b-3001-a31c-bce3-b1acff1158b0 fromColumn: Fact_Retail.DATE_KEY toColumn: Dim_Calendar.DATE relationship dbfdf500-3bcb-6dc9-7599-f25b96878479 fromColumn: Fact_Retail_Total.CORP_COD toColumn: Dim_Corp.CORP_COD relationship f1b0c08a-eccb-87c0-dee2-fb3a3943479f fromColumn: Fact_Retail_Total.DATE_KEY toColumn: Dim_Calendar.DATE relationship 072ecc91-7938-4369-0377-200023eb2fc3 fromColumn: Fact_Retail_Total.DATA_SOURCE toColumn: Dim_DataSource.DATA_SOURCE relationship a400a669-a82c-0b77-4d12-a115443653d7 fromColumn: Fact_EC_Total.CORP_COD toColumn: Dim_Corp.CORP_COD relationship 6e4c2542-b5ef-4249-e72b-29b9503f0d4d fromColumn: Fact_EC_Total.DATE_KEY toColumn: Dim_Calendar.DATE relationship 88c4604a-d06b-eaa5-dd5f-e074eb117ce2 fromColumn: Fact_EC_Total.DATA_SOURCE toColumn: Dim_DataSource.DATA_SOURCE relationship c87ed394-fd1e-c280-03d8-165a9da170bd fromColumn: Fact_EC.CORP_COD toColumn: Dim_Corp.CORP_COD relationship 42f29166-3e3c-29aa-49d1-f297a392bb83 fromColumn: Fact_EC.DATE_KEY toColumn: Dim_Calendar.DATE relationship 6dd7cf4d-1881-2891-0234-d1e79aa0dcf1 fromColumn: Fact_Retail_RawData.DATE_KEY toColumn: Dim_Calendar.DATE relationship d74215e9-ff50-e8c5-7997-37eb9c9a9c03 fromColumn: Fact_Retail.PACK_SOURCE toColumn: Dim_PackInfo.PACK_SOURCE relationship b53a29c7-a806-c5d2-6f74-ea23f8fd8f4f crossFilteringBehavior: bothDirections fromColumn: Dim_MKTPackMapping_Total.PACK_SOURCE toColumn: Dim_PackInfo_Total.PACK_SOURCE relationship 1dd39926-1ad7-4fed-a2db-c0ce25178820 fromColumn: Fact_Sales_Total.PACK_SOURCE toColumn: Dim_PackInfo_Total.PACK_SOURCE relationship 038051a0-c402-27e8-62c8-61818dd6b3c3 fromColumn: Fact_Sales.PACK_SOURCE toColumn: Dim_PackInfo.PACK_SOURCE relationship 3260526a-a06a-0852-3e57-ab652f006059 crossFilteringBehavior: bothDirections fromColumn: Dim_Platform.PLATFORM_TYPE_SOURCE toColumn: Dim_PlatformMID.PLATFORM_TYPE_SOURCE relationship fde1223e-740e-7586-1bcf-294fe75e91be crossFilteringBehavior: bothDirections fromColumn: Dim_StoreType.STORE_TYPE_SOURCE toColumn: Dim_StoreTypeMID.STORE_TYPE_SOURCE relationship e21f6ab7-b690-fccd-8cf2-c9340f08ae3b fromColumn: Fact_Sales_Total.STORE_TYPE_SOURCE toColumn: Dim_StoreTypeMID.STORE_TYPE_SOURCE relationship 66d7a43b-d810-bf8a-9e1a-df4f3565a483 fromColumn: Fact_Sales_Total.PLATFORM_TYPE_SOURCE toColumn: Dim_PlatformMID.PLATFORM_TYPE_SOURCE relationship 7bed0334-1560-02f9-5b60-c4d18f9c5022 fromColumn: Fact_EC_Total.STORE_TYPE_SOURCE toColumn: Dim_StoreTypeMID.STORE_TYPE_SOURCE relationship c3184a86-fc8f-d284-bd49-31d8315d4bba fromColumn: Fact_EC_Total.PLATFORM_TYPE_SOURCE toColumn: Dim_PlatformMID.PLATFORM_TYPE_SOURCE relationship 6c417c05-760b-ed58-7f9b-0ac42fd8fe68 fromColumn: Fact_EC.STORE_TYPE_SOURCE toColumn: Dim_StoreTypeMID.STORE_TYPE_SOURCE relationship 3b22ccf1-310c-abb2-c667-ce35f3302afa fromColumn: Fact_EC.PLATFORM_TYPE_SOURCE toColumn: Dim_PlatformMID.PLATFORM_TYPE_SOURCE relationship 2e91292f-ad43-9957-8b21-359df82e3e77 toCardinality: many fromColumn: Fact_Sales_Total.REGION_TYPE toColumn: Dim_RegionType.REGION_TYPE relationship 32f3f99e-487d-2418-dce4-d12e4412d685 fromColumn: Dim_MKTPackMapping.CLASS_SOURCE toColumn: Dim_Class.CLASS_SOURCE relationship facc037d-b23d-3f17-35c4-792d4c2b7ac0 fromColumn: Fact_Sales.AUDIT_KEY toColumn: Dim_Geo.AUDIT_KEY relationship b921a09b-1c48-bcfc-28dd-b2f384f714dd fromColumn: Fact_Sales.HP_SOURCE toColumn: Dim_HPFlag.HP_SOURCE relationship 39d7248b-e1f6-e8f4-9fb0-c0ef428c4c55 toCardinality: many fromColumn: Fact_Sales.INST_SOURCE toColumn: Dim_InsSalesType.INS_SOURCE relationship b2d23a46-9d2a-6a0b-29de-3db6cc2ecce2 fromColumn: Fact_Sales.PLATFORM_TYPE_SOURCE toColumn: Dim_PlatformMID.PLATFORM_TYPE_SOURCE relationship c902786f-dea0-7a4d-cb9a-34302034fd5c fromColumn: Fact_Sales.STORE_NAME toColumn: Dim_Store.STORE_NAME relationship 02ad8a9b-c132-0ab0-0a09-3037cef436a4 fromColumn: Fact_Sales.STORE_TYPE_SOURCE toColumn: Dim_StoreTypeMID.STORE_TYPE_SOURCE relationship 180235a4-7288-6615-7b0e-62ab25528bd7 toCardinality: many fromColumn: Dim_Geo.AUDIT_KEY toColumn: Dim_GeoGroup.AUDIT_KEY relationship e041a2d9-58f1-b214-9092-7ddc806c6b2b fromColumn: Dim_CoreDept.MKT_SOURCE toColumn: Dim_Market.MKT_SOURCE relationship 025e31e4-4ff6-32d0-000d-0d690345aca4 fromColumn: Fact_Sales.DEPT_SOURCE toColumn: Dim_Dept.DEPT_SOURCE relationship 0c9a0b32-00eb-8ee9-69f0-73ab3491188d fromColumn: Fact_EC.DATA_SOURCE toColumn: Dim_DataSource.DATA_SOURCE relationship ceec0f68-243e-168a-3e7e-b7b7afbed7b6 fromColumn: Fact_Retail_RawData.DATA_SOURCE toColumn: Dim_DataSource.DATA_SOURCE relationship 4bc612b3-ed74-b4ac-fd4a-77d3d0408fa4 fromColumn: Fact_Retail.AUDIT_KEY toColumn: Dim_Geo.AUDIT_KEY relationship 6eedc7e8-61b7-1671-be24-f95a2c9be918 fromColumn: Fact_Sales.LEVEL_SOURCE toColumn: Dim_HP_Level.LEVEL_SOURCE relationship 94d03aab-6386-35c6-0d96-22409cdde7e4 fromColumn: Fact_Sales.PRESCRIPTION_SOURCE toColumn: Dim_PrescriptionSource.PRESCRIPTION_SOURCE relationship 85d14b78-4e8c-16ba-ca85-909ee0ee3667 fromColumn: Fact_Sales.REIMBURSE_SOURCE toColumn: Dim_Reimburse.REIMBURSE_SOURCE relationship 9b2e831d-778e-29c0-7ebe-478ce836de67 fromColumn: Fact_Sales.REIMBURSETYPE_SOURCE toColumn: Dim_ReimburseType.REIMBURSETYPE_SOURCE relationship 22cd42ef-4616-0ab8-2cc5-6667a1fd6449 toCardinality: many fromColumn: Dim_PackInfo.PACK_SOURCE toColumn: Dim_PackInfo_Retail.PACK_SOURCE relationship 2d4696d9-7c88-1014-2b38-0233fd151a8b toCardinality: many fromColumn: Dim_HPFlag.HP_SOURCE toColumn: Dim_HPFlag_AIASpecial.HP_SOURCE relationship 333cf1a6-d884-e4e6-1d16-c3eeb0e2ed34 toCardinality: many fromColumn: Dim_InsSalesType.PROVIDED_SOURCE toColumn: Dim_InsSalesType_AIASpecial.PROVIDED_SOURCE relationship 36dca656-bc97-5d80-14c2-284c69daa46d crossFilteringBehavior: bothDirections fromColumn: Dim_InsSalesType.INS_SOURCE toColumn: Dim_InsSalesTypeKey_AIA.INS_SOURCE relationship 6ef24432-3c48-70ec-c5d4-b3c772c991df toCardinality: many fromColumn: DM_AIA_TD_HOSPITAL_NOT_PROVIDED.year toColumn: Dim_Calendar.YEAR relationship a651afe5-a3a9-e8c9-4260-4a8704e86dac toCardinality: many fromColumn: Dim_PackInfo.PACK_SOURCE toColumn: Dim_Original_Col_AIA.PACK_SOURCE relationship acdc4e80-1ba0-b82f-912e-206fd4399cc5 fromColumn: Dim_PackInfo.CORP_COD toColumn: Dim_Corp.CORP_COD relationship 91373728-f7db-9b9b-7ac8-3da23bb0f9f7 fromColumn: Fact_Sales_THC.DEPT_SOURCE toColumn: Dim_Dept.DEPT_SOURCE relationship 42c3671b-eee9-7667-ad1a-9bdd849206b6 fromColumn: Fact_Sales_THC.PLATFORM_TYPE_SOURCE toColumn: Dim_PlatformMID.PLATFORM_TYPE_SOURCE relationship ffdbc9c2-11d1-3adc-f826-cce8fd04d823 fromColumn: Fact_Sales_THC.PACK_SOURCE toColumn: Dim_PackInfo.PACK_SOURCE relationship b86f3c04-d995-2786-e199-50c6a9c2de01 fromColumn: Fact_Sales_THC.AUDIT_KEY toColumn: Dim_Geo.AUDIT_KEY relationship 841d45aa-bafb-5503-bcf1-982fb5ce7483 fromColumn: Fact_Sales_THC.DATE_KEY toColumn: Dim_Calendar.DATE relationship 1458e9b2-4b66-303a-7f0c-6c287d9c5727 fromColumn: Fact_Sales_THC.STORE_TYPE_SOURCE toColumn: Dim_StoreTypeMID.STORE_TYPE_SOURCE relationship c84daf1c-421a-f682-bb7d-4ba7cae2cb4c toCardinality: many fromColumn: Fact_Sales_THC.INST_SOURCE toColumn: Dim_InsSalesType.INS_SOURCE relationship 3119cbe8-474c-ce5b-a4b0-8e9a4f48cd7b fromColumn: Fact_Sales_THC.LEVEL_SOURCE toColumn: Dim_HP_Level.LEVEL_SOURCE relationship 156c022d-629d-e300-b409-cd4a3a344341 fromColumn: Dim_PackInfo.PROD_DES_C toColumn: AIA_AdvanceAnalysis_Brand.PROD_DES_C relationship 70d1f11c-0c89-3774-0978-55bad0070469 fromColumn: Dim_Class.CLASS toColumn: AIA_AdvanceAnalysis_Class.CLASS relationship d2be952b-eb9e-3e61-f31f-7a61c965b552 fromColumn: Dim_PackInfo.CMPS_DES_C toColumn: AIA_AdvanceAnalysis_Mole.CMPS_DES_C relationship b0af8d11-ed72-7317-7de4-5e7abe48efaf fromColumn: Dim_MKTPackMapping.KEY_COMPETITOR_CN toColumn: AIA_AdvanceAnalysis_Key_Competitor.KEY_COMPETITOR_CN relationship 1106769c-d322-e8cd-103a-2f2ec83c25e6 fromColumn: Dim_HP_Potential_AIA.DECILE_GROUP toColumn: AIA_AdvanceAnalysis_Decile_Group.DECILE_GROUP relationship e816fb27-17f7-fddc-f720-9a7762436cbe fromColumn: Dim_HP_Potential_AIA.DECILE toColumn: AIA_AdvanceAnalysis_Decile.DECILE relationship 4dbee93f-9bb4-d907-221d-6ed0cefb3161 crossFilteringBehavior: bothDirections fromColumn: Dim_IsEagle_AIASpecial.IS_EAGLE_FLAG_CODE toColumn: Dim_IsEagle_Bridge_AIASpecial.IS_EAGLE_FLAG_CODE relationship 1c18fb19-11ff-c9ea-6d4e-7f95392be562 toCardinality: many fromColumn: Dim_RC.ISTARGET_SOURCE toColumn: Dim_IsTarget_AIASpecial.ISTARGET_SOURCE relationship dc0042f2-7788-a667-e968-9ccc4f488024 crossFilteringBehavior: bothDirections fromColumn: Dim_HP_Potential_AIA.INS_MKT_SOURCE toColumn: Dim_InsKey.INS_MKT_SOURCE relationship 024199e3-0154-474c-2660-d607b888aec3 fromColumn: Dim_RC.INS_MKT_SOURCE toColumn: Dim_InsKey.INS_MKT_SOURCE relationship a141ef36-df69-12a5-e416-19f3a73a5acd fromColumn: Dim_RC.mr_trty_code toColumn: Dim_Org.mr_trty_code relationship c455ac61-3135-dfc9-3e8a-8b228767b7a5 fromColumn: Dim_RC.SUB_CHANNEL toColumn: AIA_AdvanceAnalysis_Subchannel.SUB_CHANNEL relationship 168e107c-a8cb-947a-ebbe-d2e202980179 fromColumn: Dim_RC.DRAGON_FLAG toColumn: AIA_AdvanceAnalysis_DRAGON.DRAGON_FLAG relationship 41fd0ee7-2e3d-af44-4605-f6de5a1309f2 fromColumn: Dim_RC.INS_MKT_SOURCE toColumn: Dim_IsEagle_Bridge_AIASpecial.IS_EAGLE_FLAG_CODE relationship 9295335b-4cbc-207f-d21f-7be642c8fd56 crossFilteringBehavior: bothDirections fromColumn: Dim_MKTPackMapping.PACK_SOURCE toColumn: Dim_PackInfo.PACK_SOURCE relationship 6b611437-19d2-fc60-0041-57cf1e0dbfe0 fromColumn: Fact_Sales.INST_SOURCE toColumn: Dim_Institution.INST_SOURCE relationship 4b430b5d-71b8-209e-c9ad-ae09cb5aa711 fromColumn: Dim_MKTPackMapping.DATA_SOURCE toColumn: Dim_DataSource.DATA_SOURCE relationship 4415ee0f-c20b-abfc-3346-518487a3a1c1 fromColumn: Fact_Sales.AUDIT_SOURCE toColumn: Dim_GeoKey.AUDIT_SOURCE relationship 7ea59699-18e2-61ed-4eb7-06f73472444d crossFilteringBehavior: bothDirections fromColumn: Dim_RC.AUDIT_SOURCE toColumn: Dim_GeoKey.AUDIT_SOURCE relationship e78e9f41-580b-363b-4107-4ba9e3c52c7c fromColumn: Fact_Sales_Total_AIA.PACK_SOURCE toColumn: Dim_PackInfo.PACK_SOURCE relationship 39601d48-d1fe-a6df-11f1-0ab3185dc900 fromColumn: Fact_Sales_Total_AIA.DATE_KEY toColumn: Dim_Calendar.DATE relationship 466ab709-dc3b-bc7a-6f77-9483c14ac41e fromColumn: Fact_Sales.DATA_SOURCE toColumn: Dim_DataSource.DATA_SOURCE relationship d2642643-8dee-0dcd-1213-e252b24ce99a fromColumn: Fact_Retail.DATA_SOURCE toColumn: Dim_DataSource.DATA_SOURCE relationship 07976832-8d08-ca44-4d05-bac70825db16 fromColumn: Fact_Sales_THC.DATA_SOURCE toColumn: Dim_DataSource.DATA_SOURCE relationship bd893ccc-a08e-48e1-a804-00aae52d59be joinOnDateBehavior: datePartOnly fromColumn: dm_td_user_permission_detail.etl_insert_dt toColumn: LocalDateTable_4d240239-ee2b-4f9d-91c0-01de4e800b11.Date relationship a269d2da-3109-4ca0-ade4-c66f1c738ede joinOnDateBehavior: datePartOnly fromColumn: dm_td_user_permission_detail.etl_update_dt toColumn: LocalDateTable_3fa9633b-ab47-4d55-9058-c09d735d6003.Date relationship 51590711-f546-b0d7-1cdf-03a7973fa2a5 fromColumn: Fact_Retail_Total.DATA_SOURCE toColumn: Dim_DataSource_ForRLS.DATA_SOURCE relationship c567ff12-fffe-cc6a-bb23-67b505a3b491 fromColumn: Fact_EC.DATA_SOURCE toColumn: Dim_DataSource_ForRLS.DATA_SOURCE relationship 700f3818-fc77-b040-9c61-f9cecaf36284 fromColumn: Fact_Retail.DATA_SOURCE toColumn: Dim_DataSource_ForRLS.DATA_SOURCE relationship 986ab6d2-b895-278d-ce9d-d648c0c8f894 fromColumn: Fact_EC_Total.DATA_SOURCE toColumn: Dim_DataSource_ForRLS.DATA_SOURCE relationship 22d17b1c-7f7d-5200-46b4-f7b7a7093620 fromColumn: Fact_Sales_Total.DATA_SOURCE toColumn: Dim_DataSource_ForRLS.DATA_SOURCE relationship 923362e8-476e-6156-7ff6-e9f014522973 fromColumn: Fact_Sales_THC.DATA_SOURCE toColumn: Dim_DataSource_ForRLS.DATA_SOURCE relationship 2724b646-60c1-d1d3-0343-6ffbe6c685cb fromColumn: Fact_Retail_RawData.DATA_SOURCE toColumn: Dim_DataSource_ForRLS.DATA_SOURCE relationship ef237336-c5b5-5445-4e6a-4e9a3d4c1c64 fromColumn: Fact_Sales.DATA_SOURCE toColumn: Dim_DataSource_ForRLS.DATA_SOURCE relationship 1375fbc8-d685-530f-2d1e-434050110dee fromColumn: Fact_Retail_Special.audit_key toColumn: Dim_Geo.AUDIT_KEY relationship a488d2d3-f82f-406d-5c4d-ac5fd735ebe3 fromColumn: Fact_Retail_Special.date_key toColumn: Dim_Calendar.DATE relationship 5e946534-fbb6-b624-2f17-1b10abbec781 fromColumn: Dim_Market_Total.DATA_SOURCE toColumn: Dim_DataSource.DATA_SOURCE relationship cf63b360-e29c-61e9-96e8-514fa6857dad crossFilteringBehavior: bothDirections toCardinality: many fromColumn: Dim_Market_Total.MKT_SOURCE toColumn: Dim_BrandMKT.MKT_SOURCE relationship 73477bd1-8615-2d4f-4a3d-99b57f53e812 toCardinality: many fromColumn: Dim_BrandMKT.IS_HIDDEN_COUNTY toColumn: Dim_RegionType.IS_HIDDEN_COUNTY relationship 872d65d4-35d8-b990-c89a-0e5664af563d isActive: false fromColumn: Fact_Sales.MERGEDATA_FLAG toColumn: Dim_MergeDataSource.DATA_SOURCE relationship 471a07e5-fa4c-7716-c2d6-32ffa233c243 isActive: false fromColumn: Fact_Sales.MERGEDATA_FLAG_MKT toColumn: Dim_MergeDataSource.DATA_SOURCE relationship b0a71e80-0399-5d9b-ae9b-334216033e0e isActive: false fromColumn: Fact_Sales.MERGEDATA_FLAG_CHAP_DTP_NOAIA toColumn: Dim_MergeDataSource.DATA_SOURCE relationship 8f295e0b-4761-0abb-e005-51d8d5d2448f toCardinality: many fromColumn: Fact_Retail_Special.rc_key toColumn: Dim_RC.rc_key relationship e369a4e6-11ea-c7ed-9f2d-ea5ed1f6316b crossFilteringBehavior: bothDirections fromColumn: Dim_RC_Merged_Data.KEY toColumn: Dim_GeoKey.AUDIT_SOURCE relationship 021f07fe-b2e6-8788-8847-6a522d38806c fromColumn: Fact_AIA_DataQuality.audit_key toColumn: Dim_Geo.AUDIT_KEY relationship 775ab6f7-3e56-7455-134a-44689f127dab crossFilteringBehavior: bothDirections fromColumn: Fact_AIA_DataQuality.audit_key toColumn: Dim_Institution.INST_SOURCE relationship 7a9c7b74-f496-b52e-8d2c-cdada0311f72 fromColumn: Dim_PackInfo_Total.CORP_COD toColumn: Dim_Corp.CORP_COD relationship 0157e28a-5680-2add-15a7-ad5719e92fad crossFilteringBehavior: bothDirections fromColumn: Dim_Remove_inst.AUDIT_KEY toColumn: Dim_GeoKey.AUDIT_SOURCE relationship cc74a2cd-743b-8643-b6ef-4f008c0d652f fromColumn: Fact_Sales_NIAD.DATA_SOURCE toColumn: Dim_DataSource.DATA_SOURCE relationship 4b1081d6-4baa-e757-2984-c80abd604659 fromColumn: Fact_Sales_NIAD.PACK_SOURCE toColumn: Dim_PackInfo.PACK_SOURCE relationship 836d3c55-07b3-d6e7-28ab-dda752554bd2 fromColumn: Fact_Sales_NIAD.AUDIT_SOURCE toColumn: Dim_Geo.AUDIT_KEY relationship 2b825871-d3a9-9d53-0725-fb2eb121b73c fromColumn: Fact_Sales_NIAD.AUDIT_SOURCE toColumn: Dim_GeoKey.AUDIT_SOURCE relationship 3776a832-506c-22f1-7eb5-264c76b6f2ba fromColumn: Fact_Sales_NIAD.DATE_KEY toColumn: Dim_Calendar.DATE