mobileNavlogo
headerlogo

OBIEE Query Log

Blog Author

Tekslate

Published Date

12th October, 2020

Ratings

Views

1067

  • Share this blog :

 

OBIEE Query Log

1 . Return to Fusion Middleware Control, which should still be open.

2. Click the Diagnostics tab.

2

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 . Click the Log Messages sub tab.

2

4 . Scroll to the bottom of the window to the View / Search Log Files section.

2

5 . Click Server Log to navigate to the Log Messages screen.

2

6 . In the Log Messages screen, leave the data range set to Most Recent, 1 Days. Deselect all message types except for Trace.

2

7 . In the Message field, enter sending a query to the database.

2

. Click Search.

2

9 . Select the last message in the list. This is the most recent query sent to the database.

2

10 . In the bottom pane, click the Collapse Pane button (arrow on the right side) to view the log message. Your results should look similar to the screenshot. The screenshot shows only a partial view of the log.

2

Notice that both D3 Customer and D4 Address are accessed. The presentation columns included in the analysis were selected from two different presentation tables: Customers and Customer Regions. Both of these presentation tables map to the same logical table, D3 Customer. The D3 Customer logical table maps to two physical sources: D3 Customer and D4 Address.

11. Click the Restore Pane button.

12. Leave Enterprise Manager 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 .

Related Blogs

Write For Us