- Is applied consistently so it can be improved.
- Retains the data in Clarity to enable analysis.
- Provides ongoing feedback by comparing estimates to current EAC.
- Provides historical record of estimating for projects overall as well as change requests.
-
The Rego Estimation Module Provides a more accurate estimate earlier in the idea/project lifecycle. -
Styles can be applied to reports in two ways. The first is to select the item and apply a style directly to it. The other is to apply a style to an entire report. When an item has had a style directly applied to it the application of a style to the entire report will not change the styles with manual styles applied. The manual styles override the entire report style application. This trick shows you how to find and remove manual styles. -
This Tech Trick allows the ability to link anywhere within the larity environment from a custom portlet link, even if it is not a standard OOTB link option. For example, you could link to a Departments page or directly to a timesheet even though these are not standard OOTB links to choose from when creating custom portlets. This trick works in Clarity versions 12, 13 , 14 and 15 for both SQL and Oracle environments. -
In many instances, having excess information stored within the database can cause poor performance or slowness when retrieving data. Administrators are always seeking out ways to clean and remove unused information. This technical trick on role removal provides the steps necessary to remove roles that would otherwise be unused and eliminating unwanted information. The Role Removal Technical Trick provides the information for the creation of the following tables and columns which are necessary to perform the role removal:- Role – mapping table
- Tables / Columns that need to be updated with Resource ID fields
- Tables / Columns that need to be updated with Role Code fields
- Tables that will need to be deleted
- PRTEAM table should be checked
-
The Concatenate Multi-Value Lookup into One Field for Display Purposes technical trick provides an overview of how to group or concatenate the various levels and values of a Multi-Value lookup into one field in both Oracle and SQL Server environments. This allows the lookup values to be more easily displayed in a portlet. The function concatenates the values together using a choice of delimiter, which then allows the multi-value lookup to be viewed as one portlet column, in the same manner as any other object attribute. -
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. -
This Process sends an email to every Action Item Assignee where the Due Date/Time has passed and the Status is either Open, or In Progress. Users may want to modify this stalker to include Status = Deferred. In addition, the Resource Manager for the Assignee receives a copy of the email. In order to generate emails, the SMTP gateway must be up and running and Resources must have a valid email address. -
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.

