Couldn't find Project '% Complete' in DWH tables

[Jeevana Battu]

Hi,

I couldn't find Project '% Complete' in DWH tables, even could not able to select '% complete ' field in Project object to copy it in DWH tables.

Please help on getting this field in DWH tables for reporting purpose.

Thanks,
Jeevana.

[Martti Kinnunen]

Interesting to hear the official explanation.
There must be a reason why it cannot be selected for DWH.

As a project can have any of the three optional calculation methods it is quite unpredictable when the value will be updated for a given project. 
So not a good candidate for precise reporting.

[Nika Hadzhikidi]

Hi Jeevana

Some fields cannot be selected for DWH because they are already included.

% Complete is added on Task Object : 

To get the Project values you may just have to aggregate them in your report.

Hope this helps -Nika

------------------------------
Nika Hadzhikidi
Sr Principal Support Engineer
Broadcom
------------------------------

[Jeevana Battu]

Thanks Nika, this is helpful.