RegoXchange
  • This tech-trick details the steps to set colors for an HTML5 Graph.
  • This configuration and accompanying process allows users to capture Financial and Non-Financial (Metrics, Soft, etc.) Benefit in a custom sub-object, then programmatically create an out-of-the-box Benefit Plan with just the Financial Portion from the custom sub-object.  The solution is comprised of:
    • Sub-Object (Benefit Plan Details, Parent = Project)
    • Process: Create Benefit Plan (uses sub-object as primary input, native BP is output)
    • Process: Update sql - Cost Benefit Plans (one-time script to update Projects)
    The Process to create the Benefit Plan is initiated when users check the Create Benefit Plan box on the sub-object.  Every time the Process runs it aggregates all rows from the sub-object that are flagged as Financial and creates a new Benefit Plan.  The resulting BP is not linked to any Cost Plans. Users who install this base solution will want to consider:
    • Ensure on the Benefit Details List view the Planned and Realized Amounts are displayed
    • Modifying the Create Benefit Plan Process in support of a BP naming convention consistent with local PMO Practices
    • Modifying the Create Benefit Plan Process to link the BP to the Cost Plan of Record
    • Creating a Portlet that pulls together rows of data from the sub-object across multiple projects in a summarized view as well as a detailed view
    Once installed, please refer to the Benefit Detail Functionality Document for how to create Benefit Detail records, initiate the process, and the Benefit Plan Creation.
  • The Over/Under Allocation by Resource report is a transaction based Jaspersoft report that does not require the Load Jaspersoft Datawarehouse job to be run.  The report will pull real-time data from the transaction tables in Clarity.  This report can be run from either the Advanced Reporting or Reports and Jobs area within Clarity. The Over/Under Allocation by Resource report displays resource remaining capacity amounts by resource. The report displays amounts by week or month, and in total. The amounts can be displayed as hours or FTEs.
  • Portlet to show the stage of any Action Item triggered by Timesheet submission.  Portlet allows for a period start date input, filters by Resource, Approver, Action Item Status and Timesheet Status.  A link to the action item is provided for direct action by review if needed. This portlet is only for the clients who have established a process that triggers on Timesheet Status change to Submitted and to send Action Items to the person responsible for timesheet approval/validation i.e. PM for project tracking and/or RM for overall approval of the timesheet. The portlet won’t display any data if there are no timesheet Action Items.  Examples of such processes would be CA’s OOTB Project Manager Approval or the Timesheet Approval - PM and RM process found on RegoXchange.
  • This is a standalone process that can be run by an admin to change the ownership of MUX views from a specified user to another specified user.  The process contains a single custom script, which has the following parameters that must be updated prior to running the process:
    • currentOwnerId (required): Resource ID for the current Owner (unique_name from srm_resources table)
    • newOwnerId (required): Resource ID for the new Owner (unique_name from srm_resources table)
    • viewCode (optional): Code for the specific view to update - leave blank if you want to transfer ownership for all views (odf_ui_views.code)
    The script will update the owner for all views that are marked as shared, as long as the new owner doesn’t have a similar view with the exact same name.  If there are views that can’t be updated, they will be logged in the process log.   To Run:
    1. Navigate to the process called Admin - MUX Views - Change Ownership.
    2. Navigate to the Start Step tab, Click on the Update Owner action, and click the Custom Script Parameters tab.
    3. Enter the Resource ID for the current view owner into the currentOwnerId parameter.
    4. Enter the Resource ID for the new owner into the newOwnerId parameter.
    5. If you want to update a specific view only, enter that in the viewCode parameter.
    6. Run the process via Organizer in Classic.
  • The Project Storyboard report is a transaction based Jaspersoft report that does not require the Load Jaspersoft Datawarehouse job to be run.  The report will pull real-time data from the transaction tables in Clarity.  This report can be run from either the Advanced Reporting or Reports and Jobs area within Clarity. The Project Storyboard report shows key aspects of a project that is organized in separate frames. Each frame in the report displays project information such as project dates, project objective, the amount, and cost of resources that are planned and actual, key accomplishments, upcoming activities, current issues and risks, and the project progress toward goals. This report can be used to analyze the project earned value and track work performance to account for cost and schedule variances.
  • Over time notifications can build up in the CA PPM system and should be purged, so as not to hinder performance. The SQL statements mentioned in the tech doc can be implemented within a process in CA PPM to either purge notifications on an ongoing basis or remove all of them at once.
  • JasperSoft as two font databases – one for display and one for pdf exporting. Not all fonts in the display database are in the exporting database. If you find you are not getting the proper fonts when exporting to PDF from JasperSoft this tech trick will show you how to add the missing font so your report exports as expected.
  • This portlet pulls back the Availability and Allocation totals by Role between a user-specified Start and Finish Date, then the user can drilldown to look at the information for Applications.  The Time Period filter allows for comparing these values across different timeframes (monthly, weekly, quarterly, annual) as desired.  Other filters allow for looking at Active or Inactive Roles (or both) and including Active or Inactive Projects (or both) in the totals.
  • This video describes the process to baseline a project using OWB. The video is available in both .m4v and .wmv formats.
  • This video describes the process to assign resources to tasks within OWB. The video is available in both .m4v and .wmv formats.
  • This training document is a Rego Consulting Quick Reference Guide to assist with the use of the Staffing Plan in Clarity’s Modern User Experience.  This doc references version 16.0.3 views. Document provides information on how to swap between views to see investments by resource or resources by investment. Instructions on filtering are provided, as well as detail on how to update the unit of measure between FTE (Full Time Equivalent) and Hours. Tips are provided on how to expand the list of investments within each view and how to view the properties for the allocations. A Legend is also documented to provide information on each of the icons that are displayed on this page.
Go to Top