2 Replies Latest reply: Oct 25, 2012 2:29 AM by Maqs-Oracle RSS

    help for business model and mapping

    883915
      hi, for business model and mapping layer, do we need to translate everything to dimensional modelling? So far, to my understanding, relational model should also work to some extend right? Im using BIEE 11g

      In our application, we have a complicated relational DB model (let's say about 30 tables) which is perfectly ok when i import it into the physical layer, i map all the foreign keys as it should be in relational db but when i try to create the analysis with fields from more than 1 tables, it returns error such as : no fact table details enough, a foreign key should exist between...,..

      can u guys help me clarify this?

      Edited by: 880912 on Oct 23, 2012 12:48 AM