If you've ever want to understand how % Complete is calculated or how to include the last_updated_by field in the DW for a sub-object, today is your day. Thanks to those who submitted the five questions below, and to our Rego guides for their knowledge-sharing.
And speaking of knowledge-sharing, if you have budget left for the year, it's not too late to jump on the early bird discount for CA PPM (Clarity) training at regoUniversity 2017. The event is
1. Is there a way to get the last_updated_by field included in the DWH for a sub-object?
2. GEL/XOG Help
3. What happens when you reference Draft Processes in a Process?
4. How is % Complete calculated?
5. Can you change the Sort order for the Actuals row in a Cost Plan?
Please feel free to comment on any alternative answers you've found.
We love your input (always).
Is there a way to get the last_updated_by field included in the DWH for a sub-object?
You can create a calculated field for this—as long as it's a string value—and then add it to DWH.
GEL/XOG Help: I'm getting the error pictured below. While I get the session ID at the beginning, I’m trying to get it again, to handle the XOG. I know that the default user name can successfully XOG because I can XOG via command prompt with that user.
I’m just trying to test that I can XOG in the resources I’m grabbing with 40 hours of ETCs before I calculate what ETCs they should have based on capacity.
You don't need the extra invoke.
We have a process referring to a draft process. The process still runs and executes effectively; however the sub process did not generate an instance or record that was run. Is this normal behavior?
Have you noticed that the CA PPM Help Menu discusses using Duration to calculate percent complete? Some people think this indicates when we're halfway through a task, we should be able to set the run the , and then churn out a value for the task. This doesn't seem to be the case. Instead it seems like the Duration method works a lot like the Manual method, expect for the fact that the attribute is calculated. Why?
The confusion around is probably due to the expectation that CA PPM will determine the percent complete relative to your start and finish date on a task or project. Instead calculates as follows.
Summary Task % Complete Total Detail Task Duration CompleteTotal Detail Task Duration.
For example, in one project two tasks both start 4/1/16 and finish 5/31/16. The duration of both is 41 days.
Let's enter complete on the second task.
A summary level task and the project level percent complete show complete.
Let's do the math.
Total Detail Task Duration Complete 41 Days1% .41 (based on this one task)
Total Detail Task Duration 82 Days (each task is 41 days)
Summary Task % Complete .41 82 .005.
Can you change the Sort order for the Actuals row in a Cost Plan? In the image below, you can see I have the Sort Order defined for Cost Plan Detail Object List Layout, so according to this, Cost Type should be grouped together. This is working correctly for the planned rows, but not for the Actuals rows.