Sunday 29 January 2012

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
 


Monday 23 January 2012

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.

Wednesday 18 January 2012

Time Zone in OBIEE 11g


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


Tuesday 10 January 2012

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.

Monday 9 January 2012

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.