Our install of TFS was done by an outside contractor and was not done well and I am not the Admin on the project so I am limited in what I can do. However, I have found some odd problems that I don't understand.
First of all, when I connect to the TFS analysis server I see the TFSdDataWarehouse but only see the main Cube, none of the perspectives show up. Is there a setting in TFS to create these?
Secondly, I took a look at the table structure and was able to create a query to get a basic code churn report, but only some of the change sets appear in the results. There are whole days that are missing. Any reason for this?