Jira Align EI Enhancements and Features Version 10.81


Vector.png

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


Important: Same functionality, new name! Our Business Intelligence (BI) add-on module is now called Enterprise Insights (EI) in the Help Center. We’ve updated references to the product in our past articles and release notes to account for this name change, and have also updated the Business Intelligence section of our Help Center to the name Enterprise Intelligence.

Jira Align's Enterprise Insights (EI) will be updated and deployed to test instances running version 10.81 on October 21st, 2020, and will be deployed to production instances on October 26th, 2020. The following enhancements were made:

Release highlights

  • Planning Method column added to Feature, Capability and Epic tables.

  • Expense Savings Range and Revenue Growth Range added to Feature tables.

  • Feature & Story states updated to include delivery state values (6 - In Delivery, 7 -Delivered) if enabled.

  • Capability & Epic states updated to replace NULL with 1 - Not Started state text.

  • Goal and Solution Foreign Keys added to Objective tables.

  • Role master table added.

  • Time Sheet Note Object added.

  • MAP User to Time Tracking Role table added.

New tables

View Name

Description

Role

Master table for Jira Align roles.

  • [Role ID] INT NOT NULL PRIMARY KEY
  • [Date Created] DATETIME NULL
  • [Date Last Modified] DATETIME NULL
  • [Role Name] NVARCHAR(1000) NULL
  • [Time Tracking Role Flag] NVARCHAR(3) NULL

MAP User to Time Tracking Role

Mapping table for user time tracking role assignments. This object is specific to time tracking and is only available in the [time] schema.

  • [MAP User Time Tracking Role ID] INT NOT NULL PRIMARY KEY
  • [Date DW Modified] DATETIME NOT NULL
  • [Deleted Flag] NVARCHAR(3) NOT NULL
  • [FK Role ID] INT NOT NULL
  • [FK User ID] INT NOT NULL

Time Sheet Note

Notes object for user time entry. This object is specific to time tracking and is only available in the [time] schema.

  • [Date DW Modified] DATETIME NOT NULL
  • [Date Last Modified] DATETIME NULL
  • [Date Week Start] DATETIME NOT NULL
  • [Deleted Flag] VARCHAR(3) NOT NULL
  • [FK Billing Code ID] INT NOT NULL
  • [FK Standard Task ID] INT NOT NULL
  • [FK Time Sheet ID] INT NOT NULL
  • [FK User ID] INT NOT NULL
  • [Time Sheet Note] NVARCHAR(MAX) NULL
  • [Time Sheet Note ID] INT NOT NULL PRIMARY KEY

Updated tables

View Name

Description

Capability

Added [Planning Method] NVARCHAR(50) NULL

Capability History

Added [Planning Method] NVARCHAR(50) NULL

Epic

Added [Planning Method] NVARCHAR(50) NULL

Epic History

Added[Planning Method] NVARCHAR(50) NULL

Feature

Added columns:

  • [Expense Savings Range] NVARCHAR(100) NULL
  • [Planning Method] NVARCHAR(50) NULL
  • [Revenue Growth Range] NVARCHAR(100) NULL

Feature History

Added columns:

  • [Expense Savings Range] NVARCHAR(100) NULL
  • [Planning Method] NVARCHAR(50) NULL
  • [Revenue Growth Range] NVARCHAR(100) NULL

Jira Sprint

Added columns:

  • [Ignore Flag] NVARCHAR(3) NOT NULL
  • [Jira Match Flag] NVARCHAR(3) NOT NULL

Objective

Added Foreign Keys:

  • [FK Goal ID] INT NULL
  • [FK Solution ID] INT NULL
Objective History

Added Foreign Keys:

  • [FK Goal ID] INT NULL
  • [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.