Can Months With No Data in the STAR Database Be Included in an Analysis, to Allow Functions Like 'Average' to Calculate Correctly in P6 Analytics? (Doc ID 2099853.1)

Last updated on SEPTEMBER 10, 2019

Applies to:

Goal

Is it possible to add months that have no data in the STAR database to an analysis so that functions like Average work correctly? For example when creating a report on Resource Utilization, there are months which are not displaying in the report.

Resource Name |  Month Name | Remaining Units
---------------------------------------------
Joe Smith     | 2015-07     |        66.38
              | 2015-08     |       143.29
              | 2015-09     |        48.00
              | 2015-10     |        90.78
              | 2016-03     |       136.00
---------------------------------------------
Average                              96.89

The average in this case is the total divided by the months displayed in the report 484.45 / 5 = 96.89

Ideally, the function would calculate the average over all months in the calendar, even those that have no data.  In the above example, the following months would need to be added to the report, but the STAR database does not contain rows for these months.
2015-11
2015-12
2016-01
2016-02
2016-03

Adding the "missing" months to the report would show the average calculated as 484.45 / 10 = 48.45
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.