Task duration(diff. between start and end of task) can be calculated using user-defined fields(measures).
1. Create a report on 'Project Task' fact
2. Create a custom user-defined field(measure) using any of the following formula using the "Count Function"
3. Have Project Name/Id in the Row Field, Task Name/Id in the Detailed Field and Project Type in the Page Field
4. In Refine Data page, select Project Type = Sourcing Project
Thanks for the response, however unfortunately this does not work for me. Have you tried this out ?
As I understand the count function on a singular date would yield a result of 1 always regardless of the date. The count function by definition is supposed to return the number of items in a collection and since a single date is a collection of only one item, the result is always 1.
Thus, subtracting count (End Date) from count (Begin Date) would be equivalent to 1-1 and would always yield the result 0.
Let me know if i am doing something incorrectly.
Yes you are correct. I tried this out now.
Something like following is needed in this case but unfortunately this cannot be implemented using analysis reporting.
So it appears that this cannot be achieved using the reporting applciation.
So the only option I see is to have the Start and End dates of the task in report and after exporting in Excel, the excel functionality can be used to derive the diff of days.
I have investigated your requirement further and I have found out a very simple way to accommodate your requirement.
For 'Due Date less Begin Date' you will simple need to copy-paste the formula "sum(DueDate.Day-BeginDate.Day)" and validate.
For 'End Date less Begin Date' you will need to copy-paste the formula "sum(EndDate.Day-BeginDate.Day)" and validate.
Please refer to the screenshots below:
Thanks & Regards,
Tuhin (Tuhinadri Biswas) | Technical Resolution Team | Ariba, Inc.
did you try using the Duration measure on the Project Task fact? The Duration measure contains the number of days between the task start date and the task end date. Give this a try and let me know if it works for you.
Hope it helps.
Ariba Analysis Product Mgr.