After upgrading to TFS 2013, the TFS OLAP Cube fails processing with one of the following messages:
Invalid column name ‘System_AssignedTo__Name’.; 42S22;
Invalid column name ‘System_AssignedTo__SID’.; 42S22
Query execution failed for dataset ‘ds[Whatever]‘
Found in Jeff Hunsaker’s blog post:
- In TFS Admin Console, look up the account under “Account for accessing data sources” under the “Analysis Services” tab (Reporting » Edit).
- In SQL Server, add that account to the Tfs_Warehouse database, to the TFSEXECROLE role.