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

    ScheduledBQY's in Hyperion IR

    934706
      Hi,

      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 11.1.2.2 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 11.1.2.2?

      We have hundreds of scheduled jobs and recreating them one by one again in EPM 11.1.2.2 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 11.1.1.3 , this allow you to use the migration utility to move the jobs. Then upgrade to 11.1.2.2.

          So you will have all the jobs in 11.1.2.2.


          For your information you cannot directly move to 11.1.2.2 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