-
This document provides an overview of how hierarchical portlets can be exported to MS Excel. The code of a sample hierarchical portlet is explained. The included sample portlet shows a list of projects and the tasks under each project along with actual and assignment hours. The portlet can also be filtered by project and project manager. -
Allocation Compliance for PM report gives a view of resource Allocation percentage for active resources on the team of an investment for a selected Investment Manager. It allows the PM to see resources on their project over the coming months and whether they are over or under allocated. Allocation Percentage is calculated as (‘Allocated Hours’ / ‘Available Hours’) * 100. User can further narrow their search Month Start Date and Investment Manager. User can use exact dates or relative dates for Month Start Date filter parameter. -
The process is built to clear the random timesheet locks that happens occasionally. There are three Processes and one lookup component and one job definition in the package.- PRLock (Timesheets) Record Removal (ID: rego_prlock_rec_rmvl). This process requires PRNAME, PRTABLENAME and PRRECORDID from PRLock Table.
- The Lookup PRLock Check (Timesheet) (Id: REGO_PRLOCK_CHECK) should be used to update the GEL parameters for the above process.
- PRLock (Timesheets) Record Removal All (ID: rego_prlk_rc_rmv_all) This deletes ALL prtimesheet locks.
- Rego Remove Timesheet Locks (ID: rego_rmv_ts_locks). This process is run as a job “PrLock Clear for Timesheet Locks” which performs the same functionality as the above two processes. The process and job definition are separate XOG files.
- PRLock (Timesheets) Record Removal (ID: rego_prlock_rec_rmvl). This process requires PRNAME, PRTABLENAME and PRRECORDID from PRLock Table.
-
The All Lookups and Attributes portlet provides the ability to see all static lookups in the system, as well as their lookup values. Ability to filter and view the population by lookup name and ID, value name and ID, whether or not the item is active, and whether or not the item is a system (seeded) value. A system value is a record that comes with a base installation of Clarity as opposed to a value that was added manually or through a Clarity Add-in. -
Are your reports and portlets performing well? This class will walk through specific SQL tuning tricks to make queries run faster, increase end-user satisfaction, and smooth-out system performance. This is an easy way to promote efficient future development and make a huge, positive impact on user experience. -
Launch a Team chat with your users directly from the Clarity PPM tool. This is a good way to collaborate with the team and users for any quick update or interaction. This is a scheduled process in Clarity named Sync MS Team Launching Chat URL and will be scheduled to run for various frequency. When the process kick in it will be setting the Team link into the custom URL attribute of the Resource, which can be used to Launch Team chat from the tool. Sync Process come with two parameters for the Support team, which they can use as per there environment configurations. These two Gel parameters for quick configuration are:- launchMSTeamField: parameter for the Custom Resource Field to store Launch URL
- emailAddressField: parameter for field to pick mail address in SRM_RESOURCES table
-
The Last Logged In portlet provides the administrator with an overview of all users within the system and the last time he or she logged into Clarity. Using this portlet, administrators can quickly cleanup any inactive users or provide a list of users to managers that are not logging into the system. The portlet provides several pieces of information related to the resource as well as a “Days Since Last Login” with a status indicator. The administrator may filter on resource/id, OBS, user status, resource manager, or last logged in date to narrow down the results. -
The Allocation Compliance by Resource (Resource Manager) portlet gives a view of resource allocation compliance for all active resources the logged in user is the Resource Manager for. It allows the RM to see resources they manage over the coming months and whether they are over or under allocated. This portlet leverages the daily allocation and daily availability slices as well as only active investments. The portlet provides filters for specific dates, filtering by resource ID, and resource name may also be added.

