Resource aggregate daily is not being updated when changes in resource allocation daily table.

[Aditya24]

I deleted one entry from resource allocation daily table for a user. Now I went ahead and did the update resource aggregate from the user profile. The updated hours after deletion of record from resource allocation daily is shown in allocation workbench, resource aggregate monthly and resource aggregate weekly as well but the resource aggregate daily still has that the old record and data. Why is that?

[abhinaykumar · Accepted solution]

HI @Aditya 

From Quebec, the resource aggregate daily values are no longer generated/updated. This change was made because the resource aggregate daily table continues to grow in size over time.

There will be no impact because we have thoroughly tested all of the features. Data is obtained from other tables(schedule for capacity, availability aggregates and resource_allocation_daily for other aggregates), so resource aggregate daily is not required, and wherever resource_aggregate_daily table is displayed, it is replaced with new grids that show similar data from Quebec.

Please see this article for more information on resource aggregate tables, and see the Enhancements made in the ‘Quebec' release related to Aggregates section for information on changes made to aggregates in Quebec.

If you need daily aggregates for custom logic, see How do I generate Daily Aggregates from ‘Quebec’ release on wards? section in the preceding article.

If my answer was able to solve your query please mark it as Helpful & Correct.

Thanks,

Abhinay Kumar Nandagiri.

[Aditya24]

Thanks Abhi,

I have read your articles, they are really good.