RegoXchange
  • So, you have the portlet xogged in, what now?  This guide will show you how to create a page, add the portlet to the page, and add the page to the menu.  This activity requires the appropriated admin rights to add content to CA PPM.
  • 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.
  • 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.
    Or
    • 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.
  • The Unlock Projects workflow process can be run through the "Execute a Process" job.  The workflow will execute a query that will automatically unlock projects that have been exported / checked out for over 2 days.  This prevents any projects from remaining in the “locked” state for a long period of time, preventing time from posting to these projects.
  • 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 Grant RM Timesheet Edit Rights workflow process can be run through the "Execute a Process" job.  The workflow will execute a query that gives a Resource Manager Timesheet Edit rights for their resources. Timesheet Edit rights are not inherent for Resource Managers when they are named as an individual’s resource manager.
  • There’s an upgrade in your future. Do you want to understand the costs, durations, and lessons learned? We’ll review existing and upcoming releases, the pros and cons of moving to various versions, and upgrade strategies, so you can prepare your budget and plan.
  • Course Description:   Struggling to figure out how to best organize your blueprints? This class will walk through best practice blueprint design, including how many to have, how to use channels, using custom subobjects within the blueprint, and swapping blueprints at various project stages to mimic project phases or ideas. We’ll highlight some of the creative ways we’ve seen blueprints used in client implementations.
  • Course Description:  Do you already have a basic understanding of Jaspersoft Studio development? This session will include advanced topics like duplicating and modifying an OOTB report, multiple datasets, subreports, charting, widgets integration, and crosstabs. The detailed agenda is as follows: Jaspersoft Advanced – Out-of-the-Box Customization (2 hours) • Discover how to use OOTB reports, OOTB domains, resource bundles, and security access grant schemas. Jaspersoft Advanced – Chart Development (2 hours) • Explore multiple advanced charting techniques and types using built-in charting components, including properties (colors, plot options, sizing, gauges, etc.), dual pie chart, time series, and heat map. Jaspersoft Advanced – Scriptlets (2 hours) • Understand the basics of Jaspersoft Studio scriptlet development, utilizing Java libraries in custom Java classes to perform complex tasks in a simple manner. Jaspersoft Advanced – Roundtable (1 hour) • Understand crystal capabilities missing in Jaspersoft Studio, including sharing examples, report bursting needs, automation needs, and working with internal BI groups.
  • 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.
  • The Invalid Transactions portlet displays all of the transactions that did/will not post in Clarity. The benefit of this portlet is that you can use the filter to select a specific project, resource, or error to display all transactions associated to your selection. There are several reasons a transaction may fail to post such as inactive resource, no location or inactive location selected on the Financial sub-page, project on hold, etc. To resolve the error, the user must go into the project or resource and make the noted change. Once all corrections are complete, the  Post Transactions to Financials job must be run to evaluate the corrected WIP transactions to be sure the data is now complete and accurate. If additional incorrect data is found, the transaction will fail to post again and the new error/reason will display.
  • The Missing Time by RM portlet displays all missing or late timesheets for resources for which the logged in user has resources (logged in user is the RM).  Resources will be listed if they are open for time entry, have a track mode of Clarity, and have timesheet that is not posted (accommodates for hire and termination dates). Resource managers may use this portlet to determine the timesheet status of all resources in open time periods. The portlet will display an indicator based on timesheet status, the status, period start, resource name, and actual hours for the timesheet.
Go to Top