Set Up Query Logging in OBIEE

Set Up Query Logging

1 . Return to the Administration Tool, which should still be open.

2 . Select File > Open > Online to open the repository in online mode. You use online mode to view and modify a repository while it is loaded into the Oracle BI Server. The Oracle BI Server must be running to open a repository in online mode.

1

3 . Enter BISAMPLE1 as the repository password and enter your administrative user name and password.

1

4 . Click Open to open the repository in online mode.

1

5 . Select Manage > Identity to open Identity Manager.

1

6 . In the left pane, select BI Repository.

1

7 . Select Action > Set Online User Filter.

1

8 . Enter an asterisk and click OK to fetch users from the identity store.

1

9 . In the right pane, double-click your administrative user to open the User dialog box. In this example the administrative user is weblogic.

1

10 . In the User dialog box, on the User tab, set Logging level to 2.

1

Interested in mastering OBIEE Training? Enroll now for FREE demo on OBIEE Training.

11 . Click OK to open the Check Out Objects dialog box.

1

12 . In the Check Out Objects dialog box, click Check Out. When you are working in a repository open in online mode, you are prompted to check out objects when you attempt to perform various operations.

13 . Select Action > Close to close Identity Manager.

14 . Select File > Check In Changes. Alternatively, you can click the Check In Changes icon on the toolbar.

1

15 . Save the repository. There is no need to check consistency.

1

16 . Select File > Copy As to save a copy of the online repository with the security changes.

1

17 . In the Save Copy As dialog box, save the file as BISAMPLE.rpd, replacing the existing BISAMPLE repository.

1

18 . Click Yes when asked if you want to replace the existing BISAMPLE repository. This will create a new BISAMPLE repository with query logging set for the weblogic user.

1

19 . Select File > Close to close the repository.

1

20 . Click OK when you receive the following message:

"In order for your online changes to take effect, you will have to manually restart each nonmaster Oracle BI Server instance in the cluster."

1

21 . Leave the Administration Tool open.

For indepth understanding of OBIEE click on