I have a UNX universe that was converted from a UNV universe, and in the UNX version I have an equijoin that will not validate. This join will validate in the UNV version of the universe. The problem join is below.
dbo.DMT_AR_SWK_ORG_DIM_VW.SWK_ORG_ID=DMT_AR.dbo.DMT_AR_DYLY_AR_AGRT_FACT_VW.SWK_ORG_ID
Other equijoins using the same tables, and in some cases the same columns, validate just fine.
dbo.DMT_AR_SWK_ORG_DIM_VW.SWK_ORG_ID=dbo.DMT_AR_DYLY_AR_CASH_AGRT_FACT_VW.SWK_ORG_ID
dbo.DMT_AR_HFM_HIER_DIM_VW.HFM_HIER_ID=DMT_AR.dbo.DMT_AR_DYLY_AR_AGRT_FACT_VW.HFM_HIER_ID
The cardinality for all three of these joins is set to 1,n and none of them are shortcut joins. The function to detect cardinality also will not work for the problem join
Any idea why this is happening?