RegoXchange
  • The Milestone Task Dependency portlet shows the milestone task dependency count and has a drilldown to the details. The portlet looks at the dependency impact on milestones, and is not limited to just dependencies that are on different projects. The lag days calculation is based off of the maximum dependency impact and the drilldown portlet (Milestone Task Dependency Details :::: rego_milestone_dependency_det)shows the details for each.
  • Pie Chart Portlet displays counts of active projects with various Stale ratings. Calculation is Percent Stale Tasks = number of open (not completed) tasks with a finish date over 15 days old, divided by total open tasks.  Filterable by OBS structure and project manager.  Data label = project count.  Mouse-over and Legend labels = stale rating.  More than 90% Stale means 90 to 100% of open tasks on a project have finish dates older than 15 days.  More than 71% Stale means 71 to 89% of open tasks on a project have finish dates older than 15 days.  0 - 70% Stale means fewer than 70% of open tasks on a project have finish dates older than 15 days.
  • Pie Chart Portlet displays counts of active projects with various Stale ratings. Calculation is Percent Stale Tasks = number of open (not completed) tasks with a finish date over 15 days old, divided by total open tasks.  Filterable by OBS structure and project manager.  Data label = project count.  Mouse-over and Legend labels = stale rating.  More than 90% Stale means 90 to 100% of open tasks on a project have finish dates older than 15 days.  More than 71% Stale means 71 to 89% of open tasks on a project have finish dates older than 15 days.  0 - 70% Stale means fewer than 70% of open tasks on a project have finish dates older than 15 days.
  • Bar Chart displays average percent variance for all active projects by OBS unit.  Percent variance = Planned Cost - Budgeted Cost / Budgeted Cost * 100.  Projects with no Budgeted Cost are ignored for the calculation.  Then all project variance percentages are algebraically added (some may be negative), and divided by total projects with a variance.  This yields the Average Percent Variance.  This calculation is performed for active projects in each OBS unit.  OBS units include all units at all levels where projects are attached.  Portlet filterable by OBS, Financial Status, and Financially Approved.  Vertical axis = OBS Unit Name.  Horizontal axis = Variance Percent.  Data value = Average Percent Variance.  Mouseover value = OBS Name + Average Variance Percent.
  • Bar Chart displays average percent variance for all active projects by OBS unit.  Percent variance = Planned Cost - Budgeted Cost / Budgeted Cost * 100.  Projects with no Budgeted Cost are ignored for the calculation.  Then all project variance percentages are algebraically added (some may be negative), and divided by total projects with a variance.  This yields the Average Percent Variance.  This calculation is performed for active projects in each OBS unit.  OBS units include all units at all levels where projects are attached.  Portlet filterable by OBS, Financial Status, and Financially Approved.  Vertical axis = OBS Unit Name.  Horizontal axis = Variance Percent.  Data value = Average Percent Variance.  Mouseover value = OBS Name + Average Variance Percent.
  • Bar Chart displays average percent variance for all active projects by OBS unit.  Percent variance = Planned Cost - Budgeted Cost / Budgeted Cost * 100.  Projects with no Budgeted Cost are ignored for the calculation.  Then all project variance percentages are algebraically added (some may be negative), and divided by total projects with a variance.  This yields the Average Percent Variance.  This calculation is performed for active projects in each OBS unit.  OBS units include all units at all levels where projects are attached.  Portlet filterable by OBS, Financial Status, and Financially Approved.  Vertical axis = OBS Unit Name.  Horizontal axis = Variance Percent.  Data value = Average Percent Variance.  Mouseover value = OBS Name + Average Variance Percent.
  • The Project Dependencies portlet displays all projects and their associated dependencies that the logged in user has rights to.  This can assist in scheduling and visualizing the breakout of dependencies. The table below describes the available columns in the portlet.
    Column Label Description
    Project ID ID of the project
    Project Name Name of the project
    Type Relationship to above project, Parent Project (P) or Sub Project (S)
    Manager Manager of the project
    Start Start Date of the project
    Finish Finish Date of the project
    Gantt Visualization of project timelines
    Sort Column Used to order the columns for proper display of the portlet
    dimkey Internal code used by the query
    Inv_hlth_int Internal code used by the query
    Link_dbid Internal code used by the query
    link_toggle Internal code used by the query
    rel_active Internal code used by the query
    rel_dbid Internal code used by the query
    rel_mgr_dbid Internal code used by the query
    rel_sort Internal code used by the query
       
  • The Project Dependencies portlet displays all projects and their associated dependencies that the logged in user has rights to.  This can assist in scheduling and visualizing the breakout of dependencies. The table below describes the available columns in the portlet.
    Column Label Description
    Project ID ID of the project
    Project Name Name of the project
    Type Relationship to above project, Parent Project (P) or Sub Project (S)
    Manager Manager of the project
    Start Start Date of the project
    Finish Finish Date of the project
    Gantt Visualization of project timelines
    Sort Column Used to order the columns for proper display of the portlet
    dimkey Internal code used by the query
    Inv_hlth_int Internal code used by the query
    Link_dbid Internal code used by the query
    link_toggle Internal code used by the query
    rel_active Internal code used by the query
    rel_dbid Internal code used by the query
    rel_mgr_dbid Internal code used by the query
    rel_sort Internal code used by the query
       
  • This is a graphic portlet that pulls the average schedule variance by OBS node of the project.  The portlet allows you to choose any OBS that is associated to the Project Object. Users can filter by:
    1. OBS Type
    2. If the project is financially approved?
    3. Financial Status
  • This is a graphic portlet that pulls the average schedule variance by OBS node of the project.  The portlet allows you to choose any OBS that is associated to the Project Object. Users can filter by:
    1. OBS Type
    2. If the project is financially approved?
    3. Financial Status
  • This portlet displays the monthly allocation per resource. The PM can view by the RM or the resource to get the data for monthly resource allocations. The table below describes the available filter fields in the portlet.
    Column Label Description
    Work Effort Manager Manager of the Investment the Work Effort is on
    Work Effort Active Active status of the Investment the Work Effort is on
    Resource Resource’s Name
    Internal Resource ID Resource’s ID
    Zero Allocation Show Allocations that equal zero
    Open for Time Entry Is the Resource Open for Time Entry
    Resource Active Resource’s Active status
    Role Resource’s Primary Role
    OBS Unit Resource’s OBS
    Start Allocation Start Time to filter by
    End Allocation Finish time to filter by
       
  • The Timesheet Notes portlet displays all timesheet notes split out by resource, investment and task.  This is very useful in situations where you want to review multiple notes as you do not have to open each note separately. The table below describes the available filter fields in the portlet.
    Column Label Description
    Timesheet Period Start Range of time periods to display filtered by start date
    Timesheet Period Finish Range of time periods to display filtered by finish date
    Resource Resource(s) to display
    Type Note on a timesheet or time entry (task specific)
Go to Top