Clarity PPM: Is the Datamart Extraction Job and Datamart Rollup Time Facts and Time Summary Job required?

Document ID : KB000018756
Last Modified Date : 15/01/2019
Show Technical Document Details
Question:

What data does the Datamart Extraction job prepare and is this data required for the successful operation of the Clarity application? Can we deactivate this job and not use it?
What about the Datamart Rollup job? Can we deactivate this job?



 

Answer:

Both jobs are required, in the event of data corruption.

The Datamart Extraction job is required to run nightly because the job populates the core data points described below.

The Datamart Extraction Job calls several stored procedure to populate the following tables:

NBI_DIM_OBS and NBI_DIM_OBS_FLAT, which are needed for OBS references
NBI_DIM_CALENDAR_TIME, which is needed for  all non-fiscal time-scaled varying (TSV) grids
NBI_DIM_FISCAL_TIME, which is needed for all fiscal TSV grids and financial processing

Essentially, all portlets rely on the successful completion of the job.

The remaining actions of the Datamart Extraction job populates other NBI tables used to summarize or rollup data based on daily sliced data. The data in these other NBI tables are not required for standard Clarity functionality and are meant for customers to use in custom reporting. The execution of the remaining data is dependent on the configuration of Time Slice Definitions, Resource and Project activities that generate event records in the NBI_EVENTS table.

Reference Clarity PPM product documentation guides for information on Datamart Settings and Financial Management minimum configuration setup.

Additional Information:
https://comm.support.ca.com/kb/datamart-technical-white-paper/kb000027221