Enterprise Insights release notes for 11.0.X

Last updated: July 12, 2024 to include additional bug fixes and update the schedule for future removals from Enterprise Insights.

Jira Align's Enterprise Insights (EI) version 11.0 was deployed to environments on the continuous release track on June 21, 2024. It was then deployed to environments on the bundled release track on June 25, 2024. The following changes are included in version 11.0:

Release highlights

New content and delivered suggestions:

  • JIRAALIGN-1755: New views are available in both the current_dw and export_dw schemas to support the new milestones tab for theme, capability, and feature details panels in Jira Align:
    • Themes: Theme Milestone new view.
    • Capabilities: Capability Milestones new view, replacing Capability Milestone. See the Announcements section for details.
    • Features: Feature Milestone new view.
    • Epics: New Description, Category, and State columns added to the existing Epic Milestone view.

Bug fixes:

  • JIRAALIGN-7287: ETL jobs fail if there are entries in the Audit Log Details view for FK Agile Object ID's related to themes.
    • Added new FK Agile Object = 1 for themes in the Audit Log Details view in both the current_dw and export_dw schemas.

Announcements

In version 11.1, the following changes will be made:

  • The Test Case, Test Case Log, Test Case Attachment, and Test Case Step views will be removed from the current_dw and export_dw schemas, as a result of the removal of the test case backup tables in the Jira Align database and removal of the Quality module.
    • Please back up any data in these views, which will be removed from Enterprise Insights in version 11.1.

In version 11.6, the following changes will be made: 

  • The following views and columns will be removed from the current_dw and export_dw schemas to support multiple changes in Jira Align:
    • The Matric Measured Increment column in the Success Criteria view will be removed and replaced by a new column, Metric Measure Increment.
      • Please update reports and queries to use the new Metric Measure Increment column. 
    • Views removed as a result of the removal of all skills functionality, and the Time/Skills tab from epic details panels.
      • Epic Skill 
      • Epic Skill Allocation 
      • Skill 
      • MAP User to Skill
      • Epic Schedule
    • Views removed as a result of legacy Jira Align functionality that has been designated with end-of-support status:
      • Canvas
      • Canvas Block
      • Canvas Block Item
      • Countries
      • Escalations
      • Escalation Log
      • Design Component
      • MAP Capability to Design Component
      • MAP Capability to Country
      • MAP Epic to Design Component
      • MAP Epic to Country
      • MAP Escalation to Dependency
      • MAP Escalation to Impediment
      • MAP Escalation to Risk
      • MAP Escalation to Stakeholder
      • MAP Feature to Design Component\
      • MAP Feature to Country
      • Team Meeting
    • Views removed as a result of the new milestones tab available for capability details panels:
      • Capability Milestone (replaced by Capability Milestones)
    • Columns removed from the Epic Milestone view as a result of the new milestones tab available for epic details panels:
      • Completed Flag
      • Date Portfolio Ask
      • FK User Created By ID
      • FK User Completed By ID
    • Views removed as a result of new capacity functionality in Jira Align:
      • Forecast Capacity
      • Forecast Buffer
    • Please back up any data in these views and columns, which will be removed from Enterprise Insights in version 11.6.

New tables

View Name Description
Theme Milestone

New view:

  • [Theme Milestone ID] INT NOT NULL
  • [Milestone Title] NVARCHAR(450) NULL
  • [Completed Flag] VARCHAR(3) NOT NULL
  • [Milestone Description] NVARCHAR(450) NULL
  • [Category] NVARCHAR(100) NULL
  • [State] NVARCHAR(50) NOT NULL
  • [Date Start] DATETIME NULL
  • [Date Target Completion] DATETIME NULL
  • [Date Completed] DATETIME NULL
  • [FK Theme ID] INT NOT NULL
Capability Milestones

New view:

  • [Capability Milestone ID] INT NOT NULL
  • [Capability Deliverable Name NVARCHAR(450) NULL
  • [Completed Flag] VARCHAR(3) NOT NULL
  • [Description] NVARCHAR(450) NULL
  • [Category] NVARCHAR(100) NULL
  • [State] NVARCHAR(50) NOT NULL
  • [Date Start] DATETIME NULL
  • [Date Target Completion] DATETIME NULL
  • [Date Completed] DATETIME NULL
  • [FK Capability ID] INT NOT NULL
Feature Milestone

New view:

  • [Feature Milestone ID] INT NOT NULL
  • [Title] NVARCHAR(450) NULL
  • [Completed Flag] VARCHAR(3) NOT NULL
  • [Description] NVARCHAR(450) NULL
  • [Category] NVARCHAR(100) NULL
  • [State] NVARCHAR(50) NOT NULL
  • [Date Start] DATETIME NULL
  • [Date Target Completion] DATETIME NULL
  • [Date Completed] DATETIME NULL
  • [FK Theme ID] INT NOT NULL

 

Updated tables

View Name Description
Epic Milestone

Added columns:

  • [Description] NVARCHAR(450) NULL
  • [Category] NVARCHAR(100) NULL
  • [State] NVARCHAR(50) NOT 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.