Scheduling OLAP Processing

To access the Schedule OLAP Processing scheduler, complete the following steps:

  1. From the MPM Project Maintenance window, click schedule_olap_processing.jpg Schedule OLAP Processing or click Tools » Schedule OLAP Processing to access the scheduler.

Scheduler Fields

Status

The Last Processed field continues to display the last successful OLAP process date and time, even if there are jobs that run later which fail.

The following table depicts the different status values for OLAP displayed on the scheduler dialog box:

OLAP Cube State

Value in Last Processed Field

Value in Current Status Field

Cube not processed even once

Blank

Blank

Processing is Scheduled

<Last Successful Run Date and Time>

Scheduled

Processing is Pending

<Last Successful Run Date and Time>

Pending

Processing is in Progress

<Last Successful Run Date and Time>

Processing

Processing completed successfully

<Last Successful Run Date and Time>

Success

Processing Failed

<Last Successful Run Date and Time>

Failed

Scheduler Options

Scheduler Frequency

Description

Disable Synchronization

This disables any scheduled OLAP processing jobs and allows other projects to be processed.

See Project Scheduling and OLAP Processing for information on coordinating project and OLAP processes

Run Immediate

The OLAP processor will run immediately after the controller picks up the job.

See the MPM Installation Guide appSetting section in the topic Server: Configure the Data Warehouse Controller using the Controller.exe.Config File for information on the controller’s polling frequency.

Daily

Specify the start date, end date, and start time.

Weekly

Specify the days of the week when the synchronization should be run, along with the start date, end date, and start time.

Monthly

Specify the day of the month when the synchronization should be run along with the start date, end date, and start time.

 

Related Topics

Project Scheduling and OLAP Processing

Related Topics

Introduction to the MPM OLAP Cube

Connecting to an MPM OLAP Cube

Using the Excel PivotTable Field List

OLAP Dimensions and Measures