Explanation of History Settings for P6 Analytics
By Jeffrey Mcdaniel-Oracle on May 23, 2013
This blog applies primarily to P6 Analytics\P6 Reporting Database 3.1. As of 3.1, history was introduced at a daily level at the activity level. Activity level history existed as of P6 Analytics 2.0\P6 Reporting Database 3.0 but was only at the interval level of week, or higher. The settings in P6 for history level and history interval haven't really changed too much, but their meaning has changed. These history settings are on the project level and are defined project by project. This gives flexibility to include lower levels of history for ONLY those projects that require it. These settings are defined on the Project Preferences section of P6.
Choosing activity level history can cause your data warehouse to grow extensively based on the amount of changes and size of projects. If setting projects on activity level history you should first review the Planning and Sizing guide and make sure you have the required space of growth.
If you choose history level = Activity (internally HL_Task), then this project now has Daily history turned on as well as:
If you choose Project or WBS level history the history interval setting would apply. History always rounds up. If you choose Activity, you automatically are opted in for Project and WBS history also. If you choose WBS history you get Project history as well.