Reporting on Workflow Approval Status with PowerPivot

Playing with workflow a bit this month, and trying to come up with an easy way to develop a report on workflow tasks.  Now, if you’ve used workflow in Project Server, you know that the tasks are stored in the Project Workflow Task List.

image

…which includes the Project UID, but may not include other custom fields such as Department or Project Manager.

So my goal for this post is to merge this table with the EPMProject_UserView table within the database and then turn it into some sort of reportable format.  And what tool should we turn to when we need to combine multiple tables from disparate data sources?   PowerPivot – which is a free download in Office 2010, and out of the box in Office 2013.

In this case, I open up PowerPivot and point it at the Project Server Workflow Task List.

image

Then I open another table pulled from the EPMProject table within the Reporting Database.

image

Then I add a join using the Project UID.

image

From there, it’s just a matter of adding a PivotTable into Excel…

image

..and after some manipulation in Excel, I end up with the following:

image

Not the fanciest report, but it will suffice for my purposes.

Advertisements
Reporting on Workflow Approval Status with PowerPivot

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s