Clarity PPM

What you may have missed in the CA Project and Portfolio Management Community! December 2015

By Christopher Hackett posted 01-06-2016 07:07 PM


Dear Community Member,


Welcome to the New Year!


With so much going on in the CA Project and Portfolio Management Community I have consolidated recent activities in case you missed anything.


Ask a Question, Get a Response - Unanswered Question? Offer a Solution (Jan 4 - Jan 8)

It's great that we have such a vibrant community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every members' question so that no one goes away "empty handed". To help further responses to all questions I am starting the following campaign.




CA PPM Product Survey is OPEN!

Everyone - Please take a moment and provide your feedback!You may choose to leave your contact information or remain anonymous. The Product Management leadership team will review the survey results to create action plans designed to further improve the overall experience and value you receive from your investment with CA Technologies.Candid feedback from our customers is one of the most important tools we use to advise product development. In addition to product management, your feedback is immediately accessible by executive management teams who are always looking to improve your customer experience. This survey opportunity will be opened until Mid January. All users are encouraged to participate.

CA PPM Survey Link:




CA PPM Office Hours: A Live Online Chat (January 2016)

Have a question about CA Project and Portfolio Management? Connect with CA Technologies technical experts to get answers via Office Hours for CA PPM. Our team is here to help you get more out of your technology. Join us for one hour Thursday, January 14th @ 1 PM ET. NOTE - No audio is provided and all Q&A happens via online chat, making it a truly ‘fun’ event.


CA Education


CA PPM 14.3 Training Update

Happy New Year from CA Education!  Here’s a quick end-of-year update on training for CA PPM 14.3. Courses for the following topics are available now.  They all have multiple delivery methods to fit your training needs!


Community Member Blogs


How To: Single Textbox "Page {X} of {Y}" Page Counts in Jaspersoft Reports

When migrating our reports from Business Objects to Jaspersoft it's important for us to abide by our documented reporting standards, retaining the same look & feel that our customers are familiar with.


Search All NSQL And GEL Scripts

Many of you might have come across scenarios where you are removing/modifying an attribute and you want to know where all this attribute is being used at present, taking into consideration any NSQLs or GEL Scripts in CA PPM. Or just like my present scenario when it is the year end and I want to know if the last year is hard-coded in any of the GEL Scripts or NSQL (be it NSQL for a portlet or a lookup). The following Oracle SQL queries will help you in such scenarios.


Clarity PPM Login History

Suppose one fine day, you feel like checking the user login history of your Clarity application. Where will you go to get the list of users who had logged into Clarity, along with their login dates and the number of times each user had logged-in? CA PPM, traditionally stores session information in two database tables but each has its own disadvantages.


Most Viewed Portlets In Clarity PPM

Ever wondered how to get the list of top viewed or most commonly used Clarity portlets/pages in your organization? Your only chances were either to analyze all the app_access logs on the Clarity server or to use the resource-heavy Performance Tracking feature in CSA. But if you are running a Tomcat application server for your Clarity installation and your Clarity version is v14.1 or higher, then you can get your hands on this information pretty much easily. Interested? Read on...


How To Create A Filter Portlet

Many of you, even after working several years in Clarity PPM, might not have got a chance to build a filter portlet. Even if you disagree, thats my case for sure. So while creating all those Grid, HTML, Xcelsius portlets in the past 5 years, I always wondered when will I get the chance to make a Filter Portlet. The requirement never came from any of the clients and I was too lazy to try it without any real need for it.





available worldwide

8am - 6pm

US Eastern Time

Additional Times May Apply

Featured Community Member


Once a month we'll shine our virtual spotlight on one of the CA PPM community's members. It's just a fun, easy way for us to get to know one another a little bit beyond our work-related interactions here on the site. This month, we're featuring mike2.2 , Manager, Clarity Support and Training.



Thank you for all your contributions to the community Mike!


Tech Tips and other Helpful Information


Tip: Filter Team lists to hide old/finished allocations

Community Hack - Following via RSS Feeds

CA PPM Tech Tip: 2015 List of Posted Tips

CA PPM Tech Tip: Including Dynamic Query Lookup Attributes in the Data Warehouse

Jaspersoft error : java.lang.NoClassDefFoundError: Could not initialize class net.sf.jasperreports.engine.util.JRStyledTextParser

Solution to "Sync'ed 0 users of total XXXX Users"

CA PPM Solution Pack (CSP) for Business Objects Reporting Add-in End of Life Announcement

Replacing one role with another in bulk on tasks

Agile Management Opening Keynote Address

Leveraging Full Adoption for Demand Management and Capacity Planning

Agile 101 for the Enterprise

Removing the Friction Between PPM and Agile

PMO in an Agile World

Panel Discussion: Migrating to 14.2 and Advanced Reporting

Foundations of the Scaled Agile Framework

CA PPM : Aligning Projects With Strategy

CA World '15: Women in Technology Breakfast

PPM On-Prem Administrators: How to Set JVM Options for Jaspersoft Servers


Top Ten Ideas


Make TIMESHEET a studio object359UNDER REVIEW

Archiving of old data222UNDER REVIEW

Auto-save or notify to save when changing screens211UNDER REVIEW

Ability to make OBS mandatory187DELIVERED

Present pop-up messages to the user174UNDER REVIEW

Seperate Delete Permission from Edit Permission Consistently on all Objects167UNDER REVIEW

Resource – Timesheet View Permission152UNDER REVIEW

Ability to Save Portlet Configuration as a Part of a Filter127UNDER REVIEW

Replace outdated Blob, Time Slice and Datamart technology with modern Database Sparse Matrices and Data Cubes124UNDER REVIEW

Powerfilter, query on null113UNDER REVIEW



That's it for now folks but I'm sure there will be a lot more soon! Take a moment to get in on the discussions in Clarity PPM and make your voice heard!




Community Manager, IT Business Management


winter rain.jpeg