Thursday Dec 27, 2012

When is the scripts directory updated?

Each time the configuration utility is run to completion the runsubstitution.cmd or .sh is run. This action takes the scripts in the \etl\oracle\templates folder and populates the \scripts directory with updated versions based on these templates. At this time variables are replaced in the template scripts and added to the \scripts directory.

If there are any files in the \scripts directory that have been updated that you wish to keep as part of the ETL process the best way to do so is replace the template file to ensure those changes are not overwritten. Whenever replacing or updating a template always make sure to create a copy of the original file outside of the \etl folder. \scripts is an active, live directory. \etl\oracle\templates is the archived version of what is to be used in any further ETL processes if there are any configuration updates.

Also as of P6 Reporting Database 3.0 there is a directory called 'user_scripts' in the \scripts folder which is used for executing custom ETL additions.  See P6 Reporting Database 3.0 Installation and Configuration guide for more information.  


Friday Dec 07, 2012

How activity id affects calculations such as schedule % complete when using a baseline?

Fields such as schedule % complete, planned value costs, etc. that use a baseline to help determine the value depend on the activity id's to match between the baseline project and the current project. If the activity id is changed the link is broken. In the P6 power client there is an internal guid that allows you to change the activity id in either the baseline or current project and still have these values related. In the P6 Reporting Database the activity id is used as the joining characteristic between which activities are a match between a baseline project and a current project.
About

Provide new information on P6 Analytics and Reporting Database.

Search

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