User Problem

While creating dashboards using Enterprise Insights data, it has become evident that linking Milestone types to Portfolio, Program, and PI information is cumbersome. No direct relationship or foreign key in Enterprise Insights connects Milestones to these essential organizational elements or the work items they relate to. This lack of linkage creates significant challenges in analyzing and reporting milestone-related data within the broader organizational context.

Suggested Solutions

• Introduce foreign keys to link Milestones to Portfolios, Programs, and PIs directly.
• As an incremental improvement, create mapping tables that establish these relationships, enabling users to connect Milestones with their related entities efficiently.

Current Workarounds

Currently, users must rely on indirect and complex methods, such as manually cross-referencing data or creating custom queries, to infer relationships between Milestones and Portfolio, Program, and PI data. These workarounds are time-consuming, error-prone, and inefficient, significantly impacting productivity.