Enterprise Insights - Backlog reports

Michael Holian

Has anyone had any success in creating a copy of the Jira Align Backlog screen into Analytics using EI? I'm not sure exactly how it is calculating Rank there and if it can be reproduced. We have a number of people we have to allocate licenses to because they must have access to the backlog view, and it isn't available to the Integrated User license.

Allan Maxwell

You need to join to the "Feature Rank Program Program Increment" table and use the "Rank" field.  The "Feature.Rank Program Increment" field does not have the value you are looking for.  See image below.

 

 

SELECT [Feature].[Feature ID], [Feature].[Feature Name], [Feature].[Rank Program], [prg].[Rank] AS 'table-Feature Rank Program',

 [Feature].[Rank Program Increment], [pi].[Rank] AS 'table-Feature Rank Program Program Increment'

FROM [current_dw].[Feature] [Feature]

LEFT JOIN [current_dw].[Feature Rank Program] [prg] ON [prg].[FK Feature ID] = [Feature].[Feature ID]

LEFT JOIN [current_dw].[Feature Rank Program Program Increment] [pi] ON [pi].[FK Feature ID] = [Feature].[Feature ID]

WHERE [Feature].[FK Program ID] = 77

AND [Feature].[FK Program Increment ID] = 77

ORDER BY [pi].[Rank];