In the first part we discussed the types of slowly changing dimensions available in P6 Analytics and P6 Reporting Database.
Now lets look at how you would view the data. If you connected to your Staruser schema and queries w_project_hd you would be looking at your type 2 SCD (more...)
In P6 Reporting Database and P6 Analytics versions 3.1 a metadata feature was added to allow for altering of calculations and a way to add new calculations. There is already an existing path for adding new scripts - user_scripts. User_scripts will allow you to establish new steps in the (more...)
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 (more...)
The P6 Analytics product is driven by Facts. When you are looking at a subject area, take Primavera - Activity for example. You can add from the Project Dimension Project Id and Project Name. This will list out all projects in the w_project_d dimension table. In your Analysis if you (more...)