Schedule Report in OBI 11g using a users security table

KN

Hello All,

I have a requirement where i need to schedule a report based on users custom table .

Explaination:

I have a report RPT1 to be scheduled to run daily. This needs security to be applied as per the users and they organization information stored in the table. this table has email ID also.

Table definition is like, USERNAME, ORGID and another table with USERNAME, EMAIL.  I can alter the tables as needed to fit in the requirement.

User is not registered in weblogic, So, i can't use run as recipient in the Agents.

How can one report can be bursted to multiple users with security intact.

Any clues plzz.

Thanks,

KN