Monday, February 13, 2012

OBIEE 11g: Supplemental Detail in Log Viewer

One of the major architectural changes between Oracle BI 10g and 11g is the fact that a full scale Oracle Fusion Middleware server now acts as the container for the so called BI instance. All BI services (BI Server, Presentation Server etc.) are now components of the WebLogic domain.

Oracle Enterprise Manager - and the administrative "app" named coreapplication - serve as a central entry point for managing and monitoring all BI services. In the Diagnostic tab of the coreapplication we find links to the EM Log Viewer which provides us with a consolidated view of BI server or presentation server logs.

One of the benefits of the Log Viewer is that we can search across different files on different physical machines. For example, you might be looking for an SQL statement containing a specific physical table name.

Unfortunately, the physical SQL is not reachable by the Message field but in the Supplemental Detail field.

To search for text in this field, we have to click the Add Fields button and check the box for the Supplemental Detail field. As a result, we now have another line to enter search phrases.

Click to enlarge
We can now enter the desired search expression, click the Search button and marvel at the results.

have a nice day


No comments: