Tuesday, July 7, 2009

html/css trick

I had an issue yesterday with a field that contained a concatenated type code (Type in this report) and a ROW_WID . The report is supposed to show the Type value only:CA instead of CA384639 for the Type field while maintaining the correct subtotal count.

Substring function to extract the first two letters as follows doesn’t work because the subtotal operation is performed AFTER the substring command is done

You get then for the first subtotal 1 instead of 2 because even though the aggregation is set to “count distinct” , it's counting 'CA'

The solution we used kind of a kludge but it worked): change the Type data type to “HTML” and using a CSS to hide the WID part, enter the following in the column formula:

is basically a CSS tag to hide text

And voila you get

Friday, June 12, 2009

OBIEE and Google Chrome

Answers used to not work correctly with Google Chrome however It looks like that issue has been fixed with the latest release Chrome


Thursday, April 30, 2009

OBIEE Plug-in for Oracle11g OLAP Option available

The Oracle Business Intelligence Enterprise Edition (OBIEE) Plug-in for Analytic Workspace Manager (AWM) allows you to quickly create an OBIEE repository that will allow the OBIEE Server to query Oracle Database 11g OLAP cubes.
Instructions: Link
Download: Link
Video Demo: Link

Tuesday, April 28, 2009

Left navigation menu (part 2)

One thing I learned is that when using "link/image" section pointing to a dashboard, securing the dashboard will automatically secure the link e.g let's say user A doesn't have access to the "Security" dashboard then the section containing the link the "Security" dashboard won't be shown to the user. To illustrate this let's create one group for each dashboard



And let's assign user_a to all the groups except SECURITY and let's assign user_b to all the groups. When user_a login they get the left navigation menu without SECURITY

While user_b

gets all the links:

This is nice, when creating a link to a dashboard using "link/image" one only need to secure the dashboard then the link is secured de facto.

Monday, April 27, 2009

Left navigation menu (part 1)

I had a request from a customer to implement a left navigation menu and to disable top navigation links that comes out of the box. I would not recommend this for a large implementation or not at all even...
Turns out enabling navigation from the left hand side isn't too hard however securing the links can be tricky...The requirement was to have role based left navigation menu. For example the power user would see for example
-Manage my account
and as an ordinary user
-Manage my account
and so on.

Another requirement was to have 'widgets' with personalized contents on the "home" dashboard for each user. (I hope to cover this section in the near future)

Implementing this is straight forward using the OOT features of OBIEE by basically creating goups/dashboards and assigning users to groups and groups to dashboards.

I am going to illustrate one way of achieving this using a left navigation menu:

Starting from an empty dashboard I created 5 sections on my dashboard corresponding to the links listed above (refer to screenshot)

Each section content is of the "link/image" type.

I am going to create 5 dashboards for illustration: Home,Administration,Manage My Account, Reports, Security and wire each "link/image" to its corresponding Dashboard. For example for home

Now we have all the links working.
I will cover next the security for the left navigation menu

Friday, April 24, 2009

Add hyperlink to OBIEE Login Page

I had a requirement to add a link to the OBIEE Login page. This hyperlink points to an app for resetting password in this particular case. Here is how it's done:
In the utilmessages.xml in
Locate the tag
add the link below the text as illustrated in the picture

Restart your BI server and Presentation server :

Remove OBIEE version from Login page

I had a requirement to remove the BIEE version from the login page. Following is how it was done, let me know if you have another approach for this.
Make a backup of logoncontrolmessages.xml located in
and locate and remove the second occurence of sawm:param insert="2" /

as illustrated below

Reboot your BI server and presentation service.


This blog is basically a brain dump for myself. I will be posting stuff related mostly to Oracle Business Intelligence, tips and tricks that I learned over the years while working on projects. Feel free to contribute...Thanks in advance for the feedback.

Hello World

select sysdate from dual
4/24/2009 9:43:24 AM