Where does TFS_Analysis Live ?

Question

 

Here is the mystery,

According to the TFS Admin Console wizard, Analysis services are setup and WORKING, e.g. the Test Connection works

However in SQL we have the below ?

Where is it hiding ?

Do i need to run X to create it even though the connection test says OK ?

 

Thanks

 

Extra bonus points if you can explain the TFS_Warehouse and TFSWarehouse DBs (the former being the one referenced in reports), something to do with TFS 2008 upgrade ?

ReportServer
ReportServerTempDB
TFS_Configuration
TFS_OOSA
TFS_warehouse
TFSWarehouse

(OK, IE would not let me submit, submit triggers cancel, Firefox would not let me add picture)

Answer 1

Greg,

Analysis services database is running under the context of Analysis Services and that is why you do not see it in you list of the databases.

If you make a connection with the SQL Server Management Studio and use the analysis services Server Type you'll see your Tfs_Analysis cube/database

As for the list of your databases TFSWarehouse is the old warehouse database.

Check also here for some more details:

http://social.msdn.microsoft.com/Forums/en-US/tfsreporting/thread/6b369e57-80b5-43cf-9bfc-da41f6045fbe (Tfs_warehouse and TFSWarehouse DB present after upgrading)

---

Please remember to mark the replies as answers if they help. --- Success, Damir