I’ve defined a new dimension for cloned issues that is working pretty well.
With it, I can retrieve the time spent on one clones as seen here:
To do that I’ve defined a new calculated metrics “Clone Hours Spent”:
Now, as for the second step, I needed the sum of all “Cloned Hours Spent” by Roadmap (defined as a row and page), with the data above it would be something like this:
You may want check out a sample report in one of our demo accounts where linked issue information is used in the report (dimension Bugs contain linked bugs) and there are several useful measures used in the report to count linked bugs, hours spent on linked issues etc. and which you may modify and use in your case: Issues - eazyBI Demo Training - eazyBI
One of the examples could be Hours spent on Linked Bugs (in your case change the dimensions to yours):
[Issue].CurrentMember.Level.Name = "Issue"
[Bugs].Currentmember is [Bugs].Defaultmember
-- retrieve Bugs information from Issue property Bugs
-- total calculation for any issue, data on Bugs level
-- filter out Bugs with reference to Issue
[Time].CurrentHierarchy.Defaultmember) > 0),
-- search for Bug in Issue dimension, use in a tuple with measure, logged by and time, ignore anything else with DefaultContext
[Logged by].CurrentMember, -- allow selection by Logged by
[Time].CurrentHierarchyMember, -- allow selection by Time
But if this doesn’t suit your use case, can you send report definition as well as advanced settings on how you create linked dimension to support@eazyBI.com?
Gerda // eazyBI support team