0 Replies Latest reply on Aug 5, 2014 5:06 PM by VineelaG6

    Issue with non calculated column in a fact table


      Hi All,


      With 3 facts(Fact1,Fact2,Fact3) and 2 Confirmed Dimensions my joins work fine in Criteria when I include All calculated columns from facts. If I try to include a non calculated column from Fact1(Which is a number Data type) Columns from Fact2 and Fact3 show Null values. I know it is not recommended to include dimension columns in fact , does OBIEE not support Number type non calculated columns as well? Is there any work around that I can bring in my non calculated column from Fact and still get results for other fact columns.Iam at of OBIEE


      Let me know if Iam not clear.


      Your help is much Appreciated.