-
Pie Chart displays projects by Baseline Finish Variance—is current project finish beyond baseline finish; or is current project finish on or before baseline finish. Filterable by OBS structure and Finish Date range. Data labels show percent within baseline vs percent outside baseline. Mouse-over shows Within or Outside label and percent of total projects. Legend shows color coded Within Baseline and Outside Baseline labels. Drilldown: Clicking on a pie slice yields a grid portlet of projects either Within or Outside Baseline. -
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. -
All Tasks report provides the Project Managers a single place to view all the tasks associated with a project(s). User can view only the investments that he has access. Project Managers can use this report to view the progress of the tasks and check how the tasks are performing against baseline date. User can further narrow their search by OBS Type & Path, Investment Name, Month Start Date and Is Project Active?. -
All Change Requests report provides the project manager a single place to view change requests across multiple projects. This report displays Project Information such as ID & Name, Change Request Information such as its ID, Name, Category, Owner, Status, Priority, Expected Close Date and Days Open. You can further narrow your search by OBS Type & Path, Change Request Status, Change Request Name, Change Request Category, Change Request Owner, Project Name and Project Manager. -
Resource Availability – 4 Weeks displays all resources with their total allocated hours by week, and an average availability percent (4 Wk Avail %) for next four weeks. This report also displays Resource Primary Role and Employment Type. User can further narrow their search by Resource Name, Resource Type & Week Start Date. User can use exact dates or relative dates for Week Start Date filter parameters. -
Allocation Compliance Pie Chart provides the resource manager a single place to view the Allocation compliance information in the form of a Pie 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, Allocation Start Date, Investment Name and Resource Manager. User can use exact dates or relative dates for Allocation Start Date filter parameter. -
Notify the PM with a list of tasks for their project as soon as the Timesheet is submitted. This is a good substitute for PM approval. When a timesheet is submitted, then the PM knows the time entered by person. This is an Auto-start process in Clarity named PM Time Notification - On Timesheet Submission and will be automatically spawned when a Timesheet is submitted. 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 Progress when 100% and the Status is Completed, an email would have arrived to the Project Manager with subject: “Resource <Name> has entered the following time on your Investment(s) for the week starting <Timesheet Start Date> ”. This email will list the Investments managed by the PM where task was entered by the Resource submitting the timesheet. Each PM would get a separate notification. PM for project X notified, and PM for project Y gets notified in another email. Therefore, one timesheet may spawn out multiple emails. But, if both the Projects have the Same PM, then only a single email gets sent out. “Opt-out Timesheet Notifications" checkbox is provided on the Project for PM’s who do not want to get notified on those projects. -
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.
-
“PM Stalker – Project Validations & Issues” executes various queries against the Clarity database and sends an email to all PMs who have one or more projects with any of the following conditions:- Resources have booked time in the past week (validation needed)
- Inactive Resources with ETCs still on the project
- Tasks past their Finish Date but not completed
- Task Role Assignments in the past
-
A process that:- is a weekly email to a project manager. All of the content will be for where the person getting the email is the PM
- shows aggregate data for all of their projects
- sends the PM a reminder email at the end of each week showing the items that the PM needs to do. Maybe call it Weekly PM reminder.
- Shows the mentioned data in sections as follows:
- Past Due issues
- Only active projects
- Only open issues – not resolved or closed
- Show project name, project ID, issue name, issue priority, target resolution date, color (only red or yellow)
- Logic for Yellow = where target resolution is within the next week
- Logic for Red = target resolution date is in the past
- URL LINK: to that issue
- Past Due Risks
- Only active projects
- Only open risks – not resolved or closed
- Show project name, project ID, risk name, risk priority, target resolution date, color (only red or yellow)
- Logic for Yellow = where target resolution is within the next week
- Logic for Red = target resolution date is in the past
- URL LINK: to that risk
- Past Due Status Report
- Only active projects
- Show project name, project ID, report date, most recent overall status, color (only red or yellow)
- Only 1 line per project – show even if there is no status report
- Logic for Yellow = where latest status report date > 7 days ago
- Logic for Red = latest status report date is > 14 days ago
- URL LINK: to status report list
- Past Due Milestones
- Only active projects
- Only open milestones
- Show project name, project ID, task name, task finish date, color (only red or yellow)
- Logic for Yellow = where finish is within the next week
- Logic for Red = finish date is in the past
- URL LINK: to that milestone
- Past Due Forecast
- Only active projects
- Show project name, project ID, last updated date, most recent total plan of record amount, color (only red or yellow)
- Only 1 line per project – show even if there is no finish plan
- Logic for Yellow = where last updated date of the plan of record > 14 days ago
- Logic for Red = where last updated date of the plan of record > 30 days ago
- URL LINK: to cost plan
- Allocation Summary for the Project Team
- Past Due issues
- Unfilled Roles that need to be staffed
- Resources Actuals +/- 25% of Allocation
- Resource ETC +/- 25% of Allocation
- Pending Change Controls / Approval Status
- In addition to the Past Due Milestones, upcoming milestones
- Budget Summary
- Actual vs. Planned
- Burndown estimate
-
The interface runs using a MS Excel template called Project Allocation Upload that will be distributed to users.- Configuration
- A master object called Allocation Upload Files will be created. The object will contain a required attachment field on the create page that will receive the Project Allocation Upload MS Excel file.
- A new sub-object called Allocation Upload Records will be created. This object will contain the fields necessary to receive the data rows from the Project Allocation Upload template.
- The master object will store the file level data while the sub-object will store the rows that belong to the file.
- Users must be granted security to view and edit the master and sub-objects in order to run the upload process.
- Project Allocation Upload Template
- The Project Allocation Upload template must remain static. Any changes other than creating additional time periods or additional rows will cause the process to error.
- Only the Project Allocation Upload template can be used to load records to the new objects.
- The Project Allocation Upload will only accept months across the x-axis in the format DD/MM/YYYY. The month headers must appear in the first row of the template and contain the first day of the month.
- The template must be distributed to the users that will be using the upload functionality.
- Users will be required to enter an Investment ID and Resource ID so the process can correctly identify investments and resources to upload the allocation hours against.
- A Staff OBS is not required but can be populated by users to have the data uploaded into CA PPM.
- The owner of the Project Allocation Upload template is responsible for providing users a valid list of Staff OBS Units.
- Investments will not be created through the interface. As such a valid Investment ID must be provided.
- Resources can be added to the investment team through the interface. If a valid Resource ID is provided the resource’s allocation will be updated if the resource already exists on the investment. If the resource does not already exist on the investment the resource will be added to the team along with the allocation hours.
- The Project Allocation Upload template will accept hours, not allocation percentages. Because CA PPM stores allocations as percentages of a resource’s availability the upload process must convert hours to a percentage. As a result small rounding errors may occur in the neighborhood of .01 hours per month.
- Resources cannot be removed from investment teams through the interface.
- The Project Allocation Upload template will support allocation uploads to different instances of the same role on the same investment as long as different Staff OBS units are provided.
- If multiple instances of the same role are assigned to the investment with the same Staff OBS the process will not know which instance of the role to upload the hours to. In these cases the process will consider these records as invalid. The PM will need to manually remove one of the instances or upload the hours manually..
- If multiple instances of the same role with the same Staff OBS unit are assigned to the same investment in the upload template the monthly hours will be totaled by investment, by role, by Staff OBS.
- The allocation template will follow the format in the screenshot area.
- Process
- To initiate the Allocation Interface a user will create a new Allocation Upload File instance, attach the Project Allocation Upload Template, and save the record. The file attachment field is an “enter-once” field, meaning that once a value has been set it cannot be changed. If a user wishes to upload another field they will create a new record.
- After the file has been attached the user will be presented with two check box fields, one to Validate and one to Validate and Upload. Checking either or both options will initiate the process.
- The process will first determine if any sub-object instances exist for the file. In other words, do any records already exist in the Allocation Upload Records sub-object pertaining to the newly uploaded file. If there are no records in the sub-object the process will use the uploaded file and read its contents into the sub-object. If errors are encountered during the file read they will be written to the process console, the process will throw an error, and end.
- Next, records will be validated. Only the sub-object instances that belong to the master object will be validated. Records belonging to other master object instances will not be validated or processed. All records in a status of Ready for Processing, Failed Validation, or Xog Load Error will be validated. Records will fail validation if an investment is not found corresponding to the investment ID provided, a resource is not found corresponding to the resource ID provided, or the date provided is not valid, or a provided Staff OBS does not yield a match. Records that fail validation will be flagged as invalid along with a description as to why they failed validation. Records that pass validation will be flagged as Ready for Processing and locked. The sub-object instances can be exported to excel if further analysis is required. If the Validate & Upload option was not selected the process will end here.
- Regarding the Staff OBS. Only one OBS can be designed as the OBS that the interface will use to validate the Staff OBS records.
- The Staff OBS value from the template must match against the name of an OBS node in the designed Staff OBS.
- If the Staff OBS value matches against multiple nodes in the Staff OBS the record will be flagged as invalid as the process will not know which node to use.
- If the Validate & Upload option was selected the process will continue and any valid records will be xog’ed into the investment team. The xog will be executed as the user that initiated the process so any security rules enforced by xog will be respected by the process.
- Successful records will be flagged as Processed Successfully in the sub-object and remain locked. Records that did not load successfully, due to a xog error or security limitation will be flagged as Xog Load Error, unlocked, and updated with a description containing the full xog output.
- Records that failed validation or failed the xog load can be manually edited and revalidated, and attempt to be uploaded again. Subsequent runs of the process will not read in data from the file, but rather process only sub-object instances that currently exist.
- Configuration
-
This process updates the team, assignment and timesheet roles with the primary role where they do not match. This way, the PM can push all roles to team and assignment for that project before they do a cost plan. -
This process pulls in the total hours tracked, by resource, by task, for a given project for the weekly time period that ended. The information is sent to the Project Manager listed on the project. This process can be scheduled via the Execute a Process job. -
This process, Shift Project Dates, helps Project Managers change an entire Project / Idea’s dates to a new start date. Once the three attributes are added to the Idea /Project Views, the PM can trigger the process by entering a date in the New Start Date field and checking the Shift checkbox. The process runs automatically on Save. The process calculates the date difference between the original Start Date and New Start Date then shifts all Allocation, Task, and Assignment dates by the calculated difference. For example, if a Project is set to begin on January 1st and needs to be pushed to a February 1st start date, the process first determines that there are 31 days between the original start date and the new date. Next the process increases the start date for each Task, Allocation and Assignment by 31 days. NOTE: The process will shift Allocation dates regardless of resource restrictions such as a Termination Date or non-working time as marked on their calendar. The Team page will reflect the Available Start and Finish as shifted by the process, but the Allocation hours and % will take unavailable time into account. For example, if a shift process sets the start date for a resource to be after their date of termination the dates will change by the date difference, but the Allocation hours will correctly be calculated as zero. -
When a task is marked as complete the process looks to any tasks that are dependent on the newly completed task. If a task is marked as “Not Started” and all of the dependency tasks are marked as complete then the process will change the task status to “Started” and email all resources that are assigned to the task that has started. The process notifies resources that a task is ready to start and saves the project manager the manual effort of updating dependent tasks. NOTE: The process relies on task dependencies and is most useful in those environments where task dependencies are managed. -
The Move Role to Team/Assignment process takes the role from the resource object and pushes that information into the team and assignment objects when the role is NULL on the team and assignment objects. This happens normally, assuming a resource has their primary role populated. This process is needed if a resource or set of resources were added to projects without having their primary role filled in. -
The Timesheet Approval - RM and PM process is an auto-start process that begins once the resource submits his or her timesheet. This process provides a checks-and-balances style to ensure that all resources entering time have entered the 40 hours. Once the timesheet is submitted, the process will lock the user’s timesheet to prevent editing. The process will then select the next action based on three different factors:- The timesheet has less than 40 hours.
- The timesheet has 40 or more hours.
- The resource’s availability is less than 8hrs/day.
-
The Status Report Publish workflow process pushes values from the status report sub-object to the parent project object. The process is started when the user ticks the “Publish” Boolean field on the status report (custom field added). This workflow will update the project object with the overall status indicator, the status comment, the previous overall status, and the as of date. This eliminates the project manager having to update the fields in both the status report and the project overall. -
The Grant Project Edit Rights workflow process allows a project manager to grant project edit rights to another user without contacting an administrator. The workflow uses the Out-of-the-box field for Business Owner. The script starts when the field is updated. It will assign project edit rights to whichever user is added to the Business Owner field. This process can be modified to grant project edit rights to any user within a project field. -
The Re-Baseline via Change Request process is a simple method for a member of the project (who has the ability to create change requests) to request a re-baseline of the project without the project manager having to perform it. First, the user must create the change request. The user must then start the process within the change request by using the Processes tab. Once started, the process will route an action item to the Project Manager. If rejected, the process will end and the user must start it again (if needed). If approved, the process will then baseline the project and close out the change request. -
Course Description: How do companies track stage gates within Clarity PPM? This session will review some best practices for tracking, monitoring, and approving stage gates within Clarity PPM. We will also discuss pros and cons of various options to help you select the best method for your company. -
Course Description: Does your company have Office 365, but you’re not sure what it can do for you? This session will cover what Office 365 is, including insights into how Office 365 can help your teams work faster and smarter. -
Course Description: Are your project teams using SharePoint effectively and getting the most value out of it? Is document management a daily struggle? Learn how to use SharePoint with Clarity PPM to seamlessly improve collaboration and team productivity. -
Learn about the various techniques and emerging methods companies are taking to capitalize Agile work. You'll learn how some companies are moving away from timesheets and using models based on story points and team rates to generate capitalization reporting. -
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 -
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 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. -
This portlet will allow administrators or other managers to see what resources have been granted instance rights to any investment. Filtering is available by resource, investment or right. -
Grid Portlet displays project and task data--including name, dates, status, effort, %Complete, and schedule. Portlet initially displays project data. But there is a + sign toggle, which, when clicked, reveals task data, and the toggle becomes a – sign. User can choose to Automatically Expand all levels from Options Icon>Configure>List Column Section>Options. Portlet supports up to 10 levels of WBS. Portlet filterable by project name and ID, OBS structure, manager name, active/inactive, and open for time entry. -
This portlet displays the projects by Stage in a pie chart. Every piece of the pie chart represents a stage of the Project Management methodology applied. The portlet also shows the number of projects on each stage. The legend displays all the different project stages appearing on the portlet. This portlet can be filtered to show only projects from a particular OBS unit or for a particular Project Manager. -
This portlet shows the variance between the budgeted cost and the planned cost for projects. This allows for the variance to be displayed between what was planned and what was approved. This provides the PMs with the ability to better plan the costs. -
“Resources with No Basic Matrix Entry” portlet displays combinations of project and resource where the assigned resource does or does not have a rate established for that project. Portlet is filterable by Projects, Project ID, Resources, and Missing Rate (Yes, No, All). How does this work? The Rate Matrix Extraction job populates a record into the NBI_PROJ_RES_RATES_AND_COSTS table for every resource/project combination that meets any of the rate matrix criteria. This portlet checks that table, and sets the Missing Rate attribu -
The portlet shows the project spend to vendors by month. The Vendor field picked on the portlet comes from the Vendor mentioned when creating the voucher (as displayed on the first screenshot). This provides a nice view of identifying how much is spent by an organization on the vendor employees on their workforce. -
Part of the Business Transformations collection, this portlet displays planned revenue as defined by a project whose goal is "Grow the business". It uses the Planned Revenue Query as a data provider. This portlet provides a holistic overview of how many projects following the goal “Grow the Business” are Critical/ At Risk / On Track with regard to the planned revenue. -
Part of the Business Transformation collection, this portlet displays count of the planned benefits (savings) per project manager. It also displays if any of the planned benefits are Critical/ At Risk / On Track, along with the total planned benefit amount.
Copyright 2023 • Rego Consulting Corporation • Privacy Policy