1 2 Previous Next 19 Replies Latest reply on Oct 7, 2019 9:21 AM by Deepak_R-Oracle

    OBIEE is forming two queries


      In OBIEE Whenever any fact table is queried, two queries are issued(one to get distinct dimensions value and another to get fact data). Ideally only one query should be issued but 12c is issuing two queries and then doing full outer join.


      I have fixed all the Hierarchy warnings but still i'm getting the same results any help is greatly appreciated.

        1 2 Previous Next