I would like to pull out total data for a WBS level 1 task based on the child tasks down to a WBS level of 3 or 4 meaning 1.1.1.1. As far as I can tell the database that ARB pulls data from doesn't do this automatically all the parent tasks end up with a value of 0 for Planned Labor Revenue, Actual Work Cost and the like. I would use total Planned Labor Revenue except this is by project by task.
I was wondering if there is a way to do inner joins in ARB to allow me to join the parent and child tasks in a row and total the data. I don't really have time to learn Cognos SQL, but if that is my only option I will. As far as I can tell the ARB query manager only allows me to join two queries, but I have 3 levels of parent and child tasks, which means I need 3 inner joins to get the data I want.