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

    Incorrectly defined logical table source in rpd

    user3263022

      Hi

       

      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.