Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Large Activity Filter

9 replies [Last post]
Rodney Jones
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 18 Jun 2012
Posts: 62
Groups: None

Hi All you Brainiacs!

 

Have any of you found a way to autocreate a large filter? I have about 75 Materials Delivery milestones and I want to show their Successor/s

 

So my filter terms would be:

Where Predecessor = (insert Milestone id)

or

Where Predecessor = (insert Milestone id)

etc,etc,etc. for the whole 75 Milestones.

 

Thanks,

 

Rod

Replies

Rodel Marasigan
User offline. Last seen 22 hours 1 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699

I believed you are looking for a mutiple float path filter. Create a single milestone end date of all last successor of all procurement items for this exercise. Connect all last successors to this milestone then run the Critical multiple float path and select free float then select this milestone. Say 10 number of float path to calculate, then filter "Float path not equal to {blank}"

Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

just add the detailed predcessor as a column to your filter

Rodney Jones
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 18 Jun 2012
Posts: 62
Groups: None

Hi Again Guys,

I haven't explained properly.

I have Procurement activities with UDF Activity code - Discipline, Disciplines = Civil or Structural or Procurement.

I am trying to create a filter that shows the Procurement Activities and it's Successor/s.

So I can get:

Where Discipline = Procurement (gives me all the Procurement Activities) but I can't work out how to include the Successors.

I don't want to modify any Activity IDs or Activity Names.

Or I can go:

Where Predecessor Details includes 'FIM' or 'ROS' or 'FAB' (all of which are Procurement Activity id Prefixes) but still don't know how to show the actual Successors.

 

Please!!! Hahaha.

 

Rod

Rodney Jones
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 18 Jun 2012
Posts: 62
Groups: None

Hi Zoltan and Rodel,

Ahhh, Of Course! I use a few UDF's for that very purpose, just didn't extend the concept. Cheers!

David, Hahahahaha, nah, I'll run with the other idea but thanks.

 

Rod

Rodney Jones
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 18 Jun 2012
Posts: 62
Groups: None

Hi Zoltan and Rodel,

Ahhh, Of Course! I use a few UDF's for that very purpose, just didn't extend the concept. Cheers!

David, Hahahahaha, nah, I'll run with the other idea but thanks.

 

Rod

Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

there should a common word in the activity description that you can filter on or just a create an actviity code and assign it to the activities. 

Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

there should a common word in the activity description that you can filter on or just a create an actviity code and assign it to the activities. 

Rodel Marasigan
User offline. Last seen 22 hours 1 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699

I normally use codes or smart activity id to filter these so it's very easy to select.

For manually creating filter, use copy paste function while on filter creation and just change the criteria (i.e. Milestone ID)

david kelly
User offline. Last seen 1 day 3 hours ago. Offline
Joined: 12 Feb 2016
Posts: 33
Groups: None

Easy-easy, Rod. You need a copy of Primavera SureTrak, circa 1995. ($300)

Or create 75 filters for P6 ($3000)