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.
3 . Enter BISAMPLE1 as the repository password and enter your administrative user name and password.
4 . Click Open to open the repository in online mode.
5 . Select Manage > Identity to open Identity Manager.
6 . In the left pane, select BI Repository.
7 . Select Action > Set Online User Filter.
8 . Enter an asterisk and click OK to fetch users from the identity store.
9 . In the right pane, double-click your administrative user to open the User dialog box. In this example the administrative user is weblogic.
10 . In the User dialog box, on the User tab, set Logging level to 2.
Interested in mastering OBIEE Training? Enroll now for FREE demo on OBIEE Training.
11 . Click OK to open the Check Out Objects dialog box.
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.
15 . Save the repository. There is no need to check consistency.
16 . Select File > Copy As to save a copy of the online repository with the security changes.
17 . In the Save Copy As dialog box, save the file as BISAMPLE.rpd, replacing the existing BISAMPLE repository.
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.
19 . Select File > Close to close the repository.
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."
21 . Leave the Administration Tool open.
For indepth understanding of OBIEE click on