Job Types
Table 20-1 Job Types
Job Type | Description |
---|---|
Rules |
Runs a rule that you select. Note the following:
See About Rules. |
Import Data* |
Performs a data import that was saved as a job. See Importing Data. |
Import Exchange Rates |
Imports exchange rates for a simplified multicurrency application. See Importing Exchange Rates for a Simplified Multicurrency Application. |
Import Metadata* |
Performs a metadata import that was saved as a job. See Importing Metadata. |
Import Cell-Level Security Definition |
Imports a cell-level security definition that was saved as a job. See Importing and Exporting Cell-Level Security Definitions. |
Import Valid Intersections |
Imports valid intersections that were saved as a job. |
Export Data* |
Performs a data export that was saved as a job. You can specify a unique output file name for each Export Data job. From the job list, click (Edit) next to the selected job and specify the Output File Name using a zip extension. You can verify the export file name on the Review page. The unique file name will override the default export file name when the job runs. See Exporting Data. Note: The driver/column dimension in the Export Data job definition needs to be dense. |
Export Metadata* |
Performs a metadata export that was saved as a job. You can specify a unique output file name for each Export Metadata job. From the job list, click (Edit) next to the selected job and specify the Output File Name using a zip extension. You can verify the export file name on the Review page. The unique file name will override the default export file name when the job runs. See Exporting Metadata. |
Export Cell-Level Security Definitions |
Exports a cell-level security definition that was saved as a job. See Importing and Exporting Cell-Level Security Definitions. |
Export Valid Intersections |
Exports valid intersections that were saved as a job. |
Refresh Database* |
Refreshes the application database. |
Data Map |
Performs a data mapping operation. See Defining Data Maps in Administering Data Integration for Oracle Enterprise Performance Management Cloud. |
Invalid Intersection Reports |
Runs a report that shows where data exists at invalid intersections. |
Clear Cube* |
Performs a cube clearing operation. |
Restructure Cube* |
Performs a full restructure of a block storage cube to eliminate or reduce fragmentation. This will also remove empty blocks. Running this job won't push any changes from the business process to Essbase. |
Compact Outline* |
Compacts the outline file of an aggregate storage cube. Compaction helps keep the outline file at an optimal size. Compacting the outline doesn't clear the data. Running this job won't push any changes from the business process to Essbase. |
Merge Data Slices* |
Merges incremental data slices of an aggregate storage cube. Fewer slices improve a cube’s performance. You can merge all incremental data slices into the main database slice or merge all incremental data slices into a single data slice without changing the main database slice. You can optionally remove cells that have a value of zero. |
Optimize Aggregation* |
Generates optimized views based on collected query tracking information in an aggregate storage cube. For additional option descriptions, see Improving Cube Performance. |
Administration Mode |
Changes the login level for a business process. If you select Administrators, all non-administrative users will be logged off from the application after job execution. To restore access to an application for all users, select All users. |
Execute Bursting Definition |
Runs a report bursting job If you're using the next-generation Reports reporting solution, the bursting feature enables you to run a single report or book for more than one member of a single dimension for one data source, and publish a PDF output for each member. See "Working with Bursting" in Designing with Reports for Oracle Enterprise Performance Management Cloud. |
Auto Predict |
Runs an Auto Predict job definition. When you run the prediction job, historical data for each member in the Auto Predict definition is retrieved and then analyzed using time series forecasting techniques to predict the future performance for these members. Running the prediction as a job is useful when you have large amounts of data to predict or when you want to keep prediction results up-to-date as part of your planning and forecasting cycle. For additional information about Auto Predict job parameters, see Running Auto Predict Predictions. For information about creating Auto Predict prediction definitions, see About Auto Predict. |
Insights |
Runs an IPM Insights insight definition. For information about configuring IPM Insights insight definitions, see Configuring IPM Insights. |
Integration |
Runs a data rule in Data Management or integration in Data Integration) based on the parameters defined in the data rule or integration definition. For information about running a data rule or integration using the Job Scheduler, see: Scheduling a Data Rule, Integration, or Batch Definition to Run in the Job Scheduler in Administering Data Integration for Oracle Enterprise Performance Management Cloud |
Integration Pipeline* |
Runs a Pipeline definition. This job supports running a Pipeline based on the parameters and variables that were defined for the Pipeline in the Data Integration user interface; for example, Start Period and Import Mode. For descriptions of the job parameters and variables, see the following topics:
For information about creating a Pipeline definition, see Using the Pipeline in Administering Data Integration for Oracle Enterprise Performance Management Cloud. |
Integration Batch |
Runs a batch definition based on parameters defined in Data Management. For information about running a batch definition using the Job Scheduler, see: Scheduling a Data Rule, Integration, or Batch Definition to Run in the Job Scheduler in Administering Data Integration for Oracle Enterprise Performance Management Cloud |
Integration Maintenance Script |
Runs a Maintenance Script based on parameters and variables in Data Management For information about running Maintenance Scripts, see: Scheduling Maintenance Scripts in the Job Scheduler in Administering Data Integration for Oracle Enterprise Performance Management Cloud . |
*This job is prevented from starting during daily maintenance, whether it's a scheduled job or a job that is started on an ad hoc (unscheduled) basis. Oracle recommends that you start this job outside of the daily maintenance window. See Setting the Daily Maintenance Process Start Time.