This topic contains 6 replies, has 3 voices, and was last updated by Thomas Boyle 3 months, 1 week ago.
11/05/2017 at 2:35 am #411145
I have queries regarding MS Project Dashboards. It will be really great if I can contact an Expert. We have set up MS Project based PMO for our client as its a really huge PMO with a lot of cross-dependencies Client leadership will need to look at reports that will quickly provide them how the impact on one of the dependent project affects the other. Network diagram and Tracking Gantt views are not very helpful because the leadership team needs only the overall picture they are not happy with those views. I couldn’t find any proper Dashboard that can serve the purpose.
Can you please help me out here. As this a very urgent scenario.
Looking forward to your response!11/05/2017 at 3:08 am #411146
I am assuming that for the projects you need to report on, you have made a master project and sub-project structure. From there, you can use the MS project interface to build a dashboard to suit your leadership team needs. Using Report tab, you can create custom views of your data, or use the Visual Reports options to export charts and graphs in Excel or Visio format. Then there are add-ins or apps like this that automate the creation of different data displays: https://kidasa.com. Hope that helps!
Jigs11/05/2017 at 9:32 am #411147
Thanks for your quick response Jigs. I have multiple queries.
Yes, we created a master project sub project relationship. I know that we can create Dashboards using Report tab in MS Project and we have created few reports for them. But my question is very specific on showing cross-dependency impact in Dashboards. Eg: If there is an initiative with 5 predecessors (direct or indirect) and 5 Successors (Direct or Indirect) is it possible in MS Project Reports to click on a task and it should display only its predecessors and successors (Direct and Indirect). Also, I will need to view the dependency at the initiative level although the actual dependency is made at the task level.If the Dashboard is not an option at all then can I achieve this in views?
Also, can we use indicators or color code in the dashboard for the task status? It seems like indicators can be used only in views that too has a restriction that custom field formula and indicators won’t work for subproject in the master project.Is this a limitation in MS Project?11/05/2017 at 10:13 am #411148
Well, for problem #1 above, you might find the add-in Pathfinder helpful for identifying (filtering) on predecessors and successors, or you have to write your own macro for that.
For problem # 2 above, yes, status indicators such as a RAG indicator formula can be put into a custom field, and then you add that custom field to the Global.Mpt using the Organizer, and then add that to a column in the master plan, and you will see the indicator in both the master plan and subproject rows when undisclosed.
Hope that helps!
Jigs11/05/2017 at 3:04 pm #411149
Thanks a lot! Jigs,
Got a macro that works perfectly to filter out dependent tasks within a subproject. As I am using this in Master Project dependency will appear as a path to the other file and the macro is not working.
Following is the code used. Is there any solution to this problem
Dim T As Task
Dim I As Long
‘Clear the existing filter
‘Capture the selected task
I = Application.ActiveCell.Task.UniqueID
‘Flag the Predecessors and Successors
For Each T In ActiveProject.Tasks
T.Text10 = “”
If T.UniqueID = I Then
T.Text10 = “Selected Task”
If T.PathPredecessor = True Then
T.Text10 = “Predecessor”
If T.PathSuccessor = True Then
T.Text10 = “Successor”
‘Apply a filter on the flagged tasks
SetAutoFilter FieldName:=”Text10″, FilterType:=pjAutoFilterIn, _
Criteria1:=”Predecessor” & Chr$(9) & “Successor” & Chr$(9) & “Selected Task”
End Sub11/05/2017 at 8:58 pm #411150
Sorry Gopika, can’t help ya with that one; hopefully a coder will chime in.11/10/2017 at 6:05 pm #411200
Your macro is based on Task Path. Does the Task Path bar highlighter work across subprojects? If so, then your macro “should” work. (I can’t test because I’m on MSP 2010).
If Task Path isn’t working across subprojects, then you’ll need a logic-tracing add-in. Look for Pathfinder, ProjectProCorp, projectwidgets.com, Opdec, or BPC Logic Filter. (The last is one my company developed for internal use, but we do share it.)