This discussion is archived
2 Replies Latest reply: Dec 3, 2013 5:16 AM by amith.madisetty RSS

Automate Hyperion Provisioning Report generation

Andy1785 Newbie
Currently Being Moderated

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 Journeyer
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    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

Legend

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