topic Re: Qlikview Dashboard on TFS in QlikView

Qlikview Dashboard on TFS

Fri, 25 Jan 2013 14:51:57 GMT

Hi all,

We're planning to build a Qlikview dashboard on Team Foundation Server to monitor developmentprogress, workitems, tasks...

Anyone who has experience with this, and feels like sharing? 🙂

Thanks in advance!

Wouter

Re: Qlikview Dashboard on TFS

kmn — Mon, 04 Feb 2013 09:06:44 GMT

Hi there,

Well first you need to get the data from TFS. Have you created a custom connector for that? If not, then I would suggest you start from here:

http://community.qlik.com/docs/DOC-2639

Re: Qlikview Dashboard on TFS

Mon, 04 Feb 2013 14:54:10 GMT

I can run MDX queries on the cube, but I would like to construct the cube myself by accessing the databasetables directly.

Re: Qlikview Dashboard on TFS

Thu, 29 Aug 2013 19:04:09 GMT

Try using one of the views that the TFS database has. I've read in one site that you can use WorkItemLatestAndWere (TFS2010) and I found it useful for most of my uses. I am not so sure about creating and/or accessing a cube - it sounds like more work to me if you can access the database tables anyway and you can use Qlikview to design and construct some sort of data store architecture by creating and storing qvds. Just my two cents.

Re: Qlikview Dashboard on TFS

Tue, 21 Jan 2014 17:05:20 GMT

A good article from Microsoft regarding the 3 layers of data TFS has is here. I would bet that accessing the "Relational Warehouse" layer would be the best bet for tapping in to TFS data. It avoids the complexity of the OLTP layer and the difficulty in passing MDX language to the pre-built cubes.

Creating and Customizing TFS Reports

Re: Qlikview Dashboard on TFS

Fri, 20 Feb 2015 08:35:48 GMT

Hello,

I'm trying to develop a dashboard based on TFS as well to monitor development. May I ask how did it go yours? Any sharing or guidance?

Best regards,

Ferran