• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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

Summary
Review Date
Reviewed Item
OBIEE Query Log
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on OBIEE Query Log"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.