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 · Accepted solution]

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];

[Allan Maxwell]

The rankings for each issue are contained in the following tables.  Which one you use depends on which issue type and whether by Portfolio/Program or Program Increment/or not

Capability Rank Portfolio
Capability Rank Portfolio Program Increment
Capability Rank Program
Capability Rank Program Program Increment
Capability Rank Solution
Capability Rank Solution Program Increment
Epic Rank Portfolio
Epic Rank Portfolio Program Increment
Epic Rank Program
Epic Rank Program Program Increment
Epic Rank Solution
Epic Rank Solution Program Increment
Feature Rank Portfolio
Feature Rank Program
Feature Rank Program Program Increment
Feature Rank Solution
Feature Rank Solution Program Increment
Theme Rank Portfolio

[Michael Holian]

I was looking for Rank in a particular PI. Many of the values come up blank. I am looking for Feature Rank, but the values for Rank Program Increment are null. The values for 'Rank Program' and 'Feature Program Rank' contain some values, but are also largely blank. None of them correspond to the Rank as shown.

Is there somethink wring with my data model?

[Allan Maxwell]

@Michael Holian The various ranks only get set when you change the rank of any issue in that backlog ...as I understand it.  For example, the Program Feature Rank for a PI will be null for all Features in that view until you change the ranking of any Feature in that PI backlog.  Once any change is made to the ranking of any Feature in that PI backlog, ALL Features in that PI backlog will have a rank.

If you add additional Features to that backlog, I believe they are unranked until --again --you move some Feature up or down the order backlog.

[Michael Holian]

OMG, what a feature that is!

[Michael Holian]

Allan, I do appreciate you pointing that out to me un them being unranked until you move something around.

so I moved items around (and back) to force the ranking. I see where the rank was set in the audit log, it says:

By Michael Holian on 11/19/2025 2:21:48 PM

Program[Planning Increment] Rank: Jira Epic 6229 was moved from unranked to 1

but after that yesterday, the data is still not showing in my query I have queried every rank field and they are coming up blank.

[Michael Holian]

Allen, thank you so much for your help! 

Your answer causes me to wonder why those fields show in the table at all. Also, I was looking for linked tables that might have that field in Visual SQL mode, but I did not find them, I'm wondering is there is an opportunity to improve the tool by removing fields that are not populated and including relationships that should be represented in Visual SQL Mode.

[Allan Maxwell]

@Michael Holian I agree; why denormalize one ranking and not others?  We have seen that the [Feature].[Rank Program] is always the same as [Feature Rank Program Program Increment].[Rank].  It represents the Features rank for a specific Program and in a specific Program Increment.

The other "rank" field that is on the [Feature] table --[Rank Program Increment] --remains somewhat of a mystery to me.  In my test instance, there are very few Features that have a value for that field.  For those Features the value is not a mere copy of the [Rank] from one of the other tables like it is for [Rank Program].

It is possible that it is set only on import or by one of the "pull rank down" operations.

In my opinion, the lesson is to always use one of the Rank tables:

• Feature Rank Portfolio
• Feature Rank Program
• Feature Rank Program Program Increment
• Feature Rank Solution
• Feature Rank Solution Program Increment