如何从头构建TFS多维数据集？ [英] How can one build the TFS cube from scratch?

问题描述

我们遇到了TFS多维数据集的问题。我不认为它已经建成，因为TFS安装。

We are having issues with the TFS cube. I don't think it has been built since TFS was installed. The warehouse seems to be working and has new data it just seems to be the cube that doesn't work.

我们尝试使用TFS管理员控制台重新构建它，但是这样做事情更糟糕，那里的数据被擦除，并被看起来像一个空白数据库。

We tried rebuilding it using the TFS Administrator Console but that made things worse, the data that was in there was erased and replaced by what looks like a blank Database.

我试图删除数据库，以便我可以看到是否实际上正在构建多维数据集，但现在当我运行重建它说它正在寻找一个现有的数据库，所以它赢了甚至尝试。

I tried deleting the Database so that I could see if the cube was actually being built but now when I run the rebuild it says it's looking for an existing Database so it won't even try.

现在我已经删除它，如何从头重建立方体？

Now that I have deleted it, how can I rebuild the cube from scratch?

推荐答案

即使我可以检索数据库它是空的，我想尝试从头开始构建它， >

Tfs_Warehouse从Tfs_CollectionA，Tfs_CollectionB等数据库中提取数据，Tfs_Analysis从Tfs_Warehouse数据库中获取数据。所以没有担心当Tfs_Warehouse和Tfs_Analysis被删除，它是允许创建一个新的。

The Tfs_Warehouse extracts data from Tfs_CollectionA, Tfs_CollectionB, etc databases, and Tfs_Analysis get data from Tfs_Warehouse database. So no worries when the Tfs_Warehouse and Tfs_Analysis is deleted, it is allowed to create a new one.

这里是如何让它工作的步骤：

Here are the steps how to get it work:

1. 在SQL Server Management Studio中从SQL实例中删除Tfs_Warehouse和Tfs_Analysis。


2. 打开TFS管理员控制台，转到报告节点，然后点击编辑。
   


3. 在报告对话框中，选择使用报告 。

1. Delete Tfs_Warehouse and Tfs_Analysis from SQL instance in SQL Server Management Studio.
2. Open TFS Administrator Console, go to Reporting node, and click Edit.
3. On the Reporting dialog, select Use Report checkbox. And fill the Tfs_Warehouse, Tfs_Analysis and Reporting information separately on Warehouse, Analysis Services and Reports tabs.

请检查此博客的详细步骤： http://social.technet.microsoft.com/wiki/contents/articles/20113.rebuild-tfs-warehouse-and-analysis-databases-from-scratch.aspx

Please check this blog for the detailed steps: http://social.technet.microsoft.com/wiki/contents/articles/20113.rebuild-tfs-warehouse-and-analysis-databases-from-scratch.aspx

此外，默认情况下，Tfs_Warehouse和Tfs_Analysis每2小时刷新一次。
您可以手动刷新多维数据集以获取最新数据： https： //msdn.microsoft.com/en-us/library/ff400237.aspx

In addition, by default, Tfs_Warehouse and Tfs_Analysis refreshes every 2 hours. You can manually refresh the cube to get the latest data: https://msdn.microsoft.com/en-us/library/ff400237.aspx

这篇关于如何从头构建TFS多维数据集？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！