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.