1 Reply Latest reply: May 4, 2012 9:38 AM by Krishna Kumar K P-Oracle RSS

    ScheduledBQY's in Hyperion IR


      Is there a way of exporting Scheduled Jobs in Hyperion IR out of repository using SQL or any other way and then importing it in the new environment ?

      We are migrating from version 8.3 to version and I know from the documentation that there is no migration utility provided by oracle for this. But the repository tables for scheduled jobs look pretty similar on 8.3 and

      We have hundreds of scheduled jobs and recreating them one by one again in EPM will take ages. We have done this manual process for on demand bqy's, but it doesn't look practical for Scheduled jobs.

      Any pointers will be appreciated.

      Thanks in Advance!!
        • 1. Re: ScheduledBQY's in Hyperion IR
          Krishna Kumar K P-Oracle
          You could try the path from 8.3 to , this allow you to use the migration utility to move the jobs. Then upgrade to

          So you will have all the jobs in

          For your information you cannot directly move to from a earlier version like 8.3 . Refer the readme " http://docs.oracle.com/cd/E17236_01/epm.1112/epm_1112200_readme.pdf " for the "Supported Paths to this Release"

          Hope this helps.

          Edited by: KK on May 4, 2012 7:37 AM