Jira Align EI enhancements and features version 10.114.X


Vector.png

The old navigation will be removed from Jira Align in early 2024.
Learn more about the upcoming changes


Jira Align's Enterprise Insights (EI) was updated and deployed to 10.114.X instances on the continuous track on December 16, 2022, and will be deployed to instances on the bundled track on December 20, 2022. The following enhancements were made:

Release highlights

  • New content:
    • JIRAALIGN-4371 - New tables for key results override scores and notes for goals and objectives
    • JIRAALIGN-4421 - Updates to the Epic, Capability, Feature and Story Acceptance Criteria tables to support acceptance criteria notes and rank data
    • JIRAALIGN-4455 - New Program Increment Weeks Override table for supporting override weeks set in Plan Capacity on Forecast
    • JIRAALIGN-4463 - Update to Forecast Buffer table to add new column for buffer member week
    • JIRAALIGN-4485 - Update to the Team table to add Solution ID foreign key for creating relationship between team and solution
    • JIRAALIGN-4562 - New table for cost centers.
    • JIRAALIGN-4611 - Update to the Hierarchy table to add new column for supporting status set in custom rooms
    • JIRAALIGN-4610 - Updates to the Epic Forecast and Capability Forecast tables to add new column for supporting In Scope flag set on Forecast
  • Defect fixes: 
    • JIRAALIGN-4530 - Enterprise Insights ETL to now update current_dw.[Jira Custom Team Mapping]
    • JIRAALIGN-4420 - Deleted Discussion records for Epics now removed from current_DW.Discussion
    •  

New tables

View Name

Description

Cost Center

Added Cost Center object.

  • [Cost Center Description] NVARCHAR(500) NULL
  • [Cost Center ID] INT NOT NULL PRIMARY KEY
  • [Cost Center Name] NVARCHAR(50) NULL
  • [Cost Center Region] NVARCHAR(50) NULL
  • [Date DW Modified] DATETIME NOT NULL
  • [Deleted Flag] VARCHAR(3) NOT NULL
  • [FK User Owner ID] INT NOT NULL
Goal Score Override

Added Goal Score Override object.

  • [Current Value Flag] NVARCHAR(3) NULL
  • [Date Updated] DATETIME NULL
  • [FK Goal ID] INT NOT NULL
  • [FK User Created By ID] INT NOT NULL
  • [Override Notes] NVARCHAR(MAX) NULL
  • [Score Override ID] INT NOT NULL
  • [Score Value] FLOAT NULL
Metric Score Override

Added Metric Score Override object.

  • [Current Value Flag] NVARCHAR(3) NULL
  • [Date Updated] DATETIME NULL
  • [FK Metric ID] INT NOT NULL
  • [FK User Created By ID] INT NOT NULL
  • [Override Notes] NVARCHAR(MAX) NULL
  • [Score Override ID] INT NOT NULL
  • [Score Value] FLOAT NULL
Objective Score Override

Added Objective Score Override object.

  • [Current Value Flag] NVARCHAR(3) NULL
  • [Date Updated] DATETIME NULL
  • [FK Objective ID] INT NOT NULL
  • [FK User Created By ID] INT NOT NULL
  • [Override Notes] NVARCHAR(MAX) NULL
  • [Score Override ID] INT NOT NULL
  • [Score Value] FLOAT NULL
Program Increment Weeks Override

Added Program Increment Score Override object.

  • [FK Portfolio ID] INT NULL
  • [FK Program Increment ID] INT NOT NULL
  • [FK User Updated By ID] INT NOT NULL
  • [Program Increment Weeks Override ID] INT NOT
  • NULL PRIMARY KEY
  • [Weeks In Program Increment Override Value] FLOAT NULL
  • [Weeks In Sprint Override Value] INT NULL


Updated tables

View Name

Description

Capability Acceptance Criteria

Added Notes & Rank fields.

  • [Notes] NVARCHAR(MAX) NULL
  • [Rank] INT NULL
Capability Forecast

Added In-Scope flag.

  • [In-Scope Flag] NVARCHAR(3) NULL
Epic Acceptance Criteria

Added Notes & Rank fields.

  • [Notes] NVARCHAR(MAX) NULL
  • [Rank] INT NULL

Epic Forecast

Added In-Scope flag.

  • [In-Scope Flag] NVARCHAR(3) NULL

Feature

Added In-Scope flag.

  • [In-Scope Flag] NVARCHAR(3) NULL

Feature Acceptance Criteria

Added Notes & Rank Fields

  • [Notes] NVARCHAR(MAX) NULL
  • [Rank] INT NULL

Forecast Buffer

Added dedicated Member Week (MW) Value column. Previously, Member Week values were being passed in the Team Week (TW) value column. Each column should now accurately represent its context.

  • [Buffer MW Value] FLOAT NULL

Hierarchy

Added Status field.

  • [Hierarchy Status] NVARCHAR(20) NOT NULL

Story Acceptance Criteria

Added Notes & Rank fields.

  • [Notes] NVARCHAR(MAX) NULL
  • [Rank] INT NULL

Team

Added Solution Foreign Key field.

  • [FK Solution ID] INT NULL

 

Was this article helpful?
0 out of 0 found this helpful
Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF

Join the Atlassian Community!

The Atlassian Community is a unique, highly collaborative space where customers and Atlassians come together. Ask questions and get answers, start discussions, and collaborate with thousands of other Jira Align customers. Visit the Jira Align Community Collection today.

Need to contact Jira Align Support? Please open a support request.