6 Replies Latest reply: May 21, 2012 2:02 AM by KBabu RSS

    ACT as in OBIEE 10g

    KBabu
      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
          Expert guys
          • 2. Re: ACT as in OBIEE 10g
            KBabu
            Expert Guys

            Could anyone throw some info on the ACT as please

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

              Thanks
              • 4. Re: ACT as in OBIEE 10g
                Srini VEERAVALLI
                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
                  For Initblock RUNAS use the query
                  SQL Server
                  Select 'dummy'
                  Oracle
                  Select 'dummy' from dual
                  • 6. Re: ACT as in OBIEE 10g
                    KBabu
                    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