2 Replies Latest reply: Dec 3, 2013 7:16 AM by amith.madisetty RSS

    Automate Hyperion Provisioning Report generation

    Andy1785

      Hi All,

       

      We are planning to automate weekly Hyperion Provisioning Report generation from shared services. Is there a way to schedule it ? Kindly advice.

       

      Regards,

      Andy

        • 1. Re: Automate Hyperion Provisioning Report generation
          amith.madisetty

          Hi Andy,

           

          Could you please be more specific if you are looking for report of Assigned Roles,Groups,Users etc i have come across this , but if you are looking for View Report (Provision Report) then i need to do some work to come out for it if you manage to come across with a solution on this post happy to see implementing in our project as well.!!!

           

          Thanks

          Amith

          • 2. Re: Automate Hyperion Provisioning Report generation
            amith.madisetty

            Hi Andy,

             

            I dont see any utility or way to reach out to report automation, as a workaround i can provide you with below query which can give the provision information which would be simlar to Provision Report.

             

            Run the below query on Shared Services Schema.

             

            select p.application_id,p.createdtimestamp,c1.name,o.name,o.locale from

            css_provisioning_info p,css_groups c1,css_role_locales o
            where p.member_identity in c1.identity_id and p.role_identity in o.identity_id and

            o.locale='en_US' and p.application_id like '%XXXXXX%'
            order by c1.name

            and You can automate this to get a report pulled at our desired timings.

             

            Thanks

            Amith