mobileNavlogo
headerlogo

Set Up Query Logging in OBIEE

12 October, 2020

Ratings

Related Blogs

 

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

 

 

These core tutorials will help you to learn the fundamentals of OBIEE 11g.  For an in-depth understanding and practical experience, explore "OBIEE 11g Training".

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

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 an in-depth understanding of OBIEE click on

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .