Long Load Time For Report

Questions & Answers
1

Continuing the discussion from Report is taking long time to load if am using custom measure to get the count of issues if custom date field is empty:

I have the same problem, but i am trying to count/sum all the issues in a measure called issue sprint removed , but where the measure Sprint issues at closing is null

SUM(
Descendants([Issue].[Issue].Members, [Issue].[Issue]),
CASE WHEN ISEMPTY([Measures].[Sprint issues at closing]) THEN
[Measures].[Sprint issues removed]
ELSE
null
END
)

This formula works great but takes so much time to load and sometimes it doesn’t even load.

2

Hi @Nada

What is difference between your formula and predefined measure “Sprint issues removed”?

Are you saying that one issue can be added and removed from the same sprint multiple times? Is this why you use a complex query to calculate results?

Otherwise, I would recommend using the predefined measure “Sprint issues removed” as it is, because it is by definition, that when issue is removed from sprint, it will have “empty” value for measure “Sprint issues at closing,” and you don’t have to use complex queries to calculate results.

Martins / eazyBI support

3

Hey Martins,
thanks for you answer , the predefined measure “Sprint issues removed” is not counting the correct removed issue when i compare it with jira sprint report and it sometimes includes the issue that is not completed within the sprint , so when i did this formula :
SUM(
Descendants([Issue].[Issue].Members, [Issue].[Issue]),
CASE WHEN ISEMPTY([Measures].[Sprint issues at closing]) THEN
[Measures].[Sprint issues removed]
ELSE
null
END
)

it has counted the correct removed issues , but as i said it takes so much time to load and sometimes it doesn’t even load, is there any way to optimize it ?

4

i have updated the formula to this:

IIF(
IsEmpty([Measures].[Sprint issues at closing]) ,
([Measures].[Transitions from],
[Transition Field].[Sprint status],
[Sprint Status].[Active],
– An issue was removed from an active sprint
[Issue Sprint Status Change].[Active => (none)]
),
NULL
)

still have load issues

5

@Nada

please reach out to support@eazybi.com and provide the definition for your report.
There must be something else that makes the report slow with last version of your calculation.

Martins / eazyBI support