This discussion is archived
3 Replies Latest reply: May 13, 2013 1:19 PM by 875076 RSS

display non existent data through union in obiee answers

875076 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points