Job Types

Table 15-1 Job Types

Job Type	Description
Rules	Runs a rule that you select. Note the following: You can filter the rules list by cube and by rule type. You must click the check mark next to the rule you want to run before you can proceed. For rules jobs with runtime prompts, clicking the check mark next to a rule will display the runtime prompt parameters. Set the runtime prompt values with which to run the rule in the job scheduler, and then click OK. Hidden runtime prompts will pick up the default values that were set at design time in Calculation Manager. See About Rules.
Import Data*	Performs a data import that was saved as a job. See Importing Data.
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. See Importing and Exporting Intersections.
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 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 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. See Importing and Exporting Intersections.
Refresh Database*	Refreshes the application database. See Refreshing Application Databases.
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. See Working With Invalid Intersection Reports.
Clear Cube*	Performs a cube clearing operation. See Creating Clear Cube Jobs.
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. See Improving Cube Performance.
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. See Improving Cube Performance.
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. See Improving Cube Performance.
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. See What Application and System Settings Can I Specify?
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.
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: Using an Integration Job Type in Administering Data Integration for Oracle Enterprise Performance Management Cloud Running a Pipeline in REST API for Enterprise Performance Management Cloud For information about creating a Pipeline definition, see Using the Pipeline 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.