Before you can use the Project Status Report Cache you it needs to be activated as follows:
Note: After activating the Project Status Report Cache you will have to perform a Project Status Report Cache Refresh to populate the cache.
To deactivate the Project Status Report Cache you should do the following:
When you select the Project Status Report Cache in BrightWork Reporter a view is not used for the default report. A custom report is created showing only the most recent report from each project site. This is determined by:
One default view is available out-of-the-box to BrightWork Reporter. This view Status Reports - Open Projects shows all items in the cache as this cache only contains reports from open projects.
Note: Only site collection administrators or members of the BrightWork Cache Administrators group can configure views in a cache.
For faster reporting, views can be configured as a means of filtering project status reports. Less items in a report, the faster it is!
To configure the views:
When configuring views there is no need to specify columns, grouping, or sorting. Instead only configure the filters as that is all that is used in Reporter.
We recommend limiting the amount of views you have in the project status report cache, as this may impact the refresh time of the cache.
It is also possible to add custom columns to the Project Status Report Cache so it can track your own custom data.