Protect Filter in OBIEE

                   The feature was already there from OBIEE 10g versions. We need to take some extra precautions before applying this in request filters which can be adopted as best practice in report development.

              This ensures that the filter used in the request is not lost or overwritten by another filter or dashboard prompt that may supersede the request.
              This option is only available if a value has been specified in the filter. If the filter item is set to “is prompted” then the Protect Filter option if not available.

To apply it as the filter in the Answers Request:

 Select Filter Options  button> Check the Protect Filter option as seen in the screen below...

And The filter is looks like the this. With the "key" icon on the filter icon to lock the values to restrict the change.

 

How can we find the OBIEE 11g Log Files...

In this post, we are going to see where the log files in OBIEE 11g reside.
In OBIEE 10g, we can check the different log files in the installation directory.
In OBIEE 11g, we have got Enterprise Manager Console, where we can check log files but we can still see these files in OBIEE install directory.

• Enterprise Manager Console

Log on to EM Console (http://localhost:7001/em) . Once you logged on, in the left pane navigate to Farm_bifoundation_domain –> Business Intelligence–>coreapplications–>Diagnostics–>Log Messages
Here you can see the Most Recent Errors and Most Recent Warnings. After warning messages,  you can also see all the log files grouped by categories using Log Viewer.
Available files:
• Presentation Services Log
• Server Log
• Scheduler Log
• JavaHost Log
• Cluster Controller Log
• Action Services Log
• Security Services Log
• Administrator Services Log

• Manually open log files from your install directory

 In this section will see these entire available log file and their paths in the hard disc. The log files for OBIEE components are found under /instances/instance1/diagnostics/logs (eg: C:\OBI\instances\instance2\diagnostics\logs)
These are the different type of log files:
Presentation Server log files
/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1
Files: sawlog0.log, webcatupgrade0.log
BI Server log files
/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1
Files: nqquery.log, nqserver.log, servername_NQSAdminTool.log, servername_nQUDMLExec.log, servername_obieerpdmigrateutil.log
Scheduler log
/instances/instance1/diagnostics/logsOracleBISchedulerComponent/coreapplication_obisch1
Files: nqscheduler.log
Cluster Controller log
/instances/instance1/diagnostics/logs/OracleBIClusterControllerComponent\coreapplication_obiccs1
Files: nqcluster.log
ODBC log
/instances/instance1/diagnostics/logs/OracleBIODBCComponent/coreapplication_obips1
OPMN log
/instances/instance1/diagnostics/logs/OPMN/opmn
Files: debug.log, logquery~NUMBER.log, opmn.log, opmn.out, service.log
Installation logs
/logs


Use of Log Viewer: You can search for and view the log entries for Oracle Business Intelligence components using Fusion Middleware Control Log Viewer. The log files can be searched for log messages, and you can apply filters that can, for example, target a certain date range, user, user transaction, or level of message (error, warning, notification, and so on). You can also view log files in their entirety from the Fusion Middleware Control Log Viewer