What files does Datamart Extraction job use during execution?

Products

• Clarity PPM On Premise

Issue/Introduction

We have a custom job that is using NBI tables (such as nbi_dim_obs ). We observed that our custom extract fetches blank columns when the custom job interferes with Datamart Extraction during execution. 

How does the Datamart Extraction job work and what files does it use?

Resolution

The datamart is a series of stored procedures invoked by Clarity’s job scheduler.

The main stored procedure is NBI_EXTRACT_SP which in turn call other stored procedures.

NBI_EXTRACT_SP => NBI_EXTR_PCF_SP => NBI_PROJECT_CURRENT_FACTS => NBI_PROJECT_FORECAST_SP

Some of these procedures in the course of execution truncates and repopulates some tables.

Do avoid querying the Datamart tables when the job is executing as this can also cause an undesired results.