OBIEE Query Log

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

2 . Click the Diagnostics tab.

2

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

Interested in mastering OBIEE Training? Enroll now for FREE demo on OBIEE Training.

7 . In the Message field, enter sending query to 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 indepth understanding of OBIEE click on