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. |
No comments:
Post a Comment