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.
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.
For an in-depth understanding of OBIEE click on
- OBIEE 11g Tutorials
- New Features in OBIEE11g
- Checking Out a Project in OBIEE 11g
- Making Changes to the Repository in OBIEE
- Setting Up a Multiuser Development Environment in OBIEE