How to sum original estimate - no time dimension on all hierarchy levels?

[Ales_Leskovar]

Hello,

I would like to have a report where I can see all hours spent by users in some time interval. I am a beginner at this. I succeeded to get the right info on the issue level (created calc member for original estimate without time dimension) but not on a project or other levels. I use dimension Logged by, Issue, Time - in pages and have created two calculated members.

I need help

Original estimate - no time dimension

IIf
([Issue].CurrentHierarchy.CurrentMember.Level.Name="Project",
  0,
  ([Measures].[Original estimated hours],
  [Time].CurrentHierarchy.DefaultMember
  )
)

test calculated member

CASE WHEN
    [Issue].CurrentHierarchyMember.Level.Name = 'Issue'
THEN
    CASE
        WHEN [Measures].[Hours spent] <= 0
        THEN 0
    END
ELSE
  --(Filter(
  --[Logged by].CurrentMember,[Logged by].[User],
  --[Logged by].CurrentMember.Members > 0),
    Sum(
        Filter(
            -- iterate through Issue dimension "Issue" level
            Descendants([Issue].CurrentMember,[Issue].[Issue]),
            -- return a set of issues matching condition
            [Measures].[Original estimate - no time] > 0
        ),
        -- evaluate the set of issues over the measure below
        [Measures].[Original estimate - no time]
    )
    --)
END

[Ales_Leskovar]

Any idea ? I hope you understand what I am asking.

[janis.plume]

hi,

The Original estimate - no time dimension formula returns zero at the project level. I cannot see why the IIF function should be in the formula.

If your use case is to have at the project level the total estimates for the issues with hours spent in the selected period, the formula could be the following:

    Sum(
        Filter(
            -- iterate through Issue dimension "Issue" level
            Descendants([Issue].CurrentMember,[Issue].[Issue]),
            -- return a set of issues matching condition
            [Measures].[Hours spent] > 0
        ),
        -- evaluate the set of issues over the measure below
        [Measures].[Original estimate - no time]
    )

Kindly,
Janis, eazyBI support