-
The Capacity vs Demand 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 Capacity vs. Demand by Resource report displays resource capacity and demand at the resource level across investments. The report gives you visibility into the capacity, demand, and remaining capacity by resource. The report displays amounts by week or month, and in total. The amounts might be displayed as hours or FTEs. -
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.0.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 training document is a Rego Consulting Quick Reference Guide to assist with the adding of resources to the Staff tab for Ideas in Clarity’s Modern User Experience. This doc references version 16.0.3 views. Document provides detail on how to add resources to the Staff tab, Default Allocation % and Per-Period metrics. -
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.0.2 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. -
The Current Proxies portlet provides a user with an overview of all the resources in the system currently using a proxy. This portlet is helpful to determine a proxy if a user is currently out of the office. The portlet provides several pieces of information related to the resource including: resource names, proxy, start date, end date, days remaining, total days, and if the proxy is active. The user may filter by resource name, proxy name, proxy status (defaults to Yes), and start/end dates (defaults to the current date). -
Allocation Compliance Area Chart provides the resource manager a single place to view the Monthly Resource Allocation compliance for all resources in the form of an Area chart. Allocation Compliance is calculated based on the value of 'Availability to Allocation Hours %' Allocation Compliance is 'Under Allocated (Less Than 80%)' WHEN 'Availability to Allocation Hours %’ is less than 80 Allocation Compliance is 'Appropriately Allocated (Between 80-120%)' WHEN 'Availability to Allocation Hours %' is between 80 and 120 Allocation Compliance is 'Over Allocated (Over 120%)' WHEN 'Availability to Allocation Hours %' is greater than 120 User can further narrow their search by Resource Is Active?, OBS Type, OBS Path and Month Start Date. User can use exact dates or relative dates for Month Start Date filter parameter. -
The Timesheet Smoothing Process Workflow kicks-off when an individual timesheet is Submitted. It splits each transaction on the timesheet when total timesheet actuals exceed total weekly availability for the resource. Total weekly availability is determined by multiplying resource availability rate by the number of workdays in the week. Non-workdays include weekends, holidays, PTO, and other scheduled days off, as set on the resource calendar. If timesheet actuals <= total weekly availability, then the timesheet remains unchanged. But if timesheet actuals > total weekly availability, then the following occurs. Each timesheet transaction is reduced by a calculated percentage that will reduce the total regular hours to equal the total weekly availability. Then the remaining transaction hours are placed in a “Split” row for that task on that day, with an Input Type Code set based on a process parameter (which parameter can be set within the script action on the process). Note: If a single day has overtime hours, but the total timesheet actuals <= total weekly availability, no splitting occurs. -
A process creating a new Cost Plan. Cost Plan properties:
Pre-conditions:Name Cost Plan created on: yyyy/mm/dd hh:mm:ss Grouping attributes Charge Code, Transaction Type Start Period The earliest fiscal period with Actuals (from PPA_WIP table) or current period, if there are no actuals Finish Period The latest fiscal period with a non-zero allocation (from PRJ_BLB_SLICES table, SLICE_REQUEST_ID = 6 Period Type Monthly Plan of Record True Planned Cost For periods in the past – from Actuals (Charge Code, Transaction Type, Quantity (Units), Cost (Amount) taken from Transactions (PPA_WIP & PPA_WIP_DETAILS); For current and future periods – from Allocations (Charge Code taken from the Project, Transaction Class from the Resource, Quantity from allocation slices, Cost from the Rate Matrix (NBI_PROJ_RES_RATES_AND_COSTS table) - the Project must be financially enabled.
- if a new Team Member is added, Rate Matrix job must be run, so the rates are populated in the NBI table.
- if the Allocation changes, allow the timeslice job to finish before running the process.
- the Project should have the Charge Code set.
-
Based on the pre-determined schedule frequency, this job will send an email to Resource Managers that have a Resource meeting the criteria of: Average allocations are less than 100% where Resource(s) and Project(s) are active over the next two weeks. This serves as a reminder to Resource Managers to monitor and manage allocations. The contents of the email include a message indicating the Resource Manager has at least one Resource meeting this criteria and a table indicating the Resource and that resource’s average, next 90 days allocations. -
The Time Tracking Stalker - RM workflow process automatically sends an email to Resource Managers for each one of their resources that have not submitted their timesheet for a prior open time period, thus informing the RM if their resources are submitting their timesheets on time. Project Managers will also benefit since the notifications will help to ensure that time is being posted against their projects in a timely manner, helping to provide them with an accurate view of time expended on the projects. -
The Time Tracking Stalker – Resource workflow process is used to notify resources that fail to submit a timesheet in a prior week. The workflow checks for active resources, hire/termination dates, track mode, and open for time entry. This process helps to ensure resources submit timesheets in a timely manner. In version 13, the email can be enhanced to include colors, bold, underline, and other HTML formatting. -
This portlet displays the % allocation of resources to projects. The portlet shows if the resource is allocated to the projects as an individual resource or as part of an Agile team, in which case it will display the resource % allocation to the team and what that will represent in terms of % allocation to the project. The Total Allocation % display the allocation of the resource to all investments is allocated to. Remaining Capacity and Over/Under columns will help identify the resources that still have availability and the ones that are over allocated. -
A Process run via Execute a Process job; sends an email to active resources, containing a facsimile of their Resource Allocation Detail page. It shows the next six weeks of allocations by investment, with a column total. The email also contains a click here link to this page in CA PPM, to enable editing of the data, as appropriate. -
The Timesheet Audit portlet displays timesheet information in order to perform an audit. The only required data needed to search the portlet is start and finish date. Additionally, you may narrow the results by filtering by resource, resource ID, OBS Unit, resource manager, timesheet status, project, and task. The portlet provides reporting on the following:- Resource
- Resource ID
- Email Icon of Resource (So the reviewer can quickly email the Resource)
- Resource is Active
- Resource Open for Time
- Time Period (Start and Finish Dates)
- Timesheet Status
- Is Adjustment (If the timesheet is adjusted)
- Timesheet Modified Date
- Timesheet Posted Date
- Timesheet Submitted By
- Timesheet Approved By
- Project
- Task
- Proposed ETC Hours
- Pending Actual Hours
- Total Actual Hours
-
The Dashboard: Project Information portlet gives a set of high-level information about the project. The portlet will pull the "id" from the page it is placed on, so this portlet is usually placed on the project dashboard tab. The portlet displays the name, project ID, project manager, description, start date, finish date, baseline start, and baseline finish. -
The Dashboard: Project Status Single-line portlet gives an overview of the project overall status as well as the status indicators on the "current" status report object. The portlet will pull the "id" from the page it is placed on, so this portlet is usually placed on the project dashboard tab. This portlet displays the report date, symbols relating to the overall status, scope, schedule, cost/effort, and the overall explanation across a single line in the portlet. -
The Dashboard: Phase Gantt portlet gives an overview of all WBS level 1 tasks or milestones for a single project. The portlet will pull the "id" from the page it is placed on, so this portlet is usually placed on the project dashboard tab. The portlet displays the name, and a graphical representation of the timeline for the phases. The date range may be configured by day, month, year, or quarter. The start date may also be configured to any date or a relative date (start of current month, start of next year, etc). -
This training document is a Rego Consulting Quick Reference Guide to assist with creation and management of resource Teams in Clarity’s Modern User Experience. This doc references version 16.1 views. Document provides detail on how to create Teams and add resources to a Team. Instructions are provided on how to add resources by OBS and how to allocate a team to an investment. Team key points are provided with regard to Classic, Allocations, ETC and Financials. -
The Auto-Approve Old Timesheets workflow process can be run through the "Execute a Process" job and may be used to quickly close out timesheets for a specified timeframe for period closure. The workflow will execute a query that will automatically approve ALL (no matter the status of the timesheet) timesheets that have a time period start date before the Approve Date specified within the process itself. -
The My Allocations portlet will display the allocations for the logged in user - pulling data from the timeslices. It is used as a quick reference for the users to view their allocations across all of the projects where their allocation is greater than 0 for the specified date range the user wants. This will display both active and inactive projects. -
The Missing Time by OBS portlet displays all missing or late timesheets for resources staffed within a specific OBS. Resources will be included if they are open for time entry, have the track mode of ‘Clarity’ and have a timesheet that is not posted. The portlet accommodates for hire and termination dates. Also, the portlet only shows resources that the active user has the security rights to view. Administrators and the Project Management Office may use this portlet to determine the timesheet status of all resources within a specific OBS in open time periods. This portlet allows a user to quickly search by OBS and view all timesheets under that area. After selecting the OBS, the user can also filter on time period start date, Resource Manager and/or Project Manager. The portlet will display a ‘Stop Light’ indicator based on timesheet status, the status, period start, Resource Name, Resource Manager and any actual hours entered for the timesheet. -
The Capacity Graph - Investment portlet displays Availability, Allocations, Assignments and Actuals for active resources in a single project. This portlet pulls from timeslices and allows the user to filter on weekly, monthly, or quarterly data. This portlet provides a Project Manager with a simple way to analyse: Allocations vs. Actuals and Allocations vs. ETC. Depending on metric goals, the graph allows the user to determine where areas of improvement may exist. -
The All Assignments portlet displays resource assignments across multiple projects. Currently, assignment information displayed for the project, in OWB, or MSP is limited to a single project. This portlet will provide a single view of the assigned data for all assignments across multiple projects. The portlet displays project actuals and estimates from the project (datamart tables). The Days Late field is calculated by the baseline date, while the Days Old field is calculated by today's date. Note: Only the projects that the user has viewer rights to will show up in the list. Filters provide the PM, RM, and individual resource the ability to monitor work progress across multiple projects. For example: ~ PMs can filter for all assignments that were to be completed by a given date but still have "Started" or "Not Started" status. ~ If multiple projects are utilizing the same resource, the PM or RM can filter for assignments utilizing that specific resource to prevent over-utilization. ~ A resource may filter for all assignments assigned to them, providing a picture of their total body of work. -
The All Assignments portlet displays resource assignments across multiple projects. Currently, assignment information displayed for the project, in OWB, or MSP is limited to a single project. This portlet will provide a single view of the assigned data for all assignments across multiple projects. The portlet displays project actuals and estimates from the project (datamart tables). The Days Late field is calculated by the baseline date, while the Days Old field is calculated by today's date. Note: Only the projects that the user has viewer rights to will show up in the list. Filters provide the PM, RM, and individual resource the ability to monitor work progress across multiple projects. For example: ~ PMs can filter for all assignments that were to be completed by a given date but still have "Started" or "Not Started" status. ~ If multiple projects are utilizing the same resource, the PM or RM can filter for assignments utilizing that specific resource to prevent over-utilization. ~ A resource may filter for all assignments assigned to them, providing a picture of their total body of work. -
The Resource Availability report provides visibility into each resource’s available capacity across projects. It allows users to view availability by resource, grouped by either resource manager or primary role, helping identify under- or over-utilized team members. The report can display data by week, month, or in total, and amounts can be viewed in hours or full-time equivalents (FTEs). -
The Over/Under Allocation by Resource report displays resource remaining capacity amounts by resource. The report displays amounts by week or month. The amounts can be displayed as hours or FTEs. This report allows you to drill down to the Capacity vs. Demand by Resource report, by clicking a resource name, to see more information about the resource capacity and demand. Report Prerequisites Verify that you have completed the following prerequisites before you run this report: • The Load Data Warehouse job must be run before you run this report. If the Data Warehouse is not populated, the report will not display any data. Also, most of the report parameters do not display options. -
Does your organization struggle with resource management? Have you considered creating a Resource Management Office (RMO)? Do you struggle with a lack of executive sponsorship to drive adoption? This session will review how some organizations are succeeding in driving adoption and effectively managing resources by engaging leadership, RMOs, and utilizing more dedicated resources. Learn best practices for driving effective resource management across your organization. -
The Populate Prior Periods Forecast From Actuals in Cost Plans process updates Cost Plans for Active Projects, it updates the Forecast for previous months = Posted Actuals, to remove variances from past periods. This is an On Demand process in Clarity named Populate Prior Periods Forecast From Actuals in Cost Plans and can be manually executed from the Organizer or scheduled through the “Execute a Process” job. If there are number of processes in the Organizer – Available Processes, this process can be filtered and then checked to Start. When the process is started it will be seen in the Initiated on the Processes tab. The process status can be monitored from Running to the Completed stage. The process is very flexible and supports Cost Plans with any given grouping and it also works without any dependency on timeslices or other jobs. The process fetches Cost plan of records for all active projects in the system that have Actuals transactions in WIP table. It then process those cost plans to update all of the prior monthly forecast periods with the corresponding monthly Actuals. -
This training document is a Rego Consulting Quick Reference Guide to assist with creation and management of resource Teams in Clarity’s Modern User Experience. This doc references version 16.0.3 views. Document provides detail on how to create Teams and add resources to a Team. Instructions are provided on how to add resources by OBS and how to allocate a team to an investment. Team key points are provided with regard to Classic, Allocations, ETC and Financials. -
This training document is a Rego Consulting Quick Reference Guide to assist resource managers with the approval of timesheets via the Review & Approve tab. This doc references version 16.0.3 views. Doc reviews accessing and selecting timesheets, reviewing submitted timesheets, approving timesheets, approving multiple timesheets, returning timesheets and the timesheet grid. -
This training document is a Rego Consulting Quick Reference Guide to assist with creation and management of resource Teams in Clarity’s Modern User Experience. This doc references version 16.0.2 views. Document provides detail on how to create Teams and add resources to a Team. Instructions are provided on how to add resources by OBS and how to allocate a team to an investment. Team key points are provided with regard to Classic, Allocations, ETC and Financials.

