Update Business Objects Report Tables Job

This job populates tables used within the CA Clarity PPM Business Objects universe, depending on the selection of three optional parameters. You can select the tables that you want populated by selecting the appropriate parameter.

You can run this job immediately or on a scheduled basis.

Requirements

None

Parameters
Update Portfolio Content

Indicates the tables for portfolios and their investments are to be updated.

Update WBS Index

Indicates that tables for efficient phase-level and activity-level reports are to be updated.

Update Universe Calendar

Indicates that calendar tables are to be updated for reporting such as FTE hours (typical 8-hour work day and 40-hour work week).

Update Earned Value History Job

The Update Earned Value History job calculates earned value for a project or set of projects and creates earned value snapshots of the time sliced data. This data is based on the earned value reporting period assigned to the project and the parameters that you select. The earned value snapshot is used for historical earned value analysis (EVA) and reporting. The snapshots are stored in rows in the PRJ_EV_HISTORY (earned value history) table. You can use this reporting data to write reports.

This job invokes the Update % Complete job before it runs and completes. This job runs on a recurring schedule based on how often your organization reports on your earned value data. This job uses the lag value to determine the day to take the snapshot. A snapshot is taken on the first day following the defined lag, providing you do not run the job on that day.

Example: Monthly with Three Day Lag

If you schedule this job to run monthly starting 2/1/10 with a lag of three days and you have associated the project to an earned value reporting period whose period type is defined as Monthly and frequency is the first day of the month, a snapshot for January 2010 is generated only when the job runs on 2/04/10 or later.

For each project that meets the job's parameter criteria, this job:

Note: See the Project Management User Guide for more information.

Requirements

To create a historical snapshot, the project must:

Restrictions

This job cannot run concurrently with any other instance of the Update Earned Value History job.

Parameters

The following parameters are provided:

Note: If you do not complete any of the parameters, then all projects are processed.

Project

Defines the name of the project.

OBS Unit

Defines the name of the OBS Unit.

Project Manager

Defines the name of the project manager.

Lag

Determines the number of days to wait before taking the snapshot. Use this setting to defer taking a historical snapshot so that your organization can reconcile actuals from one system to another.

Rewrite Existing Snapshot

Indicates whether you want this job to regenerate the current reporting period snapshot and replace the existing current periodic snapshot with updated data. When cleared, those projects that already have periodic snapshots are ignored.

Default: Cleared

Show Projected ACWP

Indicates whether you want this job to create data for the projected actual cost of work performed (ACWP) of all level-1 tasks in the work breakdown structure (WBS) for a project.

Default: Cleared (disabled)

Show Projected BCWP

Indicates whether you want this job to create data for the projected budgeted cost of work performed (BCWP) of all level-1 tasks in the work breakdown structure (WBS) for a project.

Default: Cleared (disabled)

Show Projected BCWS

Indicates whether you want this job to create data for the projected budgeted cost of work scheduled (BCWS) as of the date for projects and project tasks.

Default: Cleared (disabled)