OBIEE Query Log
1 . Return to Fusion Middleware Control, which should still be open.
2 . Click the Diagnostics tab.
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.
Interested in mastering OBIEE Training? Enroll now for FREE demo on OBIEE Training.
7 . In the Message field, enter sending query to 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.
For indepth understanding of OBIEE click on