1 Reply Latest reply: Sep 16, 2013 1:35 AM by 1035431 RSS

    Incorrectly defined logical table source in rpd




      I'm very new to rpd building and started with the below model


      F1 >----D1------<F2


      Fact 1 is joined to Dim 1 and the same Dim 1 is joined to Fact 2. With this model in physical & BMM Layer I built rpd and deployed.


      In answers I picked 1 column from each of these three tables and getting the below error.


      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 15018] Incorrectly defined logical table source (for fact table FACT_SALES) does not contain mapping for [DIM_LOCATION.LOC_NAME]. (HY000)

      Seems, I'm missing some basic rule in building rpd, any help will be great.