6 Replies Latest reply: Oct 4, 2013 2:41 PM by Kartik Pasumarty RSS

    Problem defining Complex Join in Physical Layer

    The_Dutchman
      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!