Do Agile Companies Really See Significant Results?  | Learn with Rego

Document created by navzjoshi00 Champion on Nov 10, 2016Last modified by navzjoshi00 Champion on Feb 3, 2017
Version 2Show Document
  • View in full screen mode

Dear Community Members,

 

In today's Q&A, we'll guide you through a few CA PPM (Clarity) tasks you've asked about, like how to prevent timesheets from posting to closed projects.

 

We also just had seats open up for a Resource Management BrightTALK with LabCorp. They'll share the IT approach we helped them develop in CA PPM that powerfully improved Resource Management and their ability to respond to business needs. The event is live on December 1st @ 1:00PM EST.

 

You may be asking if Agile companies really see significant results. Forrester crunched the numbers and you can read the 2016 data on Agile companies here: 2016 Agile Report, Forrester.

 

If you've found early success with Agile, you'll be interested in a bimodal webinar available December 6th @ 12:00PM EST discussing bet practices for managing, scaling, and running Agile alongside Waterfall. You'll hear about how a major grocery store chain successfully made the bimodal transition.

 

Before we move on to our Q&A, we'd like to invite you to join us at CA World next week. Our main Booth is 6007, and you'll find our regoUniversity technical, functional, and governance training at Booth 6002, and our Agile with Icon Booth at space 6005. Several additional free trainings and events, like a half-day of Portfolio Management or Jaspersoft Training is available at the bottom of this Q&A. 

 

Q&A Summary

 

1. Why are hyperlinks misdirecting from Export to Excel links? 

 

2. What's the best way to add a Conditional Attribute/Field to a Portlet?

 

3. Troubleshooting a querywhy is this expression failing? 

 

4. How can we prevent timesheets from posting to closed projects?

 

5. After moving from template to project, why are our roles names shrunk and appended with a number? 

 

Please feel free to comment on any alternative answers you've found.

 

We love your input (always).

 

 

1.

Why are hyperlinks misdirecting from Export to Excel links?
We have an OD system with Federated SSO. When we export to excel and click on one of the links (i.e. project properties), we get the following page, not the Clarity page we should see.

Answer

CA posted the solution in a CA Clarity Tuesday Tip by Ruchika Israni. Read it here:  

 

CA Clarity Tuesday Tip - Hyperlinks in exported Excel or email notifications are redirecting to the OnDemand Portal when SSO enabled

 

2.

What's the best way to add a conditional attribute/field to a portlet?
I have a requirement to add a conditional field to a portlet. In this case, I’m going to show 1 of 3 attributes in a single column based on the parameter value that a user passes through their filter selection.
 
This can be accomplished by combining separate queries (and using UNIONs) but in an attempt to cut down on code, I was wondering if anyone had accomplished this using another method.

Answer

The best method is to use the parameter @Where.... @ incorporated into a CASE statement. 

 

3.

Troubleshooting a query. Why is this expression failing?
The server has encountered an error. Please excuse the inconvenience.
Error Message
Error filling report
Error Message
net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: $P{amountType} == "Hours" && ($F{BASELINE_HOURS} != null || $F{BASELINE_HOURS} != 0 || $F{ACTUAL_HOURS} != null) ? $F{ACTUAL_HOURS}.divide($F{BASELINE_HOURS},2) : $P{amountType} != "Hours" && ($F{BASELINE_COST} != null || $F{BASELINE_COST} != 0 || $F{ACTUAL_COST} != null) ? $F{ACTUAL_COST}.divide($F{BASELINE_COST},2) : 0

I thought at first it may be a null or divide by zero issue, which is why I added all the pre-checks for null and 0. The query runs for a long time, before it fails, so it’s definitely something to do with a value for some row coming back, but not sure what else would kill it.  Thoughts?

 Answer

It was indeed a divide by 0 issue.  
($F{BASELINE_HOURS} != null || $F{BASELINE_HOURS} != 0 || $F{ACTUAL_HOURS} != null)

 

