-
The Concatenate Multi-Value Lookup into One Field for Display Purposes technical trick provides an overview of how to group or concatenate the various levels and values of a Multi-Value lookup into one field in both Oracle and SQL Server environments. This allows the lookup values to be more easily displayed in a portlet. The function concatenates the values together using a choice of delimiter, which then allows the multi-value lookup to be viewed as one portlet column, in the same manner as any other object attribute. -
Late Milestones report displays the list of all milestones that are not closed but are past their finish date or past their baseline finish date. The report provides Project Manager the ability to view and track late milestones across multiple projects without going into each project individually. This report displays Project ID, Project Name, Project Manager, Milestone Name, Due Date, Baseline Date, Days Late (Elapsed days between Task Finish date and Task Baseline Finish date), and Days Old (Elapsed days between Task Finish Date and Today's Date). User can further narrow their search by Project ID, Project Name, Project Manager Name, Milestone Name, Due Date between, Baseline Date between, Is Milestone?, Is late?, Task Status, Is Template?. User can use exact dates or relative dates for Due Date between and Baseline Date between filter parameters. -
All Risks report provides the project manager a single place to view risks across multiple projects. This report displays Project Information such as ID, Name & Manager, Risk Information such as its ID, Name, Owner, Status, Probability, Impact, Target Resolution Date & Days Open. You can further narrow your search by Risk Status, Risk Name Risk Impact, Risk Owner, Project Name and Project Manager. -
Benefits by year report provides the project manager a single place to view Benefit plan and its associated benefit for various years across multiple projects. Project Managers can use this report to analyze if the projects are giving intended benefits and take appropriate decisions accordingly. User can further narrow their search by OBS Type & Path, Investment Name, Investment Manager, Investment Type, Plan Type and Is Plan of Record?.

