Log Files in OBIEE 11g

Login to the URL http://server.domain:7001/em and navigate to:
Farm_bifoundation_domain-> Business Intelligence-> coreapplications-> Dagnostics-> Log Messages
Also refer below for the Log File configuration-
http://obiee10grevisited.blogspot.in/2012/07/log-configuration-11g.html

You will find the available files:

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

However, you can also review them directly on the hard disk. 

The log files for OBIEE components are under <OBIEE_HOME>/instances/instance1/diagnostics/logs.  Specific log files and their location is defined in the following table:

Installation log
<OBIEE_HOME>/logs

nqquery log
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

nqserver log 
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

servername_NQSAdminTool log 
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

servername_NQSUDMLExec log
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

servername_obieerpdmigrateutil log (Migration log)
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

sawlog0 log (presentation)
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1

jh log (Java Host)
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIJavaHostComponent\coreapplication_obijh

webcatupgrade log (Web Catalog Upgrade)
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1

nqscheduler log (Agents)
<OBIEE_HOME>/instances/instance1/diagnostics/logsOracleBISchedulerComponent/coreapplication_obisch1

nqcluster log
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIClusterControllerComponent\coreapplication_obiccs1

ODBC log
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OracleBIODBCComponent/coreapplication_obips1

opmn log
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

debug log
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

logquery log
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

service log
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

opmn out
<OBIEE_HOME>/instances/instance1/diagnostics/logs/OPMN/opmn

Upgrade Assistant log
 <OBIEE_HOME>Oracle_BI1/upgrade/logs
 

Use of Chronological Key

Typically time dimension differs from all other dimensions in one way and that is,


All other dimensions doesn't care about the order of the values in it.
e.g. in region_dim the values are north, south, west and east. Here nobody wants to see whether north comes first or south comes first. i.e. no order is required here.


In the case of time dimension there needs to be a particular order for all the values present in it.
e.g. 2010 is earliest and 2004 is older. Dec-10 is earliest and jan-10 is older. i.e. the values in the time dimension needs to follow a particular sorting order. So the chronological key is the key which tells the obiee that the data is incrementing based on the chronological column.


For defining a dimension to be a Time dimension, we need to have a chronological Key.

Time Zone in OBIEE 11g

Use- @{session.timeZone}for which zone which user belongs

RANK and TOPN Functions

I am pulling columns required to display rank function.  First column is a dimension and second is a measure column and third column is a column with Rank function as shown below:

Now I want to Rank the first dimension with second dimension value.

For example : Here I am showing customer status by customer type.

So the formula goes like: RANK("F1 Revenue"."1-01  Revenue  (Sum All)",20 by "D1 Customer"."C3  Cust Type")

 And see the result. The result is not in proper order. So we give ascending order for the third column.

 Now see the result and it appears fine.

You can also use TOPN in the place of RANK function.

Thanks for the visit.

Hide Measure Column

Going forward you can refer this link below if it satisfies your requirement-
http://obiee10grevisited.blogspot.in/2012/02/tip-on-mouse-pointer-in-obiee-opacaity.html



1.First we are creating a report with a dimension and two measure columns in which we will hide one of the column

If we are using pivot table

 Go to the format heading of the first column(which is to be hidden)

 And set the font color as 'WHITE'

And check the result

 Again go to the Format Measure values

And make the font as 'WHITE'

And border as 'Custom' and check the three layers and give the color as '#CCCCCC" as shown

And check the result

 Now for the first column change the background color of the format heading to 'WHITE' and in the border
change the 'Custom' to '#CCCCCC'

 And finally add right indent in the 'Additional Formatting Options' in the 'Format Measure Values'
in the second column to 100.So that it looks like its in the middle.

And check the result.