Need help in finding project name in group resource aggregate monthly table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-22-2025 09:26 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-22-2025 07:05 PM
Hi @cn505666 ,
Thanks for raising the query with community.
As a best practice always explain your question so that team can understand and share the best response.
Below is the screenshot of resource_aggregate_monthly table and task provides the task idenrification number such as project id.
Hope this helps and if it does please mark the response as correct to help me and others in the community.
 
Happy SPM Learning!!
Thank You!
Namita Mishra
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-25-2025 05:52 AM
Let me explain the exact scenario: This requirement is pertaining to Resource management where utilization report over and under by resource group and by project has been provided in a pivot format. Now The users want me to add project name or short description, then must contain only BTS group, month starts on: current month + 2.
But when i am adding short description or task, it is giving me a message "Cannot generate the report. This report contains too much data to visualize. Add filter conditions to reduce the amount of data."
I was able to add filter condition for "must contain only BTS group" & "current month +2". But unable to add project name (could not find) or description. throwing me the above message mentioned in bold
Kindly help me with this please