Thursday May 23, 2013

Explanation of History Settings for P6 Analytics

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. 

http://www.oracle.com/us/products/applications/primavera/p6-reporting-database-wp-399110.pdf

 If you choose history level = Activity (internally HL_Task), then this project now has Daily history turned on as well as:

- Type 2 slowly changing dimensions for all aspects of this project
- Activity spread data on daily level and historical facts
- Resource assignment spread data on the daily level and historical facts.  
This can produce a large amount of data. If the project finishes or gets to a point where you no longer need to see this level of granularity it is recommended to turn down the level of history to either Project or WBS.

If you have chosen history level of Activity, the setting for history interval now becomes relevant for the Project and WBS history.  You can choose week, month, etc. for the interval of time to be captured for Project and WBS history. This history interval does not apply to the Activity history because Activity is always Daily once chosen.

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.  

About

Provide new information on P6 Analytics and Reporting Database.

Search

Categories
Archives
« May 2013 »
SunMonTueWedThuFriSat
   
1
2
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
24
25
26
27
28
29
30
31
 
       
Today