Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE is forming two queries

Deepak_R-OracleSep 30 2019 — edited Oct 7 2019

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.

This post has been answered by Deepak_R-Oracle on Oct 7 2019
Jump to Answer

Comments

SH_INT
Answer

What the message is telling you is that you cannot delete a Category when there may be other users on the system. You need to apply the System Lock to kick off all non admin users and then delete the Category. The System Lock is the right most option in the POV bar (it will either display Open or Locked). Double click on it, then Lock the system and you will then be able to delete the Category (you will need to be logged in as an administrator to do this)

Marked as Answer by 998158 · Sep 27 2020
998158

Thanks SH for the solution

1 - 2