Stock Job Descriptions › Datamart Extraction Job

Datamart Extraction Job

This job extracts data from the transactional database tables and stores them in easily understood reporting tables. These tables are the foundation for most reports that are delivered with CA Clarity PPM and are used for any custom reports.

For Microsoft SQL Server 2005 with the SQL Server Agent enabled, you must add the CA Clarity PPM administrator account to the SQLAgentUserRole role to run datamart extraction jobs. See Microsoft SQL Enterprise Manager documentation for details on adding user accounts to the SQLAgentUserRole role.

Requirements

(Recommended) Run this job after the Time Slicing job.

You must define daily time slice definitions to have a from date at least three months prior to the current date. Remove any datamart extraction options as a datamart setting that is required for the job. This is a setting for the Datamart Rollup - Time Facts and Time Summary Job.

(Optional) Set up Datamart stoplights.

Configure the following Datamart settings:

• Datamart Currency
• Datamart Entity
• Datamart Extraction Options
• Project OBS Mapping
• Resource OBS Mapping

Restrictions

This job cannot run concurrently with the following jobs:

• Datamart Extraction

  Other instances of this job cannot exist.

• Datamart Rollup - Time Facts and Time Summary
• Delete Investments
• Import Financial Actuals
• Post Timesheets
• Post Transactions to Financial
• Recalculate Cost of Capital Fields
• Time Slicing

Parameters

None

More information:

Datamart Stoplights

How to Set Up the Datamart