Monitoring Dimension and History Level Impacts on the Database

Primavera Data Warehouse includes slowly changing dimensions and daily level history for activity and resource assignment. If you choose to use slowly changing dimensions and these levels of history, they could cause the Primavera Data Warehouse database to grow quickly. For example, if you update 10 activities in a project and run the ETL process, 10 rows will be added in the activity slowly changing dimension table and in the assignment history and activity history fact tables.

You should plan the database and server configuration to ensure you can monitor database growth and allow for expansion based on the number of changes. If growth is exceeding what you expected in your environment, you can disable slowly changing dimensions if they are not required. See the Primavera Analytics On-Premises Administration Guide for more information.



Legal Notices | Your Privacy Rights
Copyright © 1999, 2020

Last Published Monday, December 14, 2020