0 Replies Latest reply: Aug 5, 2014 12:06 PM by 2699630 RSS

    Issue with non calculated column in a fact table

    2699630

      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 11.1.1.7 of OBIEE

       

      Let me know if Iam not clear.

       

      Your help is much Appreciated.

       

      Thanks,

      Vineela.