RegoXchange
  • The Power Filter Sync functionality allows users to define rules for syncing investments to Roadmaps or Hierarchies on a scheduled (and on-demand in Roadmaps only) basis.  Users may choose one or more saved views from investments that are allowed on the Roadmap/Hierarchy to define the list of investments they want that Roadmap/Hierarchy to contain.  If the option to Keep Synced with Power Filter is set to Yes, then each time the process runs, the Investments returned by the saved views will be added to the Roadmap/Hierarchy if they don’t exist there already, and any investment not found in the saved views will be removed.
  • Actuals & ETC by Resource Assignment report provides project managers a single place to view Actuals and ETC associated with resources across multiple Tasks and Projects. It displays the following: Actual and ETC Hours by Start Date: Stacked Column chart that displays the total Actual hours and ETC hours per month of fiscal period. Grey color indicates Actuals and Purple indicates ETC hours during that month. Grid: Displays Investment name, Task, Assigned resource ETC and Actual hours per month of fiscal period. It also displays aggregated column and row totals for Actuals and ETC hours. You can further narrow your search by OBS Type, OBS Path & Start Date range.
  • RM Dashboard shows various KPIs like Actuals posted by the resources in last month, Allocation in current month, count of missed timesheets etc. Team Details – Grid report providing list of all the resources managed by a resource manager. Allocation by Investment type – Tree graph displaying distribution pattern of allocation hours across different investment types. Actuals by Employment Type - Area graph, displaying actual hours posted by Employees Vs Contractors. Demand by Month – Area graph, displaying Allocation Vs Availability for next 6 months. Utilization by Month - Area graph, displaying Baseline Vs Actuals hours over last 6 months.
  • This Roadmap add-on provides configurable Role-based metrics that can be used in the grid view as targets and constraints. Select your valuable roles in the “targets” and once selected, the “sync” button will bring in any current allocations against projects and allow editing any of the total numbers directly in a scenario.  This will provide deeper insights into impacts of plans on teams/resources in addition to the out of the box money and time constraints.
  • Timesheet compliance is a dashboard containing multiple visualizations that shows timesheet compliance data under various scenarios. Dashboard shows count of timesheets grouped by Status and total available timesheets. % Time Compliance – Gauge graph that shows percentage of completed timesheets against overall timesheets. Compliance by Resource Manager – Grid section that shows percent timesheet compliance by resource manager. Timesheet count by Employment type and Timesheet Status – Stacked column chart, each column represents Employment type and sections of the column represent count of timesheets by Status. Count of Timesheets by Months – Stacked column chart, each column represents a month and sections of the column represent count of timesheets by Status. Dashboard also const of two grid sections displaying number of Open timesheets by Organization and Vendor.
  • All Status report provides project managers a single place to view KPIs related to Status Reports.  All the KPIs are depicted in various visualizations. Status Report Count:  Scorecard that displays the # of Status Reports for the selected criteria. Status Report by Cost Effort Status:  Column chart that displays # of Status Reports by Cost Effort. X axis displays various Cost Effort Status. Data labels indicate the number of Status Reports associated with that category. Status Report by Schedule Status: Column chart that displays # of Status Reports by Schedule Status. X axis displays various Schedule statuses. Data labels indicate the number of Status Reports associated with that status. Status Report by Scope Status: Column chart that displays # of Status Reports by Scope Status. X axis displays various Scope statuses. Data labels indicate the number of Status Reports associated with that status. Grid: Displays Status Report details such as Investment ID, Investment Name, Report Name, Report ID, Overall Status, Cost Effort, Schedule Status and Scope Status. You can further narrow your search by OBS Type, OBS Path and Report Date range
  • Review of functional and technical changes to Clarity from version 16.3.1 through 16.4.0.  Some previous decks are available if you need to see further back in the versions.  You can request them via the Librarian or emailing suport@regoxchange.com.
  • Capacity Graph report displays Availability, Allocations, Actuals and Assignments for one or more active resource(s) in a single view.  Report contains the following components: KPIs: Displays Available hours, Allocation + ETC for filtered criteria. Bar graph: Displays Allocation + ETC by primary role Line chart: Displays Availability, Allocations, Actuals and Assignments by time period. This portlet provides Resource Managers, PMOs and Executives with a simple way to analyze: Allocations vs. Availability, Allocations vs. Actuals, Allocations vs. ETC and ETC vs. Availability. User can further narrow their search by OBS Type & Path, Resource Manager, Primary Role, Start and End Date.
  • Allocation Compliance by RM report provides resource managers a single place to view Available hours, Allocation Hours and Allocation Percentage of Resources. It considers the resources of selected resource manager and it displays the following: Allocation Details Grid: Displays Resource and its Allocated hours, Available hours and Allocation percentage (Allocated hours/Available Hours) Allocation Percent by Resource: Bar chart that displays Allocation Percentage (top 10) for various resources during the selected Time frame. You can further narrow your search by Resource Manager & Month Start Date range.
  • Allocation Compliance by PM report provides project managers a single place to view Available hours, Allocation Hours and Allocation Percentage of Investment Team Resources. It considers the investments of selected project manager and it displays the following: Allocation Details Grid: Displays Resource and its Allocated hours, Available hours and Allocation percentage (Allocated hours/Available Hours) Allocation Percent by Resource: Column chart that displays Allocation Percentage for various resources during the selected Time frame. You can further narrow your search by Project Manager & Month Start Date range.
  • All Assignments report provides project managers a single place to view KPIs related to Task Assignments.  All the KPIs are depicted in various visualizations. Total Actuals: Scorecard that displays the sum of actuals associated with assignments for the selected criteria. Remaining ETC:  Scorecard that displays the sum of current ETC associated with assignments for the selected criteria. Top 5 Roles (Total Effort):  Column chart that displays Effort (Actuals + ETC) by Roles. X axis displays various Roles. Data labels indicate sum of effort associated with that Role. Actuals by OBS level 2:  Column chart that displays Actuals by OBS level 2. X axis displays various OBS level 2. Data labels indicate sum of actuals associated with that OBS. Grid: Displays Assignment details such as Project ID, Project Name, Task Name, Task Status, Assigned Resource, Assignment Status, Assignment Start, Assignment Finish, Actuals, ETC, Total Effort, Days Late and Days Old. You can further narrow your search by OBS Type, OBS Path, Project(s) and Project Manager.
  • Project Budget vs Planned vs Actual by Month report provides the Project Managers a single place to view Project Budget, Planned and Actual Cost for multiple projects. This report displays Project Budget vs Planned vs Actual by Month in the form of clustered bar chart over a period of time. User can further drill down the information to investment level by selecting a particular bar within the chart. User can further narrow their search by OBS Type & Path, Project(s), Project Manager, Month Start and End Date.
  • The PPM Data Dictionary Extractor pulls schema and attribute information from each object in CA PPM and places it in a custom object.  The following fields provide details information about each attribute in the CA PPM Instance.
    • Object Name – The name of the object to which the attribute belongs
    • Object Code – The external ID of the object to which the attribute belongs
    • Attribute Name – The name of the attribute
    • Attribute Code – The external ID of the attribute
    • Partition Code – The partition to which the attribute belongs
    • Table Name – The database table where the attribute is located
    • Column Name – The database column name of the attribute
    • Data Type – The data type of the attribute
    • Data Size – The character limit of the attribute
    • Data Scale – The scale of numeric attributes
    • Is Active – Specifies if the attribute is active
    • Extended Data Type – The extended type of the attribute (ex: lookup, money, etc.)
    • Lookup Name – The name of the attribute’s lookup
    • Lookup Type – The external ID of the attribute’s lookup
    • Default Value – The default value assigned to the attribute
    • API Alias – The REST API alias assigned to the attribute
    • Max Value – The maximum value accepted by the attribute
    • Min Value – The minimum value accepted by the attribute
    • Curve Name – The name of the Curve for Time-Scaled value attributes
    • Curve Type – The type of the Curve for Time-Scaled value attributes
    • Is Custom – Is the attribute a stock attribute or custom
    • Is Auto-Numbered – Is auto-numbering enabled for the attribute
    • Is Multi-Valued – Is the attribute a multi-valued lookup
    • Is DWH Enabled – Is the attribute enabled for export to the data warehouse
    • Is Editable – Is the attribute editable or read-only
    • Is Required – Is the attribute required
    • Is Virtual – Is the attribute a virtual attribute
    • Is Private – Is the attribute a private attribute used by the application behind the scenes
  • The Rego Group Rights portlet is a useful list view for functional administrators.  It provides a flat view of all the Global, OBS and Instance rights that have been granted to all the groups in Clarity. It can be further filtered by just the rights type and/or the security group. It is also possible to export out to file in spreadsheet (csv, xlsx) or PowerPoint formats with OOB Clarity functionality.
  • The Rego Roadmap Conversion process provides the ability to create investments, from Roadmap Items.
    • Create a roadmap and populate it with Roadmap Item(s).  It is useful to create a custom view which contains the attributes needed in the project, or Custom Investment, to be created.
    As many roadmap items as you wish can be added at this stage.  Either all, or only selected roadmap items, can be converted.
    • Create a view to be used to help with the Conversion process.  It should include: -
      • Roadmap Item: This will become the Investment Name
      • Convert to: The type of investment to be created.
      • Conversion - Use Template:  The template to use in the conversion process.
      • Sync Status: The status of the conversion process
      • Sync Message:  additional details for the conversion process
      • In addition, check the Scenario that is selected.
    • In the Properties > Actions menu select Convert to Investment
    • This will initiate the conversion process and will select the roadmap items that: -
      • have no linked to set.
      • have both the Convert to and Conversion Use Template selected.
      • If any of these details are empty the roadmap item will be ignored.
    • The Sync Status and Sync Message will be updated to show whether the conversion has completed successfully, or not.
    • The Linked to will be populated with the newly created investment.
    • There is a Roadmap Action Log which can be accessed via Custom Objects.  This is useful for administrators and tracks all actions undertaken by the Conversion Process.   A history of the conversions completed, and their sync status and messages can be accessed from here.
  • Project Health by PM is a dashboard that contains multiple visualizations showing various KPIs of projects managed by a project manager. Dashboard shows KPIs like summary of Over Due tasks, Critical tasks, Unfilled roles on Project, Effort and Schedule variance etc. Spend this month – Area graph that shows Actual vs Budget cost for current month. Spend and Budget by Year – Ribbon chart that shows yearly distribution of Actual vs Budget cost. Project Map by Estimated time left – Tree map representing ETC hours remaining on each project. Team – Grid section that shows list of team members with respective Actuals and ETC hours. Actual Hours, Allocated Hours and ETC Hours by Fiscal Month – Area graph that shows monthly distribution of Actuals vs Allocation vs ETC.
  • All Risks report provides project managers a single place to view KPIs related to Risks.  All the KPIs are depicted in various visualizations. Risk Count:  Scorecard that displays the # of Risks for the selected criteria. Risk Priority:  Column chart that displays # of Risks by Priority. X axis displays various Risk Priorities. Data labels indicate the number of Risks associated with that category. Risk by Status: Column chart that displays # of Risks by Status. X axis displays various Risk statuses. Data labels indicate the number of Risks associated with that status. Risk by Target Resolution Date: Column chart that displays # of Risks by year of Target Resolution Date. X axis displays Year. Data labels indicate the number of Risks associated with that category. Grid: Displays Risk details such as Investment ID, Investment Name, Investment Manager, Risk ID, Risk Name, Owner, Status, Priority and Target Resolution Date. You can further narrow your search by OBS Type, OBS Path and Target Resolution Date range.
  • Project Time Summary report provides view of Allocation hours, EAC hours, ETC hours and Actual hours for Projects.  User can further narrow their search by OBS Type & Path and Project Manager.
  • Project Status and Costs report has the details of the Project Schedule, Scope, Cost and Effort Statuses along with Planned, Budget & Actuals costs. There is also graphical representation that shows Top 10 projects by Planned Cost, Budget vs Planned vs Actuals by Cost Type. User can further narrow their search by OBS Type & Path, Project(s) and Project Manager.
  • All Change Requests report provides project managers a single place to view KPIs related to Change Requests.  All the KPIs are depicted in various visualizations. Change Request Count:  Scorecard that displays the # of Change Requests for the selected criteria. Change Request by Priority:  Column chart that displays # of Change Request by Priority. X axis displays various Change Request priority. Data labels indicate the number of Change Request associated with that category. Change Request Status:  Column chart that displays # of Change Request by Status. X axis displays various Status. Data labels indicate the number of Change Request associated with that Status. Grid: Displays Change Request details such as Investment ID, Investment Name, Investment Manager, Change Request ID, Change Request Name, Status, Priority and Expected Close Date. You can further narrow your search by Expected Close Date Range, OBS Type and OBS Path.
  • All Issues report provides project managers a single place to view KPIs related to Issues.  All the KPIs are depicted in various visualizations. Open Issues:  Scorecard that displays the # of Issues that are not closed or resolved. Average Days Open: Scorecard that displays the # of days on an average an issue is in open state. Issue category:  Column chart that displays # of Issues by category. X axis displays various Issue categories. Data labels indicate the number of Issues associated with that category. Issue Priority:  Column chart that displays # of Issues by priority. X axis displays various Issue priority. Data labels indicate the number of Issues associated with that priority. Grid: Displays Issue details such as Project ID, Project, Issue ID, Issue, Category, Assigned To, Status, Priority, Target Resolution Date and Days Open. You can further narrow your search by OBS Type, OBS Path, Project(s) and Project Manager.
  • Missing Time by RM report displays Resources whose timesheets are missed by Resource Manager. There is Clustered Column Chart which displays missed timesheets count by Resource Manager. Also, there is table view of Resource Manager, Resource, Time Period Start and Finish Dates, Total Hours and Timesheet status.  User can narrow their search by OBS Type & Path, Resource Manager, Resource, Timesheet Status and Time Period Start Date (Relative or Specific Date Range).
  • “Real” Resource management is not for the faint of heart. To get a solid picture of the actual capacity multiple dimensions have to be considered: projects, daily business, absences, different work hours and more. In this session we will demonstrate how this can be done with the help of “Advanced Resource Planning” in Clarity. We will staff projects in seconds, simulate different options, jog new projects in and finally simulate the resource aspect of whole Roadmaps.
  • All Tasks report provides project managers a single place to view KPIs related to Tasks.  All the KPIs are depicted in various visualizations. Pending Actuals:  Scorecard that displays the # of Actuals that are still open and not yet posted. Average Days Old:  Scorecard that displays the average number of Task Days Old. Days Old is the difference between Task Finish date and Today’s Date (when Today’s Date > Task Finish date. In other cases, it is zero) Tasks by Finish Date: Column chart that displays # of Tasks by Year of Finish date. X axis display Calendar years. Data labels indicate the number of Tasks finish date within that year. Actuals by OBS level 2: Column chart that displays sum of Task Actuals by OBS level 2. X axis display OBS level2. Data labels indicate the Actuals within that OBS level2. Grid: Displays Risk details such as Project Name, Project Manager, Task Name, Task Status, Start Date, Finish Date, Days Late, Days Old, Actuals, ETC and Pending Actuals Days Late is the difference between Task Finish date and Baseline Finish Date (when Baseline Finish Date > Task Finish date. In other cases, it is zero) You can further narrow your search by OBS Type, OBS Path, Project(s) and Project Manager.
  • Assignments by Task Over Time report display all assignments by task for all resources. Information is displayed on monthly basis. This report displays Investment Name, Task Name, Resource Name and its monthly assignments. You can further narrow your search by OBS Type & Path, Investment Manager, Investment Name, and Year
  • Project Manager- Resource/Compliance report provides project managers a single place to view Compliance status for various critical KPIs.  All the KPIs are depicted in various visualizations.
    • Unfilled Demand: Donut chart that gives you the count of roles (within projects) that are not filled by resources.
    • # Of New team members: Scorecard that displays the count of new team members added to the projects.
    • Resource Constraints: Donut chart that gives you the count of Over utilized and underutilized resources
    • Unsubmitted Time:  Dial gauge that displays the count of resources that did not submit time.
    • Stale Tasks:  Dial gauge that displays the count of tasks that are past their due date
    • Status Report Compliance:  Dial gauge that displays the compliance of status reports for various projects.
    You can further narrow your search by Project Manager
  • Project Variance report provides project managers a single place to view all their active projects, open tasks, Task EAC hours, Task Baseline hours and their variance.  Project Managers can use this report to view and manage their projects progress against their baselines. They can easily detect the projects that are running behind and pinpoint the tasks that are causing the variance in the schedule.  You can further narrow your search by OBS Type, OBS Path and Project.
  • The Rego Roadmap Ranking provides the ability to rank Roadmap Items within individual Roadmap Scenarios. The function allows the user to define a hierarchical sequence to defined attributes to create a set of rules to generate an auto-ranking, by scenario. Large sets of ranking rules increase complexity and variability, so choose initial rules carefully. When the rank order is configured, a process is actioned that auto-ranks the Roadmap Items for the selected Roadmap Scenario. The Roadmap Ranking can be viewed through the Timeline, Board, or Grid View.
  • This training document is a Rego Consulting Quick Reference Guide to assist with utilization of the Staffing page in Clarity’s Modern User Experience.  This doc references version 16.3 views. Document provides detail on the layout and capabilities of the Staff Grid as well as the Allocations Timeline. Information is provided on columns, widgets and filtering. Instructions are provided on how to save Views. Summary information is provided on the layout of the Allocation Timeline and includes detail on the Investment Timeline and the Resource Histogram. Investment Timeline summary contains information on the Allocations by Investments and the Allocations by Resources tabs. While the Resource Histogram section provides screenshots on Resource Availability and Resources by Role.
  • This asset in used to update investment level TSV attributes using Cost Plan, Budget plan, Actual transaction, Planned and Budgeted Benefit Cost data as needed. It uses mappings/logic from ‘Cost Rollup Mappings’ object. Compatibility – Its compatible from 16.0 onwards with Oracle, PostgreSQL and MSSQL.
  • Manage default views for new users based on security groups or publish a view to all users in a specified security group. For more details, please refer to the detailed documentation.

  • The Financial Summary by Transaction Class provides a visual graph for each year’s financial picture for multiple years. Report contains the following items: KPIs: Displays total benefit, capital, expense and net cash flow for the selected filter criteria Grid: Displays year wise break up of benefit, capital, expense and net cash flow for the selected filter criteria Graph: Benefit, capital, expense and net cash flow are depicted in graphical way for multiple years. This report will show the user where they need to concentrate their efforts in order to meet financial commitments. User can further narrow their search by OBS Type & Path.
  • Allocation Compliance Pie Chart report provides resource managers a single place to view Allocation compliance for various resources. It displays the following: Allocated Hours by OBS chart: Pie chart that displays percentage of resources that are fully allocated (80 -120 %) and under allocated (less than 80%) for a particular OBS and selected period range. Grid: Displays Resource Name, Resource Id, Primary Role, Booking Manager, Period, Allocated hours and Actual hours during that period. You can further narrow your search by OBS Type, OBS Path & Period Date range.
  • The Custom Attributes in System portlet displays all of the custom attributes present in the system and the lookup (if applicable) associated with each. This portlet is useful finding a custom attribute on an object, auditing, or for documentation purposes. The user may narrow the results by object, data type, and last updated date.
  • Missing Time by OBS report displays Resource whose timesheets are missed. There is Clustered Column Chart which displays Timesheets count by Resource. Also, there is table view of Resource, Resource Manager, Time Period Start and Finish Dates, Total Hours and Timesheet status.  User can narrow their search by OBS Type & Path and Project Manager, Resource Manager, Resource, Timesheet Status and Time Period Start Date (Relative or Specific Date Range).
  • This training document is a Rego Consulting Quick Reference Guide to assist with the creation of Status Reports in Clarity’s Modern User Experience.  This doc references version 16.3 views. Document covers the creation of Status Reports via the Status Module as well as the Status Report Module. Detail is provided on the widgets that can be used within the Status Report canvas as well as instructions on how to configure the canvas. Detail is also provided on how to Preview and Publish status reports.
Go to Top