In today's Q&A, we'll guide you through the resolution of five Clarity PPM (CA PPM) issues we've seen crop up from time to time, like why you might get the "invalid relational operator" in GEL and how to handle a resource rate that varies by investment type.
We also have a week's worth of new releases available from the regoXchange in our Countdown to CA World 2016, including the deck for a Resource Management Course and free quick reference cards for Accessing Resources and Creating Custom Filters, Adding Resource Skills, Configuring the Resource List, and Managing Resource Allocations. The whole list is here.
You can find several additional free trainings and events, like a half-day of Portfolio Management help and regoUniversity technical, functional, and governance training for Clarity PPM, at the bottom of this post.
Q&A Summary
1. Why are my Relational Operators (in SQL inside GEL) invalid?
2. How can we set up the Rate Matrix to account for resources whose rates vary by investment?
3. How do you Remove ETC from an "Effort Task"?
4. Can we re-order Input Controls?
5. How do you get the "Relative Date" in an Input Control?
Please feel free to comment on any alternative answers you've found in the CA Community posting here. We love your input (always).
1. I know this used to work, but I’m getting an “invalid relational operator” error in GEL when trying to do the simple query below using a "less than" sign. It’s inside CDATA tags. Version 14.3. Thoughts??
<sql:query var="results"><![CDATA[
SELECT prstart
FROM prtimeperiod
WHERE prestart < (ADD_MONTHS((LAST_DAY(SYSDATE)+1),-1) - ?)
]]>
<sql:param>${p_close_nbr}</sql:param>
</sql:query>
Answer
Remember the escapeText=”false”
2. We have a resource whose rate varies by investment. Is there a way to handle this in the Rate Matrix? We don’t have Investment as an option in the Default matrix. What config(s) should we change/update to get Investment included in the rate matrix?
Answer
Add investment in the rate matrix. Simply open the Rate Matrix and from the Assign Columns tab, select Investment > Add > Save.
3. A project is complete, so I want to remove ETC from an Assignment on an auto-created “Effort Task.” When I change the ETC to zero or just “delete” it, the ETC hours come right back. From what I’ve read through google searches, the ETC can’t be removed, but I refuse to believe this. Anyone know of a work around? We aren't using OWB/MSP, so those aren’t options.
Answer
It appears the only way to wipe out the allocation of the resource is from the Team tab. As soon as you do this, the ETC goes to 0.
4. Is there a way to re-order Input Controls?
Answer
You can reorder via studio, if you click and drag. Sometimes it won’t allow you to re-order . . . however, if you restart and go directly to the repository and try again, it should fix itself and allow you to move them.
5. Built in function in BO doesn’t appear to be in Jaspersoft. Curious if anyone has built the input control in JS and the logic in the query yet?
Answer
There is relative date. On the date it has a small tool tip saying if you put ‘WEEK’ it will get the relative date.
Here are two articles you can also reference:
http://community.jaspersoft.com/wiki/how-change-start-day-week-relative-dates
http://community.jaspersoft.com/questions/803328/relative-dates-daterange-class
THANK YOU------------------------------
A special thanks to David Zywiec, Ben Rimmasch, Ross Hensel, Michael Meyers, and the Rego Team for this Q/A material.
Face-to-Face Clarity PPM Training
Our clients wanted us to create a forum for them to network with their peers, engage in debates and knowledge sharing, be taught best practices, and not feel like they were being sold something. In response to this, we created regoUniversity. Every year we gather the brightest minds in the Clarity PPM industry in one place with over 100 different companies represented. We learn together in interactive classes where the instructors and students share lessons learned and best practices based on experience.
RegoUniversity 2017 will be held at La Cantera Resort & Spa - San Antonio, TX: April 23-27, 2017. Early bird pricing is available for a limited time.
Let Rego Be Your Guide
Join us live and in-person at RegoUniversity in San Diego Sept 29-Oct 2 and learn from the expert guides who deliver Clarity PPM and Agile services to 60% of Fortune 20 companies. Act now to save $300 on Early Bird Pricing until July 1st.
Rego also offers free health assessments, webinars, and half-day training classes for Clarity PPM on Roadmaps in the Modern UX, Power BI, Portfolio Management, and Jaspersoft.
For a full list of Clarity Services, visit regoconsulting.com.
