Error While Trying To Create OLAP Cube

Error While Trying To Create OLAP Cube

One of my customers failed to get up to date Reports from TFS.

Looking in one of the reports I saw that the last time the warehouse was update is Two Month Ago!

I tried to process the cube manually and this got nothing, so I checked the event log and I saw couple of errors related to the warehouse.

I tried to Rebuild the cube using SetupWarehouse.exe and get another error.
An unexpected error occurred: Some or all identity references could not be translated.

In the IIS I check TFS Application Pool and enter the right password for TfsService.

After that I search "Local Security Settings" under "User Rights Assignment" and didn't find Tfsservice in "Log on as a service".

I add TfsService to "Log on as a service" rule.

Then when trying to Rebuild the Cube I didn't get any error and the reports start working.

Hope this will help.