Purchasing Targets ETL Processing

This is the ETL execution process for the FILE_PURCH_TARGET_FS dataset.

During ETL execution:

1. Target records are loaded from FILE_PURCH_TARGET_FS.

2. The records are validated and processed.

3. Target values are stored in the analytics repository.

4. Procurement dashboards retrieve these values to calculate:

   • Target Achievement

   • KPI Variance

   • Performance Trends

   • Business Unit Scorecards