OBIEE11g Multi Language Catalog

Open the catalog manager and browse to the catalog you want to translate:

Select the shared folder:

From tools select export captions

Navigate to the export folder:

Make a copy of the folder for each language

Edit/Translate the XML files:

Navigate to <<OBIEE_HOME>>\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\msgdb

Add a sub folder for each language l_xx if it doesn’t exists:

in each folder add a subfolder captions:

Add the translated XML to the respected folder:

Restart the presentation server and log in for each language to check:

Till Next Time

OBIEE Using the EM NQQuery log

After I did this article http://obiee101.blogspot.com/2011/07/obiee11-how-to-use-log.html on how to read the NQquery.log with notepad I got a couple of emails telling me that the log can also be found in the enterprise manager.

First of all I know but I don’t like it because of the time it takes to refresh every time. (My laptop isn’t that fast).

But here is how you use it:

Open the enterprise manager and go to the business intelligence core application:

Click on the diagnostics tab and open the Log Messages tab

Open the server log:

You might have to wait a bit:

Check the trace box

and add “Sending query to database” in the Message contains box

press the search button

Now you can plough trough the log:

Till Next Time

OBIEE Developing a Parent-Child hierarchy

Just some strange behaviour I noticed OBIEE doesn’t like me developing a Parent-Child hierarchy in online modus in 11.1.1.5. It seems to miss some settings during a consistency check. When I did it in off-line modus the consistency check showed the errors.

Till Next Time

OBIEE Localization and NULL values

Just a tip: When setting up multi-language localisation, be sure that ALL your translated value have at least an space in them. The init block will fail if OBIEE encounters an NULL or an empty string.

Use NVL to catch it in the init block:

Till Next Time

OBIEE11 How to use the log

If you come from a 10g background you might be missing the NQquery.log. Don’t worry it’s still there. In 11.1.1.5 you will find it in <<OBIEE_HOME>>\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1

Along with the NQserver log.

Now how do I set the loglevel? Two options:

- Set it for everbody. (!A No No on production machine’s!)

In the Administration tool goto TOOLS > Options

- Set it for a individual user:

You can’t do it in the Administration tool, since the users are no longer there.

You have to do it in the report under investigation, go to the advanced tab of your report:

Scroll down to the prefix part:

and enter:

SET VARIABLE LOGLEVEL=2;

Don’t forget the semicolon!

Open the NQquery.log in a text editor (fi Notepad++)

Run your report and reload the log in the text editor:

Scroll down to the bottom to check your sql:

Till Next Time

OBIEE Adding an application role (GROUP)

Adding a group or a role online in OBIEE 11g has moved to the WEBLOGIC server.

Open the enterprise manager and open the business intelligence core application:

goto the security tab:

Press lock and Edit configuration:

Click on Configure and manage Application Roles

Click Create:

Fill in the details:

Add Members:

Press OK

Press Activate Changes:

Restart the BISERVER:

Check the OBIEE Identity manager:

Till Next Time