Sunday, April 17, 2011

OBIEE 11g Query Log- Log Level

How to define log level in OBIEE 11g? 

When enabled, OBIEE creates a query log in NQQuery.log file which is located by default at {Middleware_Home/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1. The query long becomes very handy in testing environment and troubleshooting. Click here for more details on Query Log and Log Level.

In 10g, it was simple. Open your repository in Oracle BI Administration tool, from the file menu go to Manage> Security > Users. Double click a user to go to properties and set the logging level.

Well, let's try the same in OBIEE 11g, let's go to Manage> Identity.

Where are my users?

Now, in OBIEE 11g, the users security/identify store is defined in Weblogic server. To define log level open your repository in online mode in Oracle BI Admin tool, go to Manage> Identity. Now, you can see the defined users. 

Double click on a user name to see properties. Set logging level by using up and down arrow. Log level is defined from 1 to 5. Click here to get more information on logging level. 

Click OK, check in your changes, save the repository. Restart BI Services and next time this user logs in you will be able to see the query logs being generated.



Wednesday, April 13, 2011

OBIEE Interview Question- Alias Table

What are the benefits of using Aliases in OBIEE?

It is a best practice to create aliases for all tables. Aliases are created in the Physical Layer of the repository. Some of the benefits of using aliases are given below:

·        You can create a join relationship which is different than the actual foreign key relationship in the database. This helps in defining relationships to meet business model criteria.
·         An alias is used to avoid circular joins and to configure self joins. (for more details on Fan Trap and Circular Joins check this blog.)
·         Aliases can function in numerous ways to define business model e.g. a table can act both as a dimension and a fact using aliases.
·         You can rename aliases to make physical and business model easier to understand. 

Click here to read more about aliases in Oracle Documentation. 
More information in this wiki/blog:

Reference: Oracle® Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1)


Saturday, April 9, 2011

OBIEE 11g Customization

OBIEE Dashboard Logo Customization

Clients usually want that their company’s logo appears in the dashboard page.

This can be achieved by replacing Oracle’s logo (oracle_logo.PNG) from 


Please refer Oracle’s whitepaper- ‘Customizing Oracle Business Intelligence Enterprise Edition 11g’ for more information on customization by clicking here.