Log files for Oracle Business Intelligence (OBIEE) 11g version.

Using Enterprise Manager

You can check the different log files in the Oracle Business Intelligence (OBIEE) 11g version.
The right way to check them is using the Enterprise Manager (EM) Console page but you can also review the files directly on the hard disk.

a) EM Console. Login to the URL

http://server.domain:7001/em

and navigate to:

Farm_bifoundation_domain-Business Intelligence-coreapplications-Diagnostics-Log Messages

These are all the available files:

Presentation Services Log
Server Log
Scheduler Log
JavaHost Log
Cluster Controller Log
Action Services Log
Security Services Log
Administrator Services Log

************************************************************************

To check the files directly, you can use the following:

1) Admin Server logs.

AdminServer-diagnostic.log

Directory:
$MIDDLEWARE_HOME/user_projects/domains/bifoundation_domain/servers/AdminServer/logs
or
$DOMAIN_HOME/servers/AdminServer/logs

2) Managed Server log
bi_server1-diagnostic.log

Directory:
$MIDDLEWARE_HOME/user_projects/domains/bifoundation_domain/servers/bi_server1/logs
or
$DOMAIN_HOME/servers/bi_server1/logs/

3) Node Manager log files

WL_HOME/common/nodemanager

Example:

D:\OBIEE11G\wlserver_10.3\common\nodemanager
4) BI Componets logs file are under:
$MIDDLEWARE_HOME/instances/instance1/diagnostics
5) OPMN: Oracle Process Manager and Notification Server

All files under the directory:

$MIDDLEWARE_HOME/instances/instanceX/diagnostics/logs/OPMN/opmn
or
$ORACLE_INSTANCE/diagnostics/logs/OPMN/opmn


6) Enterprise Manager Log
emoms.trc

Directory:
$MIDDLEWARE_HOME/user_projects/domains/bifoundation_domain/servers/sysman/log
or
$DOMAIN_HOME/servers/sysman/log

Auto Complete Functionality in Prompts

Available now in OBIEE 11.1.1.6 is the ability for prompts to suggest and highlight matching values as the user types in a value for the prompt.

 At the moment this functionality is limited to Choice lists only, and even then only when you allow the "Enable User to Type Value" checkbox. This you'll find in the prompt properties.

So how do we turn this functionality on, as it doesn't happen out the box.

Step 1.

Edit the instanceconfig.xml file in the \instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1 directory. Between the <serverinstance></serverinstance> tags add the following. 

<prompts>
<maxdropdownvalues>256</maxdropdownvalues>
<autoapplydashboardpromptvalues>true</autoapplydashboardpromptvalues>
<autosearchpromptdialogbox>true</autosearchpromptdialogbox>
<autocompletepromptdropdowns>
<supportautocomplete>true</supportautocomplete>
<caseinsensitive>true</caseinsensitive>
<matchinglevel>MatchAll</matchinglevel>
<resultslimit>50</resultslimit>
</autocompletepromptdropdowns>
</prompts>

This will allow autocomplete and ignore case, returning a list of 50 (at most) matches. 

Step 2.

Restart the BI component either through Enterprise Manager or opmnctl. 

Step 3. 

Now create a prompt ensuring that your settings are similar to those below.

 When you come to test the prompt, enter two or more letters and the dropdown below the prompt should fill. Note that the pattern of letters you enter can occur anywhere in the entries in the list returned, even in the middle of a word.