DYNAMIC CHANGING OBIEE HOME PAGE BASED ON LOGIN ID

I thought of posting an interesting functionality - ‘dynamic changing OBIEE home page’ which would be a nice to have feature for most customer.

Let us first look at the functionality and then get into details of how easily this can be implemented:

Lirin logs in:

Sudeep logs in:

Sam logs in:

Please remember that these are home page screen which the users sees the moment they log in to OBIEE. Due to security constraints, I do not want to share any real contents.

Implementation Steps:

Step 1: Click on ‘My Account’ within OBIEE screen and make sure the preference for starting page is set as ‘My Dashboard’ [shown below]:

Step 2: Create 3 separate dashboards with required contents. Not showing any more details for this stepJ.

Step 3: Create a table, say DYNAMIC_PAGE with the following columns:

Your dashboards location should match the ‘PATH’ column value in the above table.

Step 4: Create a variable in RPD which will assign the ‘dashboard path’ value to system session variable ‘PORTALPATH’, as shown below:

This should take care of everything and you will have required dashboard set dynamically based on login.

Hope this helps. Please do leave your feedback.