The Project Cache report data source, available in BrightWork Reporter, ensures Project reports in Project Areas, sites created using the Project Office template, and Portfolio reporting sites load instantly. The Project Cache data source is primarily designed as an alternative to reports that use the All Project Summaries report definition.
Reports in the Project Areas and Project Office use the Project Cache by default. If this is not the default for your site, you can switch the reports to use the Project Cache by following the steps here.
All data changes in Project Statement lists, Project Metrics lists and Projects Tracker lists are written to a hidden list at the top of the BrightWork site collection. If you select Project Cache as a data source, BrightWork Reporter only has to query this list instead of all the relevant lists in all the sites in the hierarchy.
Note: The Project Cache is security smart - it will only show users the sites and Project Statement and Projects Tracker list items they have access to.
The Project Cache does take account of list-level security on the Project Metrics list.
The legacy Project Schedule list is not directly supported by the Project Cache. To get Project Schedule data into the Project Cache, you can create Metrics that report on the data you want.
The Project Cache is maintained by a timer job that you can also run manually.
The out-of-the-box Project Cache reports on the Project Statement and Projects Tracker list columns and metrics available in the out-of-the-box templates. If you have added columns to a Project Statement or Projects Tracker list, or metric items to the Metrics list in your templates, you will have to manually add and map these columns to the Project Cache, to include them in reports that use the Project Cache as a data source.
Note: When filtering the Project Cache, selecting All items shows everything in the Project Cache. Selecting the All Projects view will automatically exclude Archived projects and only include Project Statements meant to be reported upon. See the Site and Project Statement Filtering topic for more details.