Jasper Report with WBS

[Marcos Domingos]

Hi everyone!

I have the mission of creating a Report in Jasper that returns the Tasks of a Project with the WBS column and others.

I still haven't been able to create the T-SQL Script that returns the WBS column numbered and ordered as it is in Clarity.

Has anyone done it or have any tips that can help?

 

Thanks

[Liz Williamson]

Hi Marcos.

Are you querying the PPM schema or the DWH schema?

The PPM schema, prtask table holds the sequence but it is built from several different columns.

[Marcos Domingos]

Hi. Yes, I was looking at the PPM Schema. I couldn't identify the logic between the Columns that could help return the same way as in Clarity.

I didn't check if there is a Table in the DWH with the numbering and ordering already built.

[Liz Williamson]

Marcos,

I do not think there is anything in the DWH to identify the wbs sequence.

In the prtask table fields such as

PRWBSLEVEL - tells which level

WBS_NNBSEQ - tells the next branch in the sequence

WBS_PARSEQ - parent task

You can check the PRTASK table it does explain these.

You also can do an action trace on a small wbs with children and see the query it returns.

PRWBSSEQUENCE - sequence in the level