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

No comments:

Post a Comment

Popular Posts