SPM PPM: Help with Report Conditions for Dependency records

[GPenetito]

Hi team, I am wanting to produce a report that shows all of the Cross-Programme dependencies.

I am a lowly user, but I have a lot of experience producing reports using the standard reporting functionality.

The table that holds the data is  Planned Task Relationship [planned_task_rel_planned_task]

This holds both sides of the relationship (Parent = Predecessor and Child = Successor). To see only cross-programme dependencies (external) I need to be able to exclude the scenario where Parent Program = Child Program for a given relationship. There is nothing in the OOTB conditions that I can get to work.

Any ideas team? My sense is a potential coding solution (disappointing as will need developer help internally), but thought I would check with the experts first. This has made my brain hurt for a while

[PaulaaO]

Hi - if I understand your query correctly you don't want to see dependencies which have the same parent. There is a field on the table called "External relation".  You need to use this and have the value TRUE and this should show you the relationships between different parent records.

Hope this helps 🙂

[GPenetito]

Hi Paulaa. Thanks for responding. I already use the external relation = true. that will allow me to filter to all relationships between projects, but will also show me projects that have a relationship in the same program. I am only wanting to see relationships between projects from different programs

[PaulaaO]

I had a look now and could not find a way to create a filter to achieve what you want. I could bring up the columns in the report but the operator "is different from" is limited in its functionality. I think you're better off raising a case with SN Support to confirm if this is achievable at all. They should be able to help

[GPenetito]

Thanks for following up PaulaaO. That was experience also. Will have a chat to our Tech guys to see if there is a coding solution