Fwd: Analytics - Custom Task Report including task owner

[Luanne]

Forwarding to the Dev group...

---------- Forwarded message ----------
From: Jesse <jbag...@gmail.com>
Date: Jan 25, 10:27 am
Subject: Analytics - Custom Task Report including task owner
To: VersionOne-users

I am trying to build a custom report to display tasks, including the
owners of the tasks. I cannot seem to get the correct values for the
task owner, and it is not included in the Task and Test Details report
table in the analytics tool.  Any advice would be appreciated.

[Adam]

Owner details are a related bridge table (not a Dim table) since there
can be 0 to many owners assigned to a task or test. In the Data tab,
select, at a minimum, "A Workitem Report", "Asset Type", "Date", "Task
and Test Details" and "WorkitemOwner" -- the bridge table. "Owner
Details" should be selected automatically after selecting
"WorkitemOwner". Parameterize for Date.Date=Today and AssetType in
list Task and Test. Then include appropriate fields within Column
Configuration, including "Task and Test Details".Name and "Owner
Details".Name.

Note these are inner joins by default and so at this time Analytics
can only include tasks and tests that have at least one owner.

Cheers,
Adam