• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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

Summary
Review Date
Reviewed Item
Set Up Query Logging in OBIEE
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Set Up Query Logging in OBIEE"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.