Primavera’s custom Activity filters are great for focusing in on a subcontractor’s work list or even to hide Activities that are already completed. But when it comes to filtering down a 5000 line project plan to Activities in a specific timeframe, P6’s filters fall flat. Here’s the Gotcha: any filter that uses a rolling date or P5 / P6’s built-in date variables will not work when exporting P6 data to Excel.
What variables are you talking about?
P6 has the following 6 built-in date variables that can be used when building custom filters:
- PS : Earliest Project Start
- PF : Latest Project Finish
- DD : Data Date
- CD : the current date (according to Windows)
- CW : the current week
- CM : the current month
The workaround is pretty simple. Copy the filter to create a version specifically for use when exporting data to excel. Replace the date variables with specific date values in your filter for the current time period. Proceed with the export to excel.
Although you’ll have to edit the dates in this filter over and over during the project , it’s much easier to filter Activities in P6 than it is to try to filter them in Excel.
Oracle has yet to resolve this P6 Gotcha, so make sure you drop them a line – “Dear Oracle….”