Jira Align EI Enhancements and Features Version 10.103.X

Jira Align's Enterprise Insights (EI) was updated and deployed to 10.103.X instances on the continuous track on January 5, 2022, and was deployed to instances on the bundled track on January 8, 2022. The following enhancements were made:

Release highlights

  • New content:

    • Added User Modified By Foreign Key to Acceptance Criteria. (Capability, Epic, Feature, Story)

    • Added Estimation Conversion table.

    • Added epic persona mapping.

    •  Corrected [Date DW Modified] mapping for [Customer List].

    • Added Jira connector configuration for object-specific statuses.

    • Added Strategic Initiative object.

    • Added risk and dependency foreign keys for external references.

    • Added program/team-tier program mappings to [MAP Objective to Program]. These mappings are already present as a direct foreign key on the Objective table. Including them in the mapping table allows the table to be used for all program mappings.

  • Defect fixes: 

    • Defect allocations are NULL for Product Owner role

    • Added [Epic Intake].[Epic Intake Float Value] to export_dw schema.

    • Corrected deletion logic for strategic snapshots.

    • Corrected data load for defect and risk attachments.

    • Updated source query to map Discussion Parent ID for objectives, risks and stories.

    • Added [Deleted Flag] & [Date DW Modified] where missing to export_dw schema objects.

      • Capability Link, Capability Milestone, Customer, Defect History, Epic Link, Feature Link, Feature Team Sprint, Story Link, Theme History, Theme Link.

New tables

View Name

Description

Estimation Conversion

Added table for administration settings of estimation conversion.

  • [Agile Object Name] NVARCHAR(100) NULL
  • [Estimation Conversion ID] INT NOT NULL PRIMARY KEY
  • [Estimation Type] NVARCHAR(50) NULL
  • [Estimation Value] NVARCHAR(50) NULL
  • [FK Agile Object ID] INT NOT NULL
  • [FTE/mo] FLOAT NULL
  • [Member Weeks] FLOAT NULL
  • [Sort Order] INT NULL
  • [Story Points] FLOAT NULL[Team Weeks] FLOAT NULL

Jira State Object Mapping

Added table for object-specific state mappings in Jira connector.

  • [FK Agile Object ID] INT NOT NULL
  • [FK Connector ID] INT NOT NULL
  • [FK Jira Project ID] INT NOT NULL
  • [FK Jira State ID] INT NOT NULL
  • [Jira Align Customer Object Name] NVARCHAR(50) NULL
  • [Jira Align Object Name] NVARCHAR(50) NULL
  • [Jira Align State Name] NVARCHAR(100) NULL
  • [Jira State Object Mapping ID] INT NOT NULL PRIMARY KEY

Jira State Process Step Mapping

Added table for process step mappings in the Jira connector.

  • [FK Agile Object ID] INT NOT NULL
  • [FK Connector ID] INT NOT NULL
  • [FK Jira Project ID] INT NOT NULL
  • [FK Jira State ID] INT NOT NULL
  • [FK Process Step ID] INT NOT NULL
  • [Jira Align Customer Object Name] NVARCHAR(50) NULL
  • [Jira Align Object Name] NVARCHAR(50) NULL
  • [Jira State Process Step Mapping ID] INT NOT NULL PRIMARY KEY

MAP Epic to Persona

Added table for epic persona mappings

  • [FK Epic ID] INT NOT NULL
  • [FK Persona ID] INT NOT NULL
  • [MAP Epic Persona ID] INT NOT NULL

Strategic Initiative

Added table for Strategic Initiative.

  • [Strategic Initiative ID] INT NOT NULL PRIMARY KEY
  • [Strategic Initiative Name] NVARCHAR(100) NULL
  • [Strategic Initiative Value] INT NULL

Updated tables

View Name

Description

Capability Acceptance Criteria

Added Foreign Key for User Modified By.

  • [FK User Modified By ID] INT NULL

Capability Link

Added [Date DW Modified] & [Deleted Flag] to export_dw schema.

Capability Milestone

Added [Date DW Modified] & [Deleted Flag] to export_dw schema.

Customer

Added [Date DW Modified] & [Deleted Flag] to export_dw schema.

Defect History

Added [Deleted Flag] to export_dw schema.

Epic Acceptance Criteria

Added foreign key for User Modified By.

  • [FK User Modified By ID] INT NULL

Epic Intake

Added [Epic Intake Value Float] to export_dw schema.

Epic Link

Added [Date DW Modified] & [Deleted Flag] to export_dw schema.

External Reference

Added foreign key references for Despendency & Risk external references.

  • [FK Dependency ID] INT NOT NULL
  • [FK Risk ID] INT NOT NULL

Feature Acceptance Criteria

Added foreign key for User Modified By.

  • [FK User Modified By ID] INT NULL

Feature Link

Added [Date DW Modified] & [Deleted Flag] to export_dw schema.

Feature Team Sprint

Added [Deleted Flag] to export_dw schema.

Story Acceptance Criteria

Added Foreign Key for User Modified By.

  • [FK User Modified By ID] INT NULL

Story Link

Added [Date DW Modified] & [Deleted Flag] to export_dw schema.

Theme

Added Foreign Key to Strategic Initiative

  • [FK Strategic Initiative ID] INT NOT NULL

Theme History

Added [Deleted Flag] to export_dw schema.

Theme Link

Added [Date DW Modified] & [Deleted Flag] 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.