-
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. -
The REGO Timesheets - WIP portlet displays timesheet information for timesheets that have a status of posted but have not been posted to the WIP tables. This does not include records hung up in invalid transactions. Users can further narrow their search by Project Name, Resource Name, Timesheet Status, Start Date, and Finish Date. -
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
-
Pending Actuals report provides the Project Managers a single place to view all the pending actuals on tasks across multiple projects. User can view only the projects that he has access to. Managers can use this portlet to analyze the actuals that have been submitted but not posted on tasks. You can further narrow your search by OBS Type & Path and Assignment Total. -
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. Project Managers can use this view to compare various costs for that project in a particular month. User can further narrow their search by OBS Type & Path, Is Project Active?, Fiscal Month Start Date, Investment Manager and Investment Name. -
Time by Investment report displays time spent by resources on investment(s). User can view only the investments that he has access to view. Information can be drilled to Yearly, Quarterly or Monthly level. User can further narrow their search by OBS Type & Path, Investment Name, Month Start Date and Is Project Active?. -
Time by Assignment report displays time logged to assignments and its associated actuals on monthly basis for all filtered investments. It also displays total ETC and Actual hours associated with an assignment. User can further narrow their search by OBS Type & Path, Investment Type, Investment Charge Code, Investment Name, Task Name, Resource Name, Assignment Start Date and Assignment Finish Date. User can use exact dates or relative dates for Assignment Start and Finish Dates filter parameters.

