Skip to Content
0
Nov 01, 2016 at 08:13 PM

Equijoin not validating in BO 4.1 IDT

83 Views

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?