1. Jira Align
  2. What's new?
  3. Enterprise Insights release notes

Jira Align EI Enhancements and Features Version 10.98.X

Jira Align's Enterprise Insights (EI) was updated and deployed to 10.98.X instances on the continuous track on July 28, 2021, and will be deployed to instances on the bundled track on July 31, 2021. The following enhancements were made:

Release highlights

  • Attachment Binary table added: Binary file for object attachments. The Attachment ID is the same identifier found in object specific attachment tables (Capability Attachment, Defect Attachment, etc). This is a preview feature and the load for this table is disabled by default. Please contact our Support Team if you are interested in preview access to this data.

  • Feature Status table added: Feature health status from status reports.

  • Theme Investment table added: Theme investment distribution for programs and program increments.

  • Status Report Notes column added to capabilities.

  • Attachment Notes column added to attachment object tables.

  • Added Feature Team Sprint ID primary key column to the Feature Team Sprint table.

  • Previously, role permission names [Role Permission].[Permission Name] were not being assigned. The name value lookup has now been corrected.

  • Objective changes to health color were not triggering incremental load. The change identification logic was expanded to better capture this while the core team works to resolve the timestamp update in Jira Align.

  • Export_dw schema updates for parity with current_dw.

    • Objects added:

      Agile Object, Capability Log, Capability Milestone, Customer List, Defect Log, Epic Log, Feature Log, Goal Log, Objective Log, Program Increment Log, Program Log, Release Vehicle Log, Risk Log, Role Log, Sprint Log, Story Log, Strategic Snapshot Log, Success Criteria Log, Task Log, Team Log, Test Case Log, Theme Log, User Log

    • Columns added:

      Capability.FK Portfolio ID, Defect.Rank, Defect History.Rank, Epic.FK Portfolio ID, Feature.FK Portoflio ID, MAP Objective to Program.[Rank Program], MAP Objective to Program.[Rank Program Increment], Process Step.Process Step Name, Theme.Rank Global

New tables

View Name

Description

Attachment Binary

Binary file for object attachments. The Attachment ID is the same identifier found in object specific attachment tables (Capability Attachment, Defect Attachment, etc). This is a preview feature and the load for this table is disabled by default.

  • [Attachment Binary] VARBINARY NULL
  • [Attachment ID] INT NOT NULL PRIMARY KEY
  • [Date Added] DATETIME NULL

Feature Status

Feature health status from status reports.

  • [Date Saved] DATETIME NULL
  • [Feature Status] NVARCHAR(10) NULL
  • [Feature Status ID] INT NOT NULL PRIMARY KEY
  • [FK Feature ID] INT NOT NULL
  • [FK User Saved By ID] INT NULL

Theme Investment

Theme investment distribution for programs and program increments.

  • [FK Program ID] INT NOT NULL
  • [FK Program Increment ID] INT NOT NULL
  • [FK Theme ID] INT NOT NULL
  • [Investment Percent] FLOAT NOT NULL
  • [Theme Investment ID] INT NOT NULL PRIMARY KEY

Updated tables

View Name Description

Agile Object

Object added to export_dw schema.

Capability

Added column for status report notes.

  • [Status Reports Notes] NVARCHAR(MAX) NULL

Column [FK Portfolio ID] added to export_dw schema.

Capability Attachment

Added new column for attachment notes.

  • [Attachment Notes] NVARCHAR(MAX) NULL

Capability Log

Object added to export_dw schema.

Capability Milestone

Object added to export_dw schema.

Customer List

Object added to export_dw schema.

Defect

Column [Rank] added to export_dw schema.

Defect History

Column [Rank] added to export_dw schema.

Defect Attachment

Added new column for attachment notes.

  • [Attachment Notes] NVARCHAR(MAX) NULL

Defect Log

Object added to export_dw schema.

Dependency Attachment

Added new column for attachment notes.

  • [Attachment Notes] NVARCHAR(MAX) NULL

Epic

Column [FK Portfolio ID] added to export_dw schema.

Epic Attachment

Added new column for attachment notes.

  • [Attachment Notes] NVARCHAR(MAX) NULL

Epic Log

Object added to export_dw schema.

Feature

Column [FK Portfolio ID] added to export_dw schema.

Feature Attachment

Added new column for attachment notes.

  • [Attachment Notes] NVARCHAR(MAX) NULL

Feature Log

Object added to export_dw schema.

Feature Team Sprint

Added Feature Team Sprint ID column.

  • [Feature Team Sprint ID] INT NOT NULL PRIMARY KEY

Goal Attachment

Added new column for attachment notes.

  • [Attachment Notes] NVARCHAR(MAX) NULL

Goal Log

Object added to export_dw schema.

Idea Attachment

Added new column for attachment notes.

  • [Attachment Notes] NVARCHAR(MAX) NULL

Impediment Attachment

Added new column for attachment notes.

  • [Attachment Notes] NVARCHAR(MAX) NULL

MAP Objective to Program

Columns [Rank Program] and [Rank Program Increment] added to export_dw schema.

Objective Log

Object added to export_dw schema.

Process Step

Column [Process Step Name] added to export_dw schema.

Program Increment Log

Object added to export_dw schema.

Program Log

Object added to export_dw schema.

Release Vehicle Log

Object added to export_dw schema.

Risk Attachment

Added new column for attachment notes.

  • [Attachment Notes] NVARCHAR(MAX) NULL

Risk Log

Object added to export_dw schema.

Role Log

Object added to export_dw schema.

Sprint Log

Object added to export_dw schema.

Story Attachment

Added new column for attachment notes.

  • [Attachment Notes] NVARCHAR(MAX) NULL

Story Log

Object added to export_dw schema.

Strategic Snapshot Attachment

Added new column for attachment notes.

  • [Attachment Notes] NVARCHAR(MAX) NULL

Strategic Snapshot Log

Object added to export_dw schema.

Success Criteria Log

Object added to export_dw schema.

Task Log

Object added to export_dw schema.

Team

Added autopopulate estimate attributes for team.

  • [Autopopulate Estimate Flag] NVARCHAR(3) NOT NULL
    [Autopopulate Estimate Value] INT NULL

Team Log

Object added to export_dw schema.

Test Case Attachment

Added new column for attachment notes.

[Attachment Notes] NVARCHAR(MAX) NULL

Test Case Log

Object added to export_dw schema.

Theme

Column [Rank Global] added to export_dw schema.

Theme Attachment

Added new column for attachment notes.

  • [Attachment Notes] NVARCHAR(MAX) NULL

Theme Log

Object added to export_dw schema.

User Log

Object added to export_dw schema.
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.