Indicator UDF's are not supported in P6 Analytics. The main reason being there isn't currently a way to move those same indicator images over into OBI, and the images that are used for indicators in P6 don't exist in OBI. There are some workarounds that can be used to achieve (more...)
How can you tell what version of the P6 Reporting Database you have installed? There are two main ways.
1- Query the ETL_PARAMETER table with the following:
select p_feature, p_1 from etl_parameter
where p_feature = 'db.star.version'
or p_feature = 'etl.source.version';
The output will be similar to:
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...)