11 Replies Latest reply on Sep 23, 2016 5:47 PM by Christian Berg

    OBIEE cast null as double precision

    dileraco

      Hello everybody,

       

      I try to create a business model and there are 2 facts and 3 dims.

       

      Connections are here;

       

      - Fact A --> Dim A, Dim B

      - Fact B --> Dim A, Dim C

       

      Also, I create logical level based dimensions for Dim A, Dim B, and Dim C. Then set content level of fact tables as;

       

      Fact A --> Dim A, Dim B in detail level, Dim C total level

      Fact B --> Dim A, Dim C in detail level, Dim B total level

       

      After these settings, I create an analysis and put columns as;

       

      Dim A (which is month), Fact A (one measure: sum aggregated), Fact B (one measure sum aggregate)

       

      This works! I can see the results.

       

      However, when I add an extra attribute column from Fact A (for example TYPE columns), Fact B column seen as NULL

       

      When I see the physical code, it says: cast null as double precision

       

      What can be the problem here?

       

      Regards,

      Dilek