6 Replies Latest reply: Jan 4, 2012 7:05 PM by Christian Screen RSS

    OBIEE 11g - Agents configuration

    831943
      Dear guys,

      Can we automate read email information of user from LDAP to delivery device setup for user to run Agent scheduler ?

      Are there any solution for this ? I tried any but unsuccessful !

      Thanks & Regards,
      Hac@
        • 1. Re: OBIEE 11g - Agents configuration
          Deepak Gupta
          I hope I understood your requirement correctly. You are trying to trigger an ibot based on read receipt of an e-mail.
          ====

          I can only think of one OOTB solution where the read e-mail of that particular user shud change the Flag value to 'Y' in any underlying database that OBIEE can read and then trigger an ibot based on Flag value condition.

          You will have to look for a soln where a DB table is updated whenever read receipt is generated in Outlook. Try to concentrate on this feature
          • 2. Re: OBIEE 11g - Agents configuration
            831943
            Dear Deepak Gupta,

            Thanks for your reply, below is the description of our requirement

            What we did :

            - In WLS Console, go to Security Realms - > my realms -> User & Groups -> select user -> modify User Attributes mail value = myemail@mydomain.com

            - In OBIEE, loged in with user account and go into My Account -> Deliver Option -> Device = Email and there is no email information existed, we must input email information manually.

            The question is:

            - How can we config the Device automatically get the email information that we defined in WLS Console in User Attributes ? Is it possible ?

            - In case impossible, are there any solutions to automate load email information of user ?

            The requirement is:

            When we configure an Agent Scheduler, at Recipient tab information, we add user account to recipient list and specific device = email then the system can read the email information of each user account for sending report.

            Thanks & Regards,
            Hac@
            • 3. Re: OBIEE 11g - Agents configuration
              Deepak Gupta
              Make use of SA System Subject Area to autoload the user's profile..

              http://oraclebizint.wordpress.com/2008/04/25/oracle-bi-ee-101332-sa-system-subject-area-autoloading-profiles-and-bursting/

              http://gerardnico.com/wiki/dat/obiee/sasystem
              • 4. Re: OBIEE 11g - Agents configuration
                831943
                Dear Deepak Gupta,

                Thanks so much, it solved our problem !

                Regards,
                Hac@
                • 5. Re: OBIEE 11g - Agents configuration
                  user637881
                  Is the Oracle documentation wrong on this topic? The Scheduling Jobs Guide says this:

                  -------------------------------------------------------------------------------------------------------------------------
                  If you must automate only the population of e-mail addresses in user profiles, then
                  you should populate the e-mail address field for users in your LDAP server or other
                  authentication provider, if possible. These values are used to populate the e-mail
                  address in Oracle Business Intelligence user profiles, enabling users to receive content
                  from Delivers, even if they have not signed into Oracle Business Intelligence. This
                  feature works for any LDAP server that has a mail attribute for its users.

                  In some cases, however, you might want to automatically populate additional user
                  profile options, in addition to e-mail addresses. For example, you might want to
                  automatically populate a cell phone number as part of the user profile information, if
                  you want Delivers to deliver a format suitable for a cell phone (like text) using an
                  e-mail gateway.

                  In this situation, you can configure a special subject area in the repository called SA
                  System that retrieves user information from a database and populates the user profile
                  information.
                  -------------------------------------------------------------------------------------------------------------------------

                  If all we want is the user's email address that is stored in LDAP, why do we need to set up and use the SA System subject area?

                  Thanks.

                  Jerry
                  • 6. Re: OBIEE 11g - Agents configuration
                    Christian Screen
                    Hac Vo,

                    The response you marked as the correct answer is only partially correct. That response was for using the backwards compatability option.

                    The correct way it should work is hindered by a bug/non-existing feature and is fixed in a patch that was released in Q4 2011 and fixes this issue for Oracle BI 11.1.1.5.

                    You'll need to get to support.oracle.com and download the patch.

                    The patch number is 12667254 and is 25 MB to download.

                    Here is the issue note:
                    How To Setup Obiee 11 To Retrieve Email Addresses From Active Directory [ID 1363411.1]
                    Bug 12667254 - LDAP ATTRIBUTES NOT APPEARING IN SYSTEM PROFILE SO NOT AVAILABLE TO DELIVERS

                    Please go to the My Oracle Support ( http://support.oracle.com/ ) to download the patch referenced below.
                    Patch: 12667254 - LDAP ATTRIBUTES NOT APPEARING IN SYSTEM PROFILE SO NOT AVAILABLE TO DELIVERS


                    Cheers,
                    Christian
                    http://www.artofbi.com
                    http://mdsearch.fyght.com
                    http://amelia.artofbi.com