3 Replies Latest reply: May 13, 2013 3:19 PM by 875076 RSS

    display non existent data through union in obiee answers

    875076
      Hi All,

      Did anyone tried using dummy fact table to display non existent data in BMM layer where there is dimension hierarchy tables? If I remove the dimension hierarchy tables, then I can display all the records using the column from the dummy fact table which has Cartesian joins with the dimensions. Is there a work around for this issue?
      Thanks,

      Sushil

      Edited by: 872073 on May 13, 2013 10:25 AM