Add Columns to the Project Status Report Cache

Add Column to Project Status Report Lists
Add Column to Project Status Report Cache
Update Column Mapping
Add Column to Cache Report

When configuring Project Status Report lists with additional columns you may want to include these columns in Project Status Report Cache reports. This topic explains the steps on how to do this.

Add Column to Project Status Report Lists

Before you begin it is assumed you have added columns to SharePoint lists.

Add Column to Project Status Report Cache List

First, you need to add a column to the Project Status Report Cache list. This list is hidden to prevent accidental editing. The only time you typically need to access it is when you need to add columns or to add a view.

1. Navigate to the site collection home page, paste 'bwPSRCache' after the site name and click Enter on your keyboard to open the hidden Project Status Report Cache list. For example the URL should be something like:

   https://myserver/sites/mysitecollection/bwPSRCache

2. Add a column to the Project Status Report Cache using the appropriate column type.

Use the same column type in the Project Status Report Cache as the source list. For example; if the column is a Date and Time column in the list, create a Date and Time column in the Project Status Report Cache.

If you are adding a choice column to the Project Status Report Cache list, we recommend the default value is left blank.

We do not recommend adding Site Columns to the Project Status Report Cache list.

The name you use to add the column to the Project Status Report Cache list doesn't really matter as you will be mapping it in the next step; however, we recommend the same or a similar name to make the mapping maintenance process easier. Also, we recommend not including a space in the name to avoid SharePoint encoding the space.

Update Column Mapping

Next, you must update the global PSRCacheGlobalSettings.xml mapping file. This file maps columns from the supported lists to Project Status Report Cache columns.

1. Open the top level site of your site collection in SharePoint Designer 2013. For example, the URL should be something like: https://myserver/sites/mysitecollection
2. Click All Files | _catalogs | bwConfigStore | PSRCacheGlobalSettings.xml
3. Click Edit File to open the file for editing.

4. Add an XML tag to the appropriate list template, for example:

   <Field target="YourWorkCacheColumn" source="YourListColumn" />

The Project Status Report Cache list supports the addition of calculated columns. You do not need to add these columns to the ProjectStatusReportCacheGlobalSettings.xml file.

The PSRCacheGlobalSettings.xml is for specifying global mappings in a BrightWork site collection. Every site also has its own PSRCacheSettings.xml file.

If the column you want to map has a different internal name in a certain site (for example, one project template uses a column called Organization and the rest use a column called Department), update the local PSRCacheSettings.xml with the appropriate mapping information and it will override the global setting specified in the top level PSRCacheGlobalSettings.xml file.

Changes to the PSRCacheSettings.xml file are automatically included in Design Sync. This means that changes to this file should be made in the Template and synced, if Design Sync is being used.

Add Column to Cache Report

Finally, add the column to the Shared or Personal report that uses the cache.