:: infotechGuyz.com ::
> For the IT community by the IT community

• BlackBerry Server (BES)
• Excel Macro/VBA
• Exchange 2007
• Exchange 2010
• Lync 2010
• Scripting/Command-line
• SQL Server 2008
• SQL Server 2012
• Team Foundation Server
• VMware
• Windows 7
• Windows 8
• Windows Server 2008
• Windows Server 2012

Processing Data Warehouse and Analysis Services Cube

You may need to procedure the warehouse or cube manually to transfer data into the warehouse or cube on demand. The warehouse allows SQL Server SRS and contains data for VS Team Foundation Server.

During usual operations, the relational DB (Tfs_Warehouse) is processed within two minutes of changes made to the operational store, but the SQL Server Analysis Services cube is handled every two hours. You can change the refresh interval or process the data warehouse via Warehouse Control Web service.

You may need to process the warehouse DBs manually if:

• The task updates for his team do not appear in his reports for the project manager or your boss. The Analysis Services cube need to be updated for her reports to contain the latest update.
• The admin for Team Foundation notices that several errors that are linked to warehouse jobs appear in the event viewer on several application-tier servers. He must manually process the warehouse for each team project collection to collect info to troubleshoot the issue.
• Verification of schema conflicts that happened are now resolved. To verify that no more schema conflicts arise, you must process each team project collection.

By processing the warehouse, you help guarantee that reports are up to date. You can process whichever the relational DB or the cube. The time that is required to finish processing be subject to on how much data is in the warehouse. Before you process either DB, you should define the processing status and ensure that the status returns Idle for the synchronization job you wish to run.

 

Accessing Warehouse Control Web Services in TFS

1. RDP to TFS application-tier server.
2. Browse to below URL:
   http://localhost:8080/VirtualDirectory/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx

Monitoring the Processing Status of the Data Warehouse

Click GetProcessingStatus, and then click Invoke from WarehouseControlWebService screen.

The processing status for the following jobs appears:

• Build Warehouse Sync
• Common Structures Warehouse Sync
• Test Management Warehouse Sync
• Version Control Warehouse Sync
• Work Item Tracking Warehouse Sync
• Full Analysis DB Sync
• Incremental Analysis DB Sync

 

Processing the Data Warehouse DB in TFS

1. Browse to WarehouseControlWebService page, choose ProcessWarehouse, and then click Invoke.The service returns True when it effectively starts processing of the warehouse and False if it is not successful. A value of False designates that the warehouse is presently being processed.
2. To figure out when warehouse has been processed, back to the WarehouseControlWebService page, click GetProcessingStatus, > Invoke.

To manually process the cube:

1. Browse toWarehouseControlWebService page >ProcessAnalysisDB.

2. On the ProcessAnalysisDB page, in processingType, enter either Incremental or Full, and then click Invoke.
   Note that if you specify Incremental, data is handled only if it has been added since the most recent processing. If you specify Full, all data is processed as if the warehouse were being rebuilt. Full processes take longer to perform and should be performed only when required (for example, when a team project or project collection has been removed or deleted).

3. To determine when the cube has been processed, return to the WarehouseControlWebService page, click GetProcessingStatus, and then click Invoke. Cube processing is accomplished when the GetProcessingStatus service returns a value of Idle for the following jobs:

• Full Analysis DB Sync
• Incremental Analysis DB Sync