RegoXchange
  • Fiscal periods in DWH may need to be changed if we need to increase or decrease the number of periods for reporting.
  • 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.
  • This tech trick demonstrates how to use Microsoft Excel to map data to XOG files by using the Developer tab in Excel 2010+.  Using a standard XML XOG file as provided by CA the guide and walkthrough video shows off the power of Excel and the ease in which object instance values can be directly inserted into or updated in Clarity.
  • The User Activity portlet is in essence an expansion of the out of the box User List by License Type portlet, which only display the Last Logged In date of resources.  This portlet offers several additional fields to help admins dig deeper into user activity within the tool. The table below describes the available filter fields for the portlet.
    Column Label Description
    OBS OBS the resource(s) belong to
    Resource Full Name Resource’s First and Last Name
    Resource ID Resource’s ID
    First Name Resource’s First Name
    Last Name Resource’s Last Name
    Date Last Logged In Date the Resource last logged in
    Date Last Time Investment Updated Date the Resource last made an Investment update
    Resource Active The Resource’s active status
    Employment Type Resource’s Employment Type
    Financial Location Resource’s Financial Location
    Email Resource’s Email Address
    Date Last Time Financial Plans Edited Date the Resource last made a Financial Plan edit
    Date of last entry on a Timesheet Date the Resource last made an entry on a timesheet
    Created Date Date the resource was added to the system
    Date of Hire Resource’s Date of Hire
    Date of Termination Resource’s Date of Termination
    Financial Department Resource’s Financial Department
    Home Page Resource’s Home Page
    Language Default Language of the Resource
    Primary role Resource’s Primary Role
    Resource manager Resource’s Manager
    Track Mode Resource’s Track Mode
    User Name Resource’s Username
  • The User Activity portlet is in essence an expansion of the out of the box User List by License Type portlet, which only display the Last Logged In date of resources.  This portlet offers several additional fields to help admins dig deeper into user activity within the tool. The table below describes the available filter fields for the portlet.
    Column Label Description
    OBS OBS the resource(s) belong to
    Resource Full Name Resource’s First and Last Name
    Resource ID Resource’s ID
    First Name Resource’s First Name
    Last Name Resource’s Last Name
    Date Last Logged In Date the Resource last logged in
    Date Last Time Investment Updated Date the Resource last made an Investment update
    Resource Active The Resource’s active status
    Employment Type Resource’s Employment Type
    Financial Location Resource’s Financial Location
    Email Resource’s Email Address
    Date Last Time Financial Plans Edited Date the Resource last made a Financial Plan edit
    Date of last entry on a Timesheet Date the Resource last made an entry on a timesheet
    Created Date Date the resource was added to the system
    Date of Hire Resource’s Date of Hire
    Date of Termination Resource’s Date of Termination
    Financial Department Resource’s Financial Department
    Home Page Resource’s Home Page
    Language Default Language of the Resource
    Primary role Resource’s Primary Role
    Resource manager Resource’s Manager
    Track Mode Resource’s Track Mode
    User Name Resource’s Username
  • The User Activity portlet is in essence an expansion of the out of the box User List by License Type portlet, which only display the Last Logged In date of resources.  This portlet offers several additional fields to help admins dig deeper into user activity within the tool. The table below describes the available filter fields for the portlet.
    Column Label Description
    OBS OBS the resource(s) belong to
    Resource Full Name Resource’s First and Last Name
    Resource ID Resource’s ID
    First Name Resource’s First Name
    Last Name Resource’s Last Name
    Date Last Logged In Date the Resource last logged in
    Date Last Time Investment Updated Date the Resource last made an Investment update
    Resource Active The Resource’s active status
    Employment Type Resource’s Employment Type
    Financial Location Resource’s Financial Location
    Email Resource’s Email Address
    Date Last Time Financial Plans Edited Date the Resource last made a Financial Plan edit
    Date of last entry on a Timesheet Date the Resource last made an entry on a timesheet
    Created Date Date the resource was added to the system
    Date of Hire Resource’s Date of Hire
    Date of Termination Resource’s Date of Termination
    Financial Department Resource’s Financial Department
    Home Page Resource’s Home Page
    Language Default Language of the Resource
    Primary role Resource’s Primary Role
    Resource manager Resource’s Manager
    Track Mode Resource’s Track Mode
    User Name Resource’s Username
  • The Users Logged In portlet displays all users logged into the system. This portlet is helpful to determine the capacity during peak times, users still working before downtime, and the ability to view users logged in during the day. The portlet will display the resource, ID, OBS unit, OBS path, and when the user’s session was last updated.
  • The Users Logged In portlet displays all users logged into the system. This portlet is helpful to determine the capacity during peak times, users still working before downtime, and the ability to view users logged in during the day. The portlet will display the resource, ID, OBS unit, OBS path, and when the user’s session was last updated.
  • The Users Logged In portlet displays all users logged into the system. This portlet is helpful to determine the capacity during peak times, users still working before downtime, and the ability to view users logged in during the day. The portlet will display the resource, ID, OBS unit, OBS path, and when the user’s session was last updated.
  • The Customized Object/Portlet Views portlet displays all user edited object/portlet views and the resource(s) that have edited them.  This can assist in identifying users who need to be notified prior to publishing view changes. The table below describes the available columns on the object.
    Column Label Description
    Resource Name Name of the resource
    Resource ID ID of the resource
    Type Object or Portlet
    Portlet Code ID of the portlet
    Portlet Name Name of the portlet
    Object Associated Object
    Object View ID of the modified view on the object
    Object Code Internal code used by the query
    pkid Internal code used by the query
    portlet_dbid Database id of the portlet
    res_dbid Database id of the resource
  • The Customized Object/Portlet Views portlet displays all user edited object/portlet views and the resource(s) that have edited them.  This can assist in identifying users who need to be notified prior to publishing view changes. The table below describes the available columns on the object.
    Column Label Description
    Resource Name Name of the resource
    Resource ID ID of the resource
    Type Object or Portlet
    Portlet Code ID of the portlet
    Portlet Name Name of the portlet
    Object Associated Object
    Object View ID of the modified view on the object
    Object Code Internal code used by the query
    pkid Internal code used by the query
    portlet_dbid Database id of the portlet
    res_dbid Database id of the resource
  • Course Description:   This session will walk you through a step-by-step approach to doing application rationalization within your organization. We will also review how to sell the benefits and processes within your organization.
  • 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.
  • The Using Consistent Colors technical trick shows how management can create a uniform color pallet for all charts within the system. This trick, not only makes charts more professional when delivering to management, but also creates a uniform pattern throughout the Clarity environment.
  • A Quick Reference Card to assist in the use of list views in CA PPM.  List Views are accessed from the Home menu.
  • A guide to using RegoXchange, the Clarity content library.  Goes through Registration, Finding Content, and Downloading the files.
  • A tech trick document that assists you in update Data Source when utilizing the Power BI reports found in RegoXchange.
  • A presentation slide deck from Rego University 2022.   This course reviewed the advantages of using REST APIs in Clarity development.
    • Overview
      • Why REST now?
    • Clarity Rest Endpoints
      • Create Project with java.net.URL
      • Create Task with HttpClient
      • Update Project with java.net.URL
      • Update task with HttpClient
      • Create Task with RestApiJavaClient
    • External REST Endpoints
      • Connect with java.net.url
      • Connect with Apache Commons HTTP/S Client
    • Additional Tools
  • "Learn how to use, and follow best practices with the Clarity REST APIs
    • Execute a REST Call
    • Create JSON payloads and parse JSON responses
    • Capture the result of the request"
  • Learn how to use, and follow best practices with the Clarity REST APIs - Execute a REST Call - Create JSON payloads and parse JSON responses - Capture the result of the request
  • A Quick Reference Guide that provides an overview of the Common Grid components in Clarity PPM’s Modern UX.   Looks at functionality of the Common Grid view, View Options, Adjusting Columns, Details Panel, and Group by Mode.
  • When configuring the Timesheet Options, the browse window for selecting a lookup on the User Value 1 field only shows a choice of one lookup definition and that is the definition for the stock 'Time Entry User Value 1' Static Lookup. We want to develop our own user-defined dynamic query lookup for use on this field. How can we get this to work properly?  Are there any special requirements or configuration considerations that should be reviewed in understanding this functionality for using a custom Time Entry User Value 1 dynamic query lookup? The use of a custom, dynamic lookup on the Timesheet Entry is available with specific requirements and special considerations for storing and displaying data for this field.  It is recommended that you use the stock, 'Time Entry User Value 1' Static Lookup if possible.
  • With ValueOps Insights you can gain transparency into full value stream analytics. Come learn about metrics to run your business including flow metrics, DORA, and value realization metrics that give your management team a compass to find the value your teams are delivering.
  • A presentation slide deck from Rego University 2022.   Broadcom’s presentation on customer stories in the ValueOps arena.
    • Introduction
    • A note on Customer Case studies
    • Transforming Customer
      • Profile and Solution Use Case Objectives
      • Solution Configuration Diagram
      • Lessons Learned through adoption
      • Q&A
    • Kitchen Sink Customer
      • Profile and Solution Use Case Objectives
      • Solution Configuration Diagram
      • Lessons Learned through adoption
      • Q&A
  • When a team member is added to the Team tab of the project, this process will add Project -  View Management and Resource – Hard Book instance access right to the team member’s profile. This allows the team member to add their own allocations. NOTE: The process is NOT auto-start, and hence, needs to be run manually from Home > Organizer > Processes > Available
  • When a team member is added to the Team tab of the project, this process will add Project -  View Management and Resource – Hard Book instance access right to the team member’s profile. This allows the team member to add their own allocations. NOTE: The process is NOT auto-start, and hence, needs to be run manually from Home > Organizer > Processes > Available
  • View Rate Matrix is a grid portlet that provides users a single place to view all the rates defined across multiple rate matrix without going to administration tab. Each Matrix may be defined with different columns (ex: Charge Code, Client, Department, Entity, Input type Code etc). This portlet dynamically brings only the columns associated with that rate matrix and provides the detailed information. User can view information related to one matrix at a time.
  • View Rate Matrix is a grid portlet that provides users a single place to view all the rates defined across multiple rate matrix without going to administration tab. Each Matrix may be defined with different columns (ex: Charge Code, Client, Department, Entity, Input type Code etc). This portlet dynamically brings only the columns associated with that rate matrix and provides the detailed information. User can view information related to one matrix at a time.
  • View Rate Matrix is a grid portlet that provides users a single place to view all the rates defined across multiple rate matrix without going to administration tab. Each Matrix may be defined with different columns (ex: Charge Code, Client, Department, Entity, Input type Code etc). This portlet dynamically brings only the columns associated with that rate matrix and provides the detailed information. User can view information related to one matrix at a time.
  • Are you struggling to come up with a visualization strategy with all of the options available - widgets, portlets, Jaspersoft, Ad Hoc, etc? This class will explore the various visualization tools available in Clarity and help you understand the best way to output your data. We will provide use cases and examples to assist you in developing a strategy for your organization.
  • A presentation slide deck from RegoU 2023.  This course covered the various visualization tools available in Clarity and help you understand the best way to output your data.
  • Are you looking for some great examples of dashboards? We know you can’t get enough of them and neither can we! Come to this session to see a host of new reports that Rego has created! This session will review a host of pre-built dashboards in use today that can spark ideas for you to implement in your company. Learn about the Rego approach and method for how we prioritized which reports to create and how we gathered requirements from our Rego experts to target content you need!
  • Wabtec shares how they utilized Clarity and Power BI to build an enhanced Resource Management monitoring solution.
  • 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
    • 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
  • 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
    • 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
  • 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
    • 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
Go to Top