Data Administration › Datamart Jobs

Datamart Jobs

The Datamart extracts project, financial, and resource management data from CA Clarity PPM. The Datamart delivers a number of stock high-performance reports. Datamart reports provide excellent performance when compared to other reports because of the reduced query complexity and flattened table structures. You can also write reports against the Datamart schema.

The Datamart provides the following:

• Stock reports
• Project and resource data points
• Data that is organized by fiscal or calendar periods and OBS
• Data that is aggregated and stored in an easily understood roll-up tables
• Support for alerts (stoplights) and trending analysis
• Protection from transaction database schema changes (when you customize reports or implement business intelligence applications)

The Datamart also:

• Extracts data from the transactional system into the NBI_DIM% dimension tables
• Extracts project, financial, and resource management data from the transactional system into the NBI% Datamart tables
• Rolls up project and resource data into the NBI%TIME_SUMMARY summary tables

Note: See the Technical Reference Guide for more information.

You can set up a Datamart Extraction job to run daily and extract data from the transactional database tables and store them in the Datamart reporting tables. Once data for a project or resource is extracted into the Datamart, the data is automatically refreshed during subsequent Datamart extraction jobs. The Datamart job extracts only those changes made since the last job. Any changes you make to OBS units and their hierarchies are automatically reflected in the Datamart tables each time the Datamart Extraction job runs.

The Datamart Extraction job uses a lot of system resources. For best results, run this job once daily during periods of low or no user activity and avoid peak system hours.

The Datamart is comprised of the following jobs:

Rate Matrix Extraction

Extracts rate matrix data. Run this job each time you change the rate matrix or a project’s financial properties.

Frequency: Optional or run daily before the Datamart Extraction job

Datamart Extraction

Extracts data from transactional database tables and stores them in reporting tables. These tables are the foundation of most stock reports and some custom reports.

This job cannot be run at the same time as the Import Financial Actuals job.

Frequency: Daily

Datamart Rollup - Time Facts and Time Summary

This is the time facts and summary job that populates the following time tables:

• NBI_PM_PT_FACTS
• NBI_FM_PT_FACTS
• NBI_RT_FACTS
• NBI_PM_PROJECT_TIME_SUMMARY
• NBI_FM_PROJECT_TIME_SUMMARY
• NBI_RESOURCE_TIME_SUMMARY

For best results, run this job after the Datamart Extraction job. You should also run it when a custom report depends on the output of any of the time tables.

Frequency: Daily.

For best results, you should schedule the Time Slicing job before you run the Datamart Extraction job. The Datamart extraction gets data from the time slice table.