Hi everybody!
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”:
DefaultContext((
[Issue].[Issue].GetMemberByKey([Cloned from].CurrentMember.key),
[Measures].[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:

Thanks!
Hi @Miguel_Silva,
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):
Case
When
[Issue].CurrentMember.Level.Name = "Issue"
AND
[Bugs].Currentmember is [Bugs].Defaultmember
Then
-- retrieve Bugs information from Issue property Bugs
Case when
not isEmpty([Issue].CurrentHierarchyMember.Get('Bugs'))
then
NonZero(SUM(
[Issue].[Issue].GetMembersByKeys(
[Issue].CurrentHierarchyMember.get('Bugs')),
DefaultContext((
[Measures].[Hours spent],
[Issue].CurrentMember,
[Time].CurrentHierarchyMember,
[Logged by].CurrentMember))
))
end
Else
-- total calculation for any issue, data on Bugs level
NonZero(SUM(
Filter(
Descendants([Bugs].Currentmember, [Bugs].[Bugs]),
-- filter out Bugs with reference to Issue
([Measures].[Issues created],
[Logged by].Defaultmember,
[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
DefaultContext((
[Measures].[Hours spent],
[Issue].[Issue].GetMemberByKey([Bugs].Currentmember.Key),
[Logged by].CurrentMember, -- allow selection by Logged by
[Time].CurrentHierarchyMember, -- allow selection by Time
[Bugs].DefaultMember
))
))
End
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?
best,
Gerda // eazyBI support team