Should be:
($F{BASELINE_HOURS} != null && $F{BASELINE_HOURS} != 0)

 

Whoops

 

4.

How can we prevent Invalid Transactions when timesheets post to closed projects? Is there a good method for making sure project time has all been accounted for before closing a project? 
 Answer
1.    Business Process (requires some disciple on the human side to make it work).
2.    Clarity Process. There are several avenues. 
    o Write or use the Project Close Process Rego has to keep the Project open, and only close it when all timesheets are submitted.
    o Write a process that prevents the submission of a timesheet if there is a closed project on it.
    o If transactions are required, then a process can open the project, run the transactions, and close it again.
3.    Create a report or portlet that shows pending actuals for projects. If they are pending that means they are entered on an unposted timesheet.

 

5.

We have an issue with role names being changed on template to project.
It is just the roles' requirement name, and it is being stopped at a certain, consistent, amount of characters, and a (1) is appended to it.

 

Since it is just a name change I am going to run a process that updates the system prteam.requirement_name.

 

Then I will have it available to run on a per project basis, on the project itself.

 

Can I update the requirement role directly, or do I have to use xog?  Again, we are only changing the name. I would do a search on the first characters before it gets cut off, then replace with the role name from srm_resources.full_name.

 

Can I update it directly, or does this for some reason store the name in multiple places?
Answer 1
This is normal functionality that has been in the tool since we stopped allowing over allocation of roles and allowed users to staff the same role multiple times. The numbers are added so you know which ones are assigned to what task on the project.

 

Answer 2
You’re okay to update the prteam.requirement_name through SQL. This field isn’t stored anywhere else.

 

THANK YOU------------------------------  

A special thanks to Jenn Rinella, Ben Rimmasch, Chris Wuenstel, Darren Greer, Ramesh Rathnam, Dave Matzdorf, Chris Shaffer, Ken Armstrong, Mike GillespieDanny MassiminiMindy Calderonand the Rego Team for this Q/A material.

TRAINING------------------------------  

Jaspersoft 6.2.1 has new features! See what's new. 

 

Webinar | MEISTERPLAN Resource Planning: From Pain to Gain. Presented by Scott McLaughlin from Citrix and Stephan Anders from itdesign with Rego Consulting.

 

 

 

Half-day classes in Jaspersoft or Portfolio Management are Free and Limited.

 

 

 Rego is releasing 50 CA PPM training items to celebrate the Countdown to CA World! 

  

/external-link.jspa?url=http%3A%2F%2Fevent.on24.com%2Fwcc%2Fr%2F1273181%2FBC00967860026EE0F96A53157C82C86D%3Fcommunity%3Dqa.LoadDWHjob.AutoNumberID.fintrans.WIP.obs 

Agility is now a prerequisite for successful firms and enterprise architecture professionals . . .  

 

JOIN US------------------------------  

BrightTALK | How LabCorp Improved Resource Management with CA PPM December 1, 2016 @ 1:00PM EST

For healthcare companies, managing priorities, projects and resources can be a critical factor in getting to market faster, improving patient outcomes and even saving lives. For LabCorp, working with Rego Consulting to develop an innovative new approach to IT Resource Management—using CA PPM—has powerfully improved their IT Organization’s ability to respond to business needs in delivering solutions. Join LabCorp’s Paul Soper, along with Rob Greca from Rego Consulting and Walter Angus from CA Technologies, to learn how LabCorp utilized data they were already collecting to develop IT labor capacity and supply/demand balancing without creating new business processes. 

  

Webinar | Scale Agile to Run with Waterfall

December 6, 2016 @ 12:00PM EST

Best practices for managing, scaling, and running Agile alongside Waterfall. Hear about how a major grocery store chain successfully made the transition.

 

regoUniversity 2017 at La Cantera Resort & Spa -

San Antonio, TX: April 23-27, 2017. 

Hands-on CA PPM Training with over one hundred companies who use the tool daily.

Click here for Early Bird Pricing.

Attachments

    Outcomes