Drill through issues error without error message

Questions & Answers
1

Hey all,

I’ve created a bugs backlog report with created - resolved issues by priority.
This code is an example of one of the priorities calculated:

–annotations.group = Bug Backlog Measures
CASE
WHEN CurrentTuple(VisibleRowsSet()).Item(0).Name = ‘$total_aggregate’ THEN
(([Measures].[Issues created],[Issue Type].[Bug],[Priority].[Medium]))+
(([Measures].[Issues created],[Issue Type].[Legacy Bug],[Priority].[Medium]))-
(([Measures].[Issues closed],[Issue Type].[Bug],[Priority].[Medium]))-
(([Measures].[Issues closed],[Issue Type].[Legacy Bug],[Priority].[Medium]))

ELSE
CatchException(
Sum(
Head(VisibleRowsSet(), Rank(CurrentTuple(VisibleRowsSet()), VisibleRowsSet())),
(([Measures].[Issues created],[Issue Type].[Bug],[Priority].[Medium]))+
(([Measures].[Issues created],[Issue Type].[Legacy Bug],[Priority].[Medium]))-
(([Measures].[Issues closed],[Issue Type].[Bug],[Priority].[Medium]))-
(([Measures].[Issues closed],[Issue Type].[Legacy Bug],[Priority].[Medium]))
)
)
END

It’s working really fine and with good performance but when I try to Drill on any of the priorities I’m getting an error message (returned fast, so no timeout) without description:

bug-backlog-ev
bug-backlog-ev1062×494 39.2 KB

Thanks in advance for the help
Best,
Danilo

2

Hi Danilo,

Unfortunately, such a construction used behind the cumulative calculation is not suitable for the drill-through operation in the report. As you may have noticed, the standard calculation of the cumulative does not allow the drill-through issue option since we can not see a feasible workaround for this limitation currently.

Kindly,
Janis, eazyBI support

1 Like
3

Many thanks Janis,
No problem. I’ll create an auxiliary report for that :slight_smile:

Best regards