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

    OBIEE is forming two queries

    4046340

      In OBIEE 12.2.1.3.0 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