Problem defining Complex Join in Physical Layer
I have a problem defining a complex join in the Physical Layer.
I have the following two tables:
DIM_ORG
Id_Org
DT_Start
DT_End
Org_Name
FACT_REV
Id_org
Revenue
The DIM_ORG tabel is SCD type 2. The current/active Org_Name can be identified in the tabel because DT_End will be empty.
Using the Expression Builder to setup the Physical join I’ve entered the following expression:
DIM_ORG.Id_Org =FACT_REV.Id_Org AND DIM_ORG.DT_End IS NULL
The Expression Builder accepts the syntax, but when I want to close the Physical Foreign key window I get the message:
[nQSError: 30001] Only columns, designated predicates and operators are allowed.
Any suggestions how to resolve this? Am I just missing something? All I want to do is setup a join to pick up the active Org_Name from my dimension.
Thanks for your help!