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

OBIEE on IE9

First of all OBIEE11.5 is not certified for IE9. This means you might get strange behaviour when running a dashboard. Most problems can be solved by putting IE 9 in the compability mode:

Tools > Compality view

Till Next Time

OBIEE ODI Lineage setup

Copied from my ODI blog:
http://odiee101.blogspot.com/2011/06/obiee-odi-lineage-setup.html
When setting up a OBIEE ODI Lineage RPD you might get the following error:

ODI-50036: Error creating V_LINEAGE_HIERARCHY Table. Check the logs.

The error might fool you. It means that your (work) repository schema doesn’t have the right to create a view.
Ask your DBA to run the following script:

grant create view to snpm1;
grant create view to snpw1;

Till Next Time