BeyeBLOGS | BeyeBLOGS Home | Get Your Own Blog

« Different types of Dashbords, how to choose a required one | Main | CDC Technique for dimension table which is based on a multi-table query »

April 11, 2007

How to create Personal Dashboard using Oracle Portal

By: Milind Zodge

Overview
I recently worked on creating a dashboard application which show contents based on who is logged in. In short that person will have his/her own personal dashboard.
There are various ways to do this. One can use Virtual Private Databases technique to achieve this. What I am focusing in this article is a case where you don't want to create hundreds of database users which is a maintenance problem, rather using your company's existing security structures. Let's consider for this purpose we have an active directory structure or Oracle Portal's Internet Directory structure. We have one database user and hundreds of internet users.

Design
1. Create a table which will hold loginname, user role like "Regional Manager", "Area Manager", "Sales Rep", "Analyst" etc. and particular code like region code, area code, salesrep code
2. Create a welcome page which will prompt for entering a password
3. Once the user entered their network credential, capture the entered user id and call other page by passing the user id as a parameter as shown by the below MOD-PL/SQL code:
HTML
BODY
ORACLE
DECLARE
l_user_info varchar2(50) := sys_context('USERENV', 'CLIENT_INFO');
l_user varchar2(50):= SUBSTR(l_user_info, 3, INSTR(l_user_info, ',') - 3); -- This will extract the userid
BEGIN
IF UPPER(l_user) = 'PUBLIC' THEN
NULL;
ELSE
IF UPPER(l_user) = 'PORTAL' THEN
NULL;
ELSE
Here you can call other page and pass the user id as a parameter
END IF;
END IF;
END;
/ORACLE
/BODY
/HTML
4. Now you can use this parameter and table created in the first step to determine the level of the user and how to display the data using proper region code or area code or other ids

Conclusion
This way you can create Personal Dashboards for your users without creating hundreds of database users.

Posted by Milind Zodge at April 11, 2007 10:15 PM

Comments

ЃgnN4@*‰ sildenafil ћ6GyJљѓK,

Posted by: Anethythymn at May 16, 2011 4:26 AM

Post a comment




Remember Me?