OBIEE Query Log

OBIEE Query Log

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

2. Click the Diagnostics tab.

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.

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

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

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

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

. Click Search.

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

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.

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.