This discussion is archived
6 Replies Latest reply: May 21, 2012 12:02 AM by KBabu RSS

ACT as in OBIEE 10g

KBabu Explorer
Currently Being Moderated
Experts

Could you please help out doing a step by step procedure for implementing ACT as functionality in OBIEE... I got many links when i googled ACT as..but getting strucked up while doing at IB & Variables section...

http://gerardnico.com/wiki/dat/obiee/actas..... in this link i got strucked while creating Variables..please assist on this
  • 1. Re: ACT as in OBIEE 10g
    KBabu Explorer
    Currently Being Moderated
    Expert guys
  • 2. Re: ACT as in OBIEE 10g
    KBabu Explorer
    Currently Being Moderated
    Expert Guys

    Could anyone throw some info on the ACT as please

    Thanks
  • 3. Re: ACT as in OBIEE 10g
    KBabu Explorer
    Currently Being Moderated
    Naveen, Ahsan
    Can you please help me in developing ACT as functionality in OBIEE?

    Thanks
  • 4. Re: ACT as in OBIEE 10g
    Srini VEERAVALLI Guru
    Currently Being Moderated
    Follow the link to create setps 4,5 and 6

    http://docs.oracle.com/cd/E12096_01/books/AnyWebAdm/AnyWebAdm_SecPermPriv25.html

    1) Import table in RPD
    2) Check this option "Allow direct database requests by default" RPD database
    3) Create Initblock for variable RUNAS
    4) Create Initblock for variable PROXY with 'Execution Precedence' RUNAS
    5) Create Initblock for variable PROXYLEVEL with 'Execution Precedence' PROXY
    6) Navigate to /OracleBIData/web/config/ and modify the file instanceconfig.xml to add the below tag before the </ServerInstance>
    <LogonParam><TemplateMessageName>Act_As_Logon_Template</TemplateMessageName>
    <MaxValues>100</MaxValues>
    </LogonParam>
    7) create a xml file @ /OracleBI/web/msgdb/customMessages
    <?xml version="1.0" encoding="utf-8" ?>
    <WebMessageTables xmlns:sawm="com.siebel.analytics.web.messageSystem">
    <WebMessageTable system="SecurityTemplates" table="Messages">
    <WebMessage name="IGActAs">
    <XML>
    <logonParam name="RUNAS">
    <getValues>EXECUTE PHYSICAL CONNECTION POOL ActAs.CP_ActAs SELECT TARGET_ID FROM W_ACT_AS_G WHERE PROXY_ID='@{USERID}'</getValues>
    <verifyValue>EXECUTE PHYSICAL CONNECTION POOL ActAs.CP_ActAs SELECT TARGET_ID FROM W_ACT_AS_G WHERE PROXY_ID ='@{USERID}' AND TARGET_ID='@{VALUE}'</verifyValue>
    <getDelegateUsers>EXECUTE PHYSICAL CONNECTION POOL ActAs.CP_ActAs SELECT PROXY_ID,PROXY_LEVEL FROM W_ACT_AS_G WHERE TARGET_ID ='@{USERID}'</getDelegateUsers>
    </logonParam>
    </XML>
    </WebMessage>
    </WebMessageTable>
    </WebMessageTables>
    8) Answers->Settings->Administration->Manage Privileges
    9) Restart BI

    Enjoy Act As
  • 5. Re: ACT as in OBIEE 10g
    Srini VEERAVALLI Guru
    Currently Being Moderated
    For Initblock RUNAS use the query
    SQL Server
    Select 'dummy'
    Oracle
    Select 'dummy' from dual
  • 6. Re: ACT as in OBIEE 10g
    KBabu Explorer
    Currently Being Moderated
    Hey All
    Finally i would like to say finally this is ok..i will make it resolve if its implemented in PROD
    hmm my experience in implementing ACT AS in 10.1.3.4.1 is not smooth..because all blogs just giving diiferent paths to save the XML template.."LogonParamSQLTemplate"
    Some blogs are advising to keep in <InstalledPath>/OracleBI/web/msgdb/messages
    and some blogs are advising to copy <Installedpath>/oracleBIData/web/msgdb/CustomMessages
    I have copied in both the locations
    As i implemented this in my local... so, for me C:\OracleBIData\web\msgdb and C:\OracleBI\web\msgdb\l_es\messages
    and i created users USER_1,2,3..gave access...but make sure these users are in any one of the Security Groups...or else you will not see the ACT as users
    am using Windows envi

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points