Job Types

Table 14-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 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.

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 icon 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.

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 icon 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.

Refresh Database

Refreshes the application database.

See Creating and Refreshing Application Databases.

Data Map

Performs a data mapping operation.

See Defining Data Maps.

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 Planning 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 Planning 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 Planning application. 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?