Act As Functionality in Oracle BI

Implementing Act As functionality or the Proxy User functionality is very well explained by Venkat in his blog. This feature uses "Execute Physical" for getting the list of Target Users. That means we need to give access for executing physical requests to the database in Oracle BI Administration tool. This can be easily done for the users by assigning them to a group and adding permission to execute physical requests on the database. However when the users are coming from a different system, say Siebel for instance and we dont have control on groups then its a little tricky to get through. Its recommended to go through this blog before proceeding.

After the Proxy User functionality is set as per given in the Venkat's blog,

1. Create a new Business Model and drag the Table PROXYTABLE in BMM Layer.

2. Create a Dummy Fact using the same table.

3. Create a complex join between the two logical tables in Business Model Daigram.

4. Create Primary key for the Logical Table PROXYTABLE to make the Business model consistent.

5. Drag the Business Model in the presentation Layer and delete the Dummy Fact.

6. Change the contents of the webmessage file located at {OracleBIData}\web\msgdb\customMessages to:

<?xml version="1.0" encoding="utf-8" ?> <WebMessageTables xmlns:sawm="com.siebel.analytics.web.messageSystem"> <WebMessageTable system="SecurityTemplates" table="Messages"> <WebMessage name="LogonParamSQLTemplate"> <XML> <logonParam name="RUNAS"> <getValues> SELECT PROXYTABLE.TARGETUSER saw_0 FROM Proxy WHERE PROXYTABLE.PROXYUSER = VALUEOF(NQ_SESSION."USER") </getValues> <verifyValue>SELECT PROXYTABLE.TARGETUSER saw_0 FROM Proxy WHERE PROXYTABLE.PROXYUSER = VALUEOF(NQ_SESSION."USER") and TARGETUSER='@{VALUE}'</verifyValue> <getDelegateUsers>SELECT PROXYTABLE.PROXYUSER , PROXYTABLE.PROXYLEVEL FROM Proxy WHERE PROXYTABLE.TARGETUSER = VALUEOF(NQ_SESSION."USER") </getDelegateUsers> </logonParam> </XML> </WebMessage> </WebMessageTable> </WebMessageTables>

This approach is similar to the way SA Systems Subject Area work.