This post is going to ignore Project Online as I am still a little underwhelmed by the reporting capabilities of the Excel+ODATA Power-shennanigans. Mostly I spend my BI days in SQL Reporting Services for our on-premise customers, and even our larger Project online customers are moving back to local BI storage and SQL RS. Anyway, rant over. So SSRS has been my friend for some years now and I continue to find new and interesting ways to make it do the things i want. However the real fun is down in the TSQL area. Here is a little selection of things I've found that may help you optimise or improve your report outputs. Large datasets and the AssignmentByDay data We all know that the MSP_EPMAssignmentbyDay table is a beast and is the main limiting factor when we look at time by period reporting. Yes it would be great if MS did an automatic aggregation to weekly periods as part of the publish job but that is never gonna happen. However it is pos...
sharing the love