Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
If I understand well you split the global cost of the project linearly between the start and the end date. I would like to increase the accuracy by getting the planned cost per day. Pierre
-
hi,, Thanks for this answer. Which query do I have to use in your exemple ? Pierre
-
I have to adapt the Start date and End Date to the P6 query no ? What about <date: 1 day before project start date> ? does it remain like this ? Pierre
-
can you precise "Aliasing" ?? thanks
-
Must better !! But an other error occurs : ORA00904 B2.QteATarm is invalid. Now the code is : SELECT B1.Phase AS "Budget - Phase", B1.PhaseDesc AS "Budget - Phase - Desc", B1.Imput AS "Budget - Imput", B1.ImputDesc AS "Budget - Imput - Desc", B1.CRURef AS "CRU Ref", B1.id as "ID TACHE", B2.QteATerm AS "Qte A Term" FROM (…
-
Perfect !! Thanks a lot