Example: Importing and Scheduling a Job

This example illustrates importing and scheduling of an Oracle Hyperion Interactive Reporting job. In this example, you import and schedule sample1.bqy to run once per quarter.

  To import sample1.bqy:

  1. Navigate to the folder to which to import the job.

  2. Select File, then Import, and then File as Job.

  3. In File, click Browse to search for the file sample1.bqy. Click Next.

  4. For Query, on Connecting to Data Sources, under Connection, select Sample for the Query/DataModel name called SalesQuery, and click Next.

  5. For Interactive Reporting Job Properties, select Users running this job can define their own cycles and actions, and click Next.

  6. For Job Defaults, set General Properties and Locale and click Next.

  7. In Permissions,

    give the World group access to sample1.bqy.

    1. Under Users, Groups, and Roles, click Update List.

    2. Select a user and click Add icon.

    3. Under Selected Users, Groups, and Roles, select the user and click Edit.

    4. On Permissions, select the access permissions level for the job and the job output, and set the adaptive state.

      • Access to Job—Full Control

      • Adaptive state—View

    5. Click Finish.

      Permissions is displayed.

  8. Click Finish and Schedule.

  9. On General Properties, in Name, enter Quarterly, and click Next.

  10. On Job Parameters, click Next.

  11. On Cycles, by Add another cycle to this job, click Go.

  12. Define a cycle:

    • Under Define Cycle, in Cycle Name, enter Weekly.

    • Under Add a(n) (blank) Action to this Cycle, select Email Document, and click Go.

  13. On Add/Modify Action: Email Document, in To, enter your email address.

  14. Select Send File and/or Send Results, and click OK.

  15. On Define Cycle, click OK.

  16. On Cycles, select Save Job Parameter Name, select Personal from the drop-down list, enter a name in the box, and click Next.

  17. On Time Events, select Define when to run this job starting with, and select A New Recurring Time Event, and click Next.

  18. On Define Event:

    • In Name, enter a name.

    • In Days to Run, select By Quarter.

    • Click Next.

  19. Under Notification, select Display notification in Schedule Module, and click Finish.

    The job is now scheduled to run.