Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-7766

Add 'FK Sprint Program Increment ID' column to Enterprise Insights current_dw schema

XMLWordPrintable

    • 1

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      Background

      A Story's assigned Program Increment (EI equivalent Story.FK Program Increment ID) is determined by whether a parent Feature is assigned and if not, whether a Sprint is assigned. If both are assigned and the Story's Sprint and parent Feature do not share the same PI, there is no way in EI to make this distinction from the single FK Program Increment ID field.

      Request

      Add a new column to the Enterprise Insights current_dw Story table:

      Name = FK Sprint Program Increment ID
      Usage = populate with the Story's assigned Sprint's PI

            [JIRAALIGN-7766] Add 'FK Sprint Program Increment ID' column to Enterprise Insights current_dw schema

            Mark Dodrill added a comment -

            Also, this behavior makes it impossible (as far as I can tell) to generate the same metrics for number of Stories and total Story Points with EI data that is shown in the Program Room.

            As EI usage increases, this problem is going to become more and more apparent, and there currently isn't a workaround to get the expected data.

            Mark Dodrill added a comment - Also, this behavior makes it impossible (as far as I can tell) to generate the same metrics for number of Stories and total Story Points with EI data that is shown in the Program Room. As EI usage increases, this problem is going to become more and more apparent, and there currently isn't a workaround to get the expected data.

            Mark Dodrill added a comment -

            This is an important addition, because it's not obvious from the EI data that a different PI is being used (the parent's) in some cases and not in others.  This new field would always contain the PI that the Story is tied to, via the Sprint and Anchor Sprint for the Story.

             

            Mark Dodrill added a comment - This is an important addition, because it's not obvious from the EI data that a different PI is being used (the parent's) in some cases and not in others.  This new field would always contain the PI that the Story is tied to, via the Sprint and Anchor Sprint for the Story.  

              9ca9aa5ad14e Sam Tsubota
              1a93744f1bf8 Brandon Harris (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated: