To access the Schedule OLAP Processing scheduler, complete the following steps:
From the MPM Project Maintenance window, click Schedule OLAP Processing or click Tools » Schedule OLAP Processing to access the scheduler.
Last Processed — Displays the last successful processing date and time. This field is blank until the processor completes one successful job. See the table below for field options.
Current Status — Displays the current status of the processor. See the table below for field options. While the actual status will be updated, it will be necessary to close and reopen the Project Maintenance screen to refresh the status display.
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 Frequency |
Description |
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. |
Project Scheduling and OLAP Processing
Introduction to the MPM OLAP Cube
Connecting to an MPM OLAP Cube