the easiest way to report on actual effort per date per resource in Clarity

[Dimitris Tranoudis]

What is the easiest way to report on actual effort per date per resource in Clarity?

From what I see, the daily effort values are stored in a BLOB structure, which makes it impossible to directly access them via standard reporting tables or the new Reports (Beta) engine.

Any hint/idea on how to retrieve them would be appreciated.

[Martti Kinnunen]

You would have to have time slicing job running. Then you would have the daily actuals blob slice in PRJ_BLB_SLICES_D_ACT

[Suman Pramanik]

With the new reporting its pointing to DWH and in DWH everything is flat, can you please explain which data provider you are using.. 

[Dimitris Tranoudis]

Thank you Martti.

Thank you Suman,

unless I have misunderstood sth, the TimeEntry Entity does not have any date field for the Daily Actuals.

[Suman Pramanik]

Time entry is against a task at lowest level and rolls upto project, so you will have to join against task which will have start and end date.

[Dimitris Tranoudis]

Thanks Suman, 

The request here is to produce the line:

investment > task > date > actual effort

and not the

investment > task > from start to finish > total task actual effort.

As is the case in Financial Plans with the Actual Transactions split per date:

[Suman Pramanik]

I dont think we have out of box data provider Actual transactions via cost plan... 

[Dimitris Tranoudis]

Thanks Suman.

Following up on this — is there any alternative to Martti’s suggestion for retrieving daily actuals per resource per task, with the same granularity as registered in the timesheet?

We need to produce a detailed report on the activity of resources across projects and per task and per date.

[Suman Pramanik]

Look at the report Investment Time and Estimate Review, that will give you the output you are looking for. Then you can take the query and build custom report data provider and use the new reporting workspace.