OBIEE 11G 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.
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 non-master Oracle BI Server instance in the cluster."
21 .	Leave the Administration Tool open